Question: Based Based on information about orders and sales. Give me example to make an access - Customers: Each customer has a unique customer ID, name,
Based
Based on information about orders and sales. Give me example to make an access
- Customers: Each customer has a unique customer ID, name, email address, and phone number. Customers can place multiple orders, but each order belongs to only one customer. - Orders: Each order has a unique order ID, a date and time, and a total price. An order can contain multiple items, but each item belongs to only one order. - Products: Each product has a unique product ID, a name, a description, a price, and a quantity in stock. Products can belong to multiple orders, and each order can contain multiple products. - Categories: Each category has a unique category ID and a name. Each product can belong to only one category. - Sales: Each sale has a unique sale ID, a date and time, and a total amount. A sale can contain multiple orders, but each order belongs to only one sale. - As with the example assignment, there may be additional joining entities that need to be included in the model: it is your responsibility to determine the needs of the data model and to design these tables, if needed. An Access database that includes tables for each model entity. The Orders and Sales tables should be built in Access and populated with data, including references to the imported Customers, Products, and Categories data tables
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
