Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

1 Entities customer product order supplier 2Relationship CustomerOrder Relationship Customer can mak... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus

Authors: Dale Varberg, Edwin J. Purcell, Steven E. Rigdon

9th edition

131429248, 978-0131429246

More Books

Students also viewed these Databases questions

Question

Identify and explain four advantages of group counseling.

Answered: 1 week ago

Question

What are the primary reasons for holding inventory?

Answered: 1 week ago