Problem
"Tosco" operates a chain of membership warehouses located in every major suburb across Perth such as Cannington and Joondalup. Each warehouse carries high quality food and household products at lower prices than are typically found at conventional supermarkets and convenience stores. The products available for sale include meat, diary, bakery, canned and packet food, beverages, alcohol, medicines, clothes, pet supplies and kitchenware. In order to be eligible to buy from any warehouses, customers must pay membership fee annually.
The corporation wants to setup an online e-commerce system for members to order products 24 hours a day, 7 days a week. The new e-commerce system will display details of products in which members can choose from. A member may order multiple products in one order and the system is required to record product quantity, order date and time, and payment method for each order.
The corporation also requires the system to store details about its members such as name, phone numbers and addresses. A valid email address must be provided by each member so that a receipt of the order and delivery status can be provided.
Based on the location the member lives in, the system will determine the closest warehouse for order delivery. The delivery will be done immediately by delivery staff using a motorbike provided by the corporation. Special instructions for the delivery staff are provided, especially if the delivery requires special direction or specific person to be contacted.
Task
a) Based on the entities and attributes identified above, develop an Entity Relationship Diagram (ERD), and a Relational Model that comply with Referential Integrity and being in Third Normal Form.
b) Your submitted ERD must use the notation i.e., a combination of Chen and Crow's foot notations.