Database Table Design

Essay

Database table design
Several independent statements regarding database table design appear below. Indicate the highest normal form that applies to each statement: (a) first normal form, (b) second normal form, (c) third normal form or (d) not in any normal form.
______ 1. A sales staff/automobile table connects two tables: one with data about automobiles, the
other with data about sales staff.
______ 2. All columns depend on the table's primary key.
______ 3. An "automobile" table contains the name of the sales staff member with the greatest
dollar sales for the month.
______ 4. An inventory table contains the following fields: item number, item description,
beginning inventory quantity, average cost of beginning inventory, beginning inventory
date.
______ 5. Customer table contains information about sales transactions.
______ 6. 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.
______ 7. Redundant data does not appear in the table.
______ 8. The sales table contains one field for accounts debited and credited.
______ 9. The table eliminates repeating groups.