Create an E-R diagram using the model used for a database, which supports the daily operation of
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 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.
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris