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
Step: 1
Get Instant Access to Expert-Tailored Solutions
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