Podcast
Questions and Answers
In the given ER schema, what does the attribute DLOCATION represent?
In the given ER schema, what does the attribute DLOCATION represent?
- The foreign key of the DEPARTMENT relation
- The primary key of the DEPARTMENT relation
- A composite attribute of DEPARTMENT
- A multivalued attribute LOCATIONS of DEPARTMENT (correct)
What is the primary key of the relation R in the given mapping?
What is the primary key of the relation R in the given mapping?
- DLOCATION
- {DNUMBER}
- DNUMBER
- {DNUMBER, DLOCATION} (correct)
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?
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 composite attributes of the relations that represent the participating entity types
- The foreign keys of the relations that represent the participating entity types
- The primary keys of the relations that represent the participating entity types (correct)
- The multivalued attributes 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?
What is the primary key of the relation SUPPLY, which represents the ternary relationship type SUPPLY?
In the mapping of a binary M:N relationship type, what should be created?
In the mapping of a binary M:N relationship type, what should be created?
What should be included as attributes in the new relation S, created for mapping an n-ary relationship type R, where n>2?
What should be included as attributes in the new relation S, created for mapping an n-ary relationship type R, where n>2?
In the given ER schema, what does the attribute DNUMBER represent?
In the given ER schema, what does the attribute DNUMBER represent?
In the mapping of a multivalued attribute, what should be created?
In the mapping of a multivalued attribute, what should be created?
In the mapping of a binary 1:N relationship type, what should be included in the relation representing the N-side 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?
What does the given ER schema represent?
What does the given ER schema represent?