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

1 Expert Approved Answer
Step: 1 Unlock 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!