FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Transforming Data Models Into Database Designs

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

To represent a one-to-many relationship in a relational database design ________.

A) the key of the child is placed as a foreign key into the parent
B) the key of the parent is placed as a foreign key into the child
C) an intersection table must be created
D) the key of the table on the "many" side is placed in the table on the "one" side
E) the keys of both tables are joined into a composite key

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

To represent a 1:1 binary relationship in a relational database design,the key of one table is placed into the second table.

Correct Answer

verified

Show Answer

Question 3

True/False

Review LaterAdd Note

The design transformation for all IS-A relationships can be summarized by the phrase "place the key of the parent table in the child table."

When transforming an ID-dependent E-R data model relationship into a relational database design and the parent entity has a surrogate primary key and the child entity has a data identifier,then the primary key of the child table should be ________.

When representing a 1:1 relationship in a relational database design ________.

What are the four sets of minimum cardinalities that can be present in a 1:N binary relationship?

One of the important properties of an attribute is whether or not it is required.

When the parent entity is required (M)in a relationship,every row of the child table must have a valid,non-null value of the foreign key.

To which of the following actions are referential integrity constraints not applied?

When transforming an E-R data model into a relational database design,the key of the parent entity should be placed as part of the primary key into the child entity ________.

To represent a 1:N relationship in a relational database design,an intersection table is created.

Each entity in the extended E-R model is represented as a table in the relational database design.

Explain the representation of a many-to-many strong entity relationship in a relational database design.

When the parent entity has a surrogate key,the enforcement actions are the same for both parent and child.

A surrogate key is a unique,system-supplied identifier used as the primary key of a table.

Each attribute of an entity becomes a(n) ________ of a table.

To represent an M:N relationship in a relational database design,a table is created to represent the relationship itself.

In many-to-many relationships in a relational database design the primary keys of both tables are joined into a composite primary key in the intersection table.

In a relational database design,all relationships are expressed by ________.

A referential integrity constraint policy that insures that foreign key values in a table are correctly maintained when there is a change to the primary key value in the parent table is called cascading changes.