Use MS Access to

1. Create 4 database tables, as described below.

-Customer table stores customer records. A customer may place many orders.

-Orders table stores orders placed by customers.

-OrderItem table stores items belonging to orders. An order may contain many items. Each item represents the quantity of a product ordered.

-Product table stores the details about a product.

2. Create the necessary relationships between these tables to enforce the following business policies:

-An order must be placed by a valid customer.

-An order contains many items.

-Every item of an order must be a valid product.