Recent Lessons

Show all results for ""

10 Questions

1 Views

chapter5

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?

{SNAME, PARTNO, PROJNAME} (C) Signup and view all the answers

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 (B) 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?

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

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

A foreign key representing the primary key of DEPARTMENT (A) Signup and view all the answers

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

A new relation with a foreign key from the participating entity type (B) 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?

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

What does the given ER schema represent?

A database schema for tracking ships (B) Signup and view all the answers