10 Questions
In the given ER schema, what does the attribute DLOCATION represent?
A multivalued attribute LOCATIONS of DEPARTMENT
What is the primary key of the relation R in the given mapping?
{DNUMBER, DLOCATION}
In the mapping of the n-ary relationship type R, where n>2, what should be included as foreign key attributes in the new relation S?
The primary keys of the relations that represent the participating entity types
What is the primary key of the relation SUPPLY, which represents the ternary relationship type SUPPLY?
{SNAME, PARTNO, PROJNAME}
In the mapping of a binary M:N relationship type, what should be created?
A new relation with foreign keys from the participating entity types
What should be included as attributes in the new relation S, created for mapping an n-ary relationship type R, where n>2?
Any simple attributes of the n-ary relationship type
In the given ER schema, what does the attribute DNUMBER represent?
A foreign key representing the primary key of DEPARTMENT
In the mapping of a multivalued attribute, what should be created?
A new relation with a foreign key from the participating entity type
In the mapping of a binary 1:N relationship type, what should be included in the relation representing the N-side entity type?
A foreign key representing the primary key of the 1-side entity type
What does the given ER schema represent?
A database schema for tracking ships
Learn about the fifth step in ER-to-Relational Mapping Algorithm, which involves mapping regular binary M:N relationship types to new relations. These new relations include foreign key attributes linking the primary keys of participating entity types, forming the primary key of the new relation.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free