#3

Ouestion 1

The object of first normal form in the normalization process is to:

Question 2

If a table has a single column primary key and its already in first normal form, what can we say about that table?

Question 3

1 out of 1 points

When defining functional dependence from column A to column B, so that A ? B, this means that

Question 4

For a table to be in third normal form (3NG) it must be in second normal form and _____.

Question 5

When starting the information level design for a database, we must represent each ____ as a collection of tables.

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.

Question 7

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

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)

Question 9

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

Question 10

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