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

True/False

Review LaterAdd Note

Review Later

Whether or not an attribute is required is determined during the database modeling phase.

Correct Answer

verified

False

Question 2

True/False

Review LaterAdd Note

Review Later

To represent an IS-A relationship in a relational database design,the IS-A relationship must be converted into a HAS-A relationship.

Correct Answer

verified

False

Question 3

Essay

Review LaterAdd Note

Write the database table design to represent the data model below,including tables,the proper placement of the foreign key,and referential integrity constraint.

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

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

The ideal primary key is short,numeric,and fixed.

What is an association relationship and how does it differ from an N:M relationship?

The values of a surrogate key have no meaning to the users.

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

A surrogate key is appropriate when the primary key of a table contains a lengthy text field.

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

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.

When transforming an extended E-R model into a relational database design,recursive relationships are treated fundamentally the same as other HAS-A relationships.

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 ________.

Which of the following is not true about a NULL attribute?

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

All identifying relationships are 1:N.

In many-to-many relationships in a relational database design,________.

To represent a one-to-many relationship in a relational database design,the key of the child table is placed as a foreign key into the other table.

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.