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:

Smelted

The process of extracting a metal from its ore by heating and melting.

Carload

A shipping term denoting the minimum quantity of cargo required for a shipper to qualify for a reduced rate.

Hormone-Free

Refers to animals raised without the use of growth hormones, often used in reference to meat or dairy products.

Stress-Free

A state or condition where an individual experiences no or minimal stress, leading to a sense of calm and tranquility.