Explain the representation of a many-to-many strong entity relationship in a relational database design

What will be an ideal response?


Many-to-many relationships cannot be directly represented in a relational database design. Therefore, many-to-many relationships are essentially broken into two one-to-many relationships by creating an intersection table that represents the relationship itself. The intersection table takes its key as a combination of the keys of the two original, or parent, entities. Each of the parent entities has a one-to-many relationship with the intersection table that is represented by placing the keys of the parents into the intersection table.

Business

You might also like to view...

Which of the following activities is most likely to have a cash flow effect?

a. Investing in money market funds b. Declaring cash dividends c. Reissuing treasury stock d. Issuing stock to acquire a patent

Business

Business buyers often develop ________, which are written descriptions of the quality, size, weight, warranty, and delivery requirements for a purchase

A) requests for quotations B) requests for proposals C) vendor analyses D) product specifications E) evaluative metrics

Business

The Toxic Substances Control Act regulates

a. chemicals other than pesticides, foods, drugs, and cosmetics. b. insecticides. c. natural gas. d. pesticides.

Business

If you marginal tax rate is likely to be lower in your retirement years, you should

A) prefer a tax-deductible IRA to Roth IRA. B) prefer a Roth IRA to a tax-deductible IRA. C) be indifferent between investing in a tax-deductible IRA or a Roth IRA. D) prefer a non-tax advantaged investment to either a tax-deductible IRA or a Roth IRA.

Business