Explain the representation of a one-to-many strong entity relationship in a relational database design
What will be an ideal response?
One-to-many relationships are represented by placing the primary key of the table on the one side of the relationship into the table on the many side of the relationship as a foreign key. The term parent refers to the table on the one side of a 1:N relationship, and the term child refers to the table on the many side of the 1:N relationship. Therefore, the rule for representing a one-to-many relationship can be summarized as "Place the key of the parent table in the child table as a foreign key."
You might also like to view...
Which method would an appraiser be most likely to use when appraising a newly built one year old apartment building with no rental history?
a. income approach b. cost approach c. capitalization approach d. market approach
Which of the following statements is true of the impact of new information systems on sales processes in the future?
A) Wearable technology can be used solely for buying products. B) Cloud-based CRM software can be used off site without installation. C) Social CRM will allow a vendor to control a customer's relationship with a business. D) The use of cloud-based CRM will be avoided as it has high start-up costs.