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 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
Step: 1
1 Entities customer product order supplier 2Relationship CustomerOrder Relationship Customer can mak...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started