Database Table Design

question 53

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.

---

Definitions:

Toxic Chemical Problem

Issues arising from the harmful effects and environmental impact of toxic substances and chemicals.

Public Attention

The focus or concern of the general populace, often drawn to significant events, controversies, or societal issues.

Polychlorinated Biphenyls

Toxic chemical compounds that are environmentally persistent and have been used in various industrial applications.

Superfund Statute

Federal law aimed at cleaning up sites contaminated with hazardous substances and pollutants; formally known as the Comprehensive Environmental Response, Compensation, and Liability Act (CERCLA).