Question: 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

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 201-CIT111-Introduction to IS Week 10, Date: 31-10-2020 CUSTOMER Identify all attributes (Fields) Table: CUSTOMER Customer-Fi 

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. Identify Relationships Customer-Order Customer can make one or more (many) orders An order is made up by one customer Relationship Order-Product Relationship Supplier-Order Relationship 201-CIT111-Introduction to IS Week 10, Date: 31-10-2020 CUSTOMER Identify all attributes (Fields) Table: CUSTOMER Customer-First- Customer-First- Customer-email- Customer-Number Customer-Phone Name Name address Table: Table: 2

Step by Step Solution

3.49 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 Entities customer product order supplier 2Relationship CustomerOrder Relationship Customer can mak... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!