Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create an E-R diagram using the model used for a database, which supports the daily operation of Best Furniture, a retail company selling office and

Create an E-R diagram using the model used for a database, which supports the daily operation of “Best Furniture”, a retail company selling office and home furniture and decoration items. It has a chain of several stores.

Customers need to register with the company at any store and after that they can place their orders at any “Best Furniture” store. All customers are classified into companies and individuals. Customers are assigned customer ID, address and contact phone number. A company is described by the company name and name of a contact person. For an individual customer, the customer’s name and credit card number are recorded. 

Each store has a unique number, and is described by its address and area in square feet. 

The furniture company offers a number of items. An item description includes item ID, name and regular price. An item can be a product, for example a table. Each order placed by a customer is described by unique order number, date and form of payment. Each order may include more than one item in different quantities.

Step by Step Solution

3.32 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

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

Database Systems Design Implementation and Management

Authors: Carlos Coronel, Steven Morris

13th edition

1337627909, 978-1337627900

More Books

Students also viewed these Databases questions

Question

What is the difference between a name node and a data node in HDFS?

Answered: 1 week ago

Question

Explain the differences between data, information, and a database.

Answered: 1 week ago