chapter5
10 Questions
1 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

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?

  • 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?

  • 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?

<p>{SNAME, PARTNO, PROJNAME} (C)</p> Signup and view all the answers

In the mapping of a binary M:N relationship type, what should be created?

<p>A new relation with foreign keys from the participating entity types (B)</p> Signup and view all the answers

What should be included as attributes in the new relation S, created for mapping an n-ary relationship type R, where n>2?

<p>Any simple attributes of the n-ary relationship type (D)</p> Signup and view all the answers

In the given ER schema, what does the attribute DNUMBER represent?

<p>A foreign key representing the primary key of DEPARTMENT (A)</p> Signup and view all the answers

In the mapping of a multivalued attribute, what should be created?

<p>A new relation with a foreign key from the participating entity type (B)</p> Signup and view all the answers

In the mapping of a binary 1:N relationship type, what should be included in the relation representing the N-side entity type?

<p>A foreign key representing the primary key of the 1-side entity type (A)</p> Signup and view all the answers

What does the given ER schema represent?

<p>A database schema for tracking ships (B)</p> Signup and view all the answers
Use Quizgecko on...
Browser
Browser