Question 1

How can you attempt to avoid the problem of creating a table that is not in third normal form?

Accepted Answer

The answer of How can you attempt to avoid the...

Question 2

An entity in a relationship with minimum cardinality of zero plays a(n) ____________________ role in the relationship.

Accepted Answer

The answer of An entity in a relationship with minimum...

Question 3

When the existence of one entity depends on the existence of another related entity, there is an existence ____________________.

Accepted Answer

The answer of When the existence of one entity depends...

Question 4

A subtype ____________________ is the specific attribute that determines the subtype-supertype relationship.

Accepted Answer

The answer of A subtype ____________________ is the specific attribute...

Question 5

In DBDL documentation, what element of a table is followed by an arrow pointing to the table identified by the element?

Accepted Answer

A)  columns 
B)  alternate keys 
C)  secondary keys 
D)  foreign keys

Question 6

After you have completed the first two steps for a given user view, you can merge the results into the cumulative design.

Accepted Answer

A) True 
 B)False

Question 7

If each employee works in a single department and each department has several employees, what is the relationship between departments and employees?

Accepted Answer

A)  one-to-one 
B)  one-to-many 
C)  many-to-one 
D)  many-to-many

Question 8

If a many-to-many-to-many relationship is created when it is not appropriate to do so, how can the problem be corrected?

Accepted Answer

A)  by converting to 1NF 
B)  by converting to 2NF 
C)  by converting to 3NF 
D)  by converting to 4NF

Question 9

What is a relationship that is necessary for identification?

Accepted Answer

A)  objectifying relationship 
B)  merging relationship 
C)  identifying relationship 
D)  referential relationship

Question 10

After the information-level design is completed, what is the next step?

Accepted Answer

A)  The physical-level design 
B)  The top-down design 
C)  The bottom-up design 
D)  The logical-level design

Question 11

Which of the following is used to improve performance in frequently used columns by maintaining a sort order but does not enforce constraints?

Accepted Answer

A)  surrogate key 
B)  unique index 
C)  artificial key 
D)  nonunique index

Question 12

Describe the different types of primary keys.

Accepted Answer

The answer of Describe the different types of primary keys....

Question 13

In a one-to-many relationship, the primary key of the "many" table becomes the foreign key of the "one" table.

Accepted Answer

A) True 
 B)False

Question 14

As soon as you have completed Steps 1 through 3 for a given user view, you can merge the results into the __________________ design.

Accepted Answer

The answer of As soon as you have completed Steps...

Question 15

If an entity represented in a supertype table is not represented in the subtype table, what is this called in IDEF1X terminology?

Accepted Answer

A)  foreign key 
B)  incomplete category 
C)  subtype anomaly 
D)  supertype discriminator

Exam 6: Database Design 2: Design Method

How can you attempt to avoid the problem of creating a table that is not in third normal form?