Question 6

When working with an entity (table), we can create a(n) _____ to be that entity's primary key and also make it visible to the users so that they can identity each unique record.

Surrogate key

Artificial key

Synthetic key

Natural key

Question 7

Which of these is NOT one of the steps when building a User View?

Determining the indexes

Determining the secondary keys

Determining the primary key

Determining the relationships

Question 8

If col1 is the PK of Table1 and col5 is the PK of Table2, the following alternative table structures is an example of a _____ relationship.

Table1(col1, col2, col3) Table1(col1, col2, col3, col5)

Table2(col5, col6, col1) OR Table2(col5, col6)

There is no relationship

One to one

Many to many

One to many

Question 9

If a given table structure has too many null values, we can ____

This can't happen, as a relational database doesn't support null values

Split the table and create a subtype table

Remove the columns that contain most of the null values

Populate the null values with a dummy value

Question 10

In the Entity Relationship Model, an entity with a minimum cardinality of zero represents a ________

Weak Entity

Optional role

Mandatory role

Mandatory role