Question
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
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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started