Solved

Several Independent Statements Regarding Database Table Design Appear Below

Question 45

Matching

Several independent statements regarding database table design appear below. Indicate the highest normal form that applies to each statement:

Premises:

Responses:

A sales staff/automobile table connects two tables: one with data about automobiles, the other with data about sales staff.

first normal form

All columns depend on the table's primary key.

second normal form

An "automobile" table contains the name of the sales staff member with the greatest dollar sales for the month.

third normal form

An inventory table contains the following fields: item number, item description, beginning inventory quantity, average cost of beginning inventory, beginning inventory date.

not in any normal form.

Customer table contains information about sales transactions.

Each record in a sales table contains four fields: transaction number, transaction date, customer name and sales staff name. Each student is paired with a single advisor; an advisor's name appears more than once in a table.

Redundant data does not appear in the table.

The sales table contains one field for accounts debited and credited.

The table eliminates repeating groups.

Premises:

A sales staff/automobile table connects two tables: one with data about automobiles, the other with data about sales staff.

All columns depend on the table's primary key.

An "automobile" table contains the name of the sales staff member with the greatest dollar sales for the month.

An inventory table contains the following fields: item number, item description, beginning inventory quantity, average cost of beginning inventory, beginning inventory date.

Customer table contains information about sales transactions.

Redundant data does not appear in the table.

The sales table contains one field for accounts debited and credited.

The table eliminates repeating groups.

Responses:

first normal form

second normal form

third normal form

not in any normal form.

Correct Answer:

Premises:

Responses:

A sales staff/automobile table connects two tables: one with data about automobiles, the other with data about sales staff.

All columns depend on the table's primary key.

An "automobile" table contains the name of the sales staff member with the greatest dollar sales for the month.

An inventory table contains the following fields: item number, item description, beginning inventory quantity, average cost of beginning inventory, beginning inventory date.

Customer table contains information about sales transactions.

Redundant data does not appear in the table.

The sales table contains one field for accounts debited and credited.

The table eliminates repeating groups.