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 41

True/False

Review LaterAdd Note

Review Later

In a relational database design,all relationships are expressed by creating a foreign key.

Correct Answer

verified

Show Answer

Question 42

True/False

Review LaterAdd Note

Review Later

An intersection table is always ID-dependent on both of its parent tables.

Correct Answer

verified

Show Answer

Question 43

True/False

Review LaterAdd Note

To represent an M:N relationship in a relational database design,in essence it is reduced to two 1:N relationships.

The ideal primary key is ________.

Cascading deletions are generally not used with relationships for weak child entities.

The key of an intersection table is always the combination of the keys of both parents.

When the child entity is required (M)in a relationship,there needs to be at least one child row for each parent row at all times.

Data types are consistent across all DBMS products.

When creating a relational database design from E-R diagrams,first create a relation for each relationship.

Association tables sometimes connect more than two entities.

A default value is the value the user enters into the row the first time the user enters data.

In 1:N relationships,the table on the "one" side is called the parent.

If the parent is required,then a new child row must be created with a valid foreign key value.

When transforming supertype/subtype entities into a relational database design,an entity is created for the supertype only.

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

The binary constraint MUST NOT indicates that ________.

In 1:N relationships,the table on the "many" side is called the child.

Write the schema to represent the entities below,including tables,the proper placement of the foreign key,and referential integrity constraint.

When representing a one-to-many relationship in a relational database design ________.

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