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:

Emotion-Focused Coping

A stress management strategy that involves dealing with stress by managing one's emotional response to the stressor rather than addressing the stressor itself.

Type A Personality

A personality type characterized by competitiveness, high ambition, impatience, and a sense of urgency, often associated with a higher risk of heart disease.

Type B Personality

A personality characterized by a less competitive, more relaxed, and less stress-prone behavior pattern.

Social Support

The perception or reality of receiving support, encouragement, and assistance from friends, family, and others.