201-CIT111- Introduction to IS Week 10, Date: 31-10-2020 Name ID: Homework Assignment - Chapter 05 - Organizing and Storing Data Relational Database Design Exercise: Sales Information System Application A furniture sales company wishes to develop a database for the web-based sales database application. With the use of this application, a customer can make one or more orders for purchasing furniture products. A product can be included in many different orders. Each furniture product is supplied from one supplier, but a supplier can supply one or more products. Task: follow the four stages approach described in Chapter 5, for designing relational databases to support the sales application. Submit through the Black Board. Deadline: 11 November 2020. Bonus Grade 5%. 1. Identify Entities 2. Identify Relationships 3. Identify all attributes 4. Resolve relationships Identify Entities 1. CUSTOMER 2. 3. 4. Identify Relationships Customer-Order Relationship Customer can make one or more (many) orders An order is made up by one customer . Order-Product Relationship Supplier-Order Relationship 1 201-CIT111-Introduction to IS Week 10, Date: 31-10-2020 CUSTOMER Identify all attributes (Fields) Table: CUSTOMER Customer-First Customer-First- Namc Namo Customcr-Phonc Customer-Number Customer-email- address Table: Table: 2 201-CIT111- Introduction to IS Week 10, Date: 31-10-2020 Table: Table: 3