Given the following tables: Customer Table [assume email is unique for each customer] CustomerID, Name, Age, Gender,
Question:
Given the following tables:
Customer Table [assume email is unique for each customer]
CustomerID, Name, Age, Gender, Email
Order Table
OrderID, CustomerID, OrderDate, OrderTotal, OrderPayment
OrderItems Table [each row describes an item in an order. Note that there may be several items in a single order] OrderID, ItemID, ItemQuantity, ItemUnitPrice
1). (20 points) For each table, list the following keys: super key, candidate key, primary key, secondary key, foreign key
2). (20 points) List relationships between Customer and Order, Order and OrderItems, and explain why. You can use 1:1, 1:M and M:N to describe their relationship and also mention if they are mandatory or optional. Note: you do not need to draw the diagram
3). (20 points) Assume we have another table - Item with attributes (ItemID, ItemName, CostPrice, SalePrice, AmountInStock), complete DB logical design by using ERD with Crow's foot notations. Note: you can use draw.io to draw ERD, or draw it by hand and upload images. In this assignment, you can ignore normalizations since we did not learn it. Just draw ERD for logical DB design, with PK/FK identified.
Systems analysis and design in a changing world
ISBN: 978-1423902287
5th edition
Authors: John W. Satzinger, Robert B. Jackson, Stephen D. Burd