The rule for converting conceptual model relationships with maximum participation cardinalities of "many to many" into relational database tables is
A) Create a separate table identified by the key attribute of the entity that has the most instances.
B) Create a relation that can have no attributes of its own.
C) Post the key attribute of either entity into the relation of the other entity.
D) Post the key attribute of the table with mandatory participation into the table with optional participation.
E) Create a separate table identified by a concatenated primary key comprised of the key attributes from both entity tables.
Correct Answer:
Verified
Q23: In relational database design, the definition of
Q24: What potential problem exists in this table
Q25: In relational database design, a low load
Q26: When implementing the relationships of an entity-relationship
Q27: On average, 99 out of 100 sales
Q29: If you have two entities that are
Q30: Which example relational tables contain data that
Q31: Given the following set of relational database
Q32: Disregarding minimum cardinalities, when converting conceptual models
Q33: An auditor examined the database for Trent's
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents