Seacrest Bedding Is Changing from a File-Oriented System to a Relational

question 86

Essay

Seacrest Bedding is changing from a file-oriented system to a relational database system.Identify and design at least three tables that would be needed to capture data for a sales transaction.Each table should include a primary key,three non-key attributes,and foreign keys as necessary.Make up data values for two records within each table.

---

Definitions:

Mental Health

A person's condition with regard to their psychological and emotional well-being.

Bipolar Disorder

A mental health condition marked by extreme mood swings, including emotional highs (mania or hypomania) and lows (depression).

Anxiety

A mental health disorder characterized by feelings of worry, anxiety, or fear strong enough to interfere with one's daily activities.

Affective Disorder

A category of psychiatric disorders characterized by mood disturbances, such as depression or bipolar disorder.