Design a database diagram for a product orders database with four tables. Indicate the relationships between tables
Fantastic news! We've Found the answer you've been seeking!
Question:
Design a database diagram for a product orders database with four tables. Indicate the relationships between tables and identify the primary key and foreign key in each table. Explain your design decisions.
- Customers (CustomerID, CustomerName, CustomerAddress, CustomerEmail, CustomerPhone)
- Orders (OrderID, CustomerID, OrderDate, ShipDate, TotalPrice)
- OrderItem (OrderID, ProductID, Quantity, UnitPrice)
- Products (ProductID, ProductName, Price, InStock, OnOrder)
b) Add the three tables below into the design for part a, you can create additional tables and columns if necessary. Indicate the relationships between tables and identify the primary key and foreign key in each table. Explain your design decisions.
-
- Shipping (ShippingID, OrderID, ShipperName, ShipperPhone, Weight, ShippingDate, ShippingMedium, ShippingStatus)
- Employees (EmployeeID, SSN, FirstName, LastName, HireDate, Title, DepartmentID, HomeAddress, Phone, Email)
- Department (DepartmentID, DepartmentHead, DepartmentAddress)
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: