Converting a One-To-Many Unary Relationship into a Relational Database from an E-R

question 7

Multiple Choice

Converting a one-to-many unary relationship into a relational database from an E-R diagram ____.

• A) can be done by adding another copy of the unique identifier of the single entity's table into the same table with a different attribute name
• B) can be done by splitting the attributes of the single entity into two tables, each with its own copy of the unique identifier
• C) requires the creation of an additional table beyond the one that represents the single entity in the relationship
• D) a & b above
• E) a & c above

---

Definitions:

Interest Rate Parity

A theory which says that the difference between the interest rates of two countries is equal to the differential between the forward exchange rate and the spot exchange rate of their currencies.

Forward Rates

The predetermined interest rates or currency exchange rates agreed upon for transactions that will be executed at a future date.

Spot Rate

The existing market cost at which a certain asset is offered for buy or sell, ensuring immediate delivery.

Absolute Purchasing Power Parity

An economic theory that states the price of a good in one country should equal the price of the same good in another country when exchanged at the current exchange rate.