Chagall Curtain Company Is Changing from a File-Oriented System to a Relational

question 12

Essay

Chagall Curtain Company is changing from a file-oriented system to a relational database system.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:

Index

An index is a system or an arrangement that allows for fast retrieval of data or information, commonly used in databases and books.

Device Manager

A Windows tool that displays and controls the hardware attached to the computer, allowing for troubleshooting and driver management.

Device

Any piece of hardware that can execute commands, process information, or perform specific functions independent or as part of a larger system.

Category View

An organizational method that groups similar items or files together, making them easier to find and manage.