Question

1. A cosmetic product retailer needs to create a database to keep track of the information for its business operations. The company has a web site that posts all its products. The product information includes product ID, product name, description, and unit price. The company also needs to keep track of customers’ information, including customer names, their shipping addresses, and the email address. The company creates an account for each customer for identification and tracking purpose. A customer can purchase multiple products with different quantities in one order. The company’s products have many prospective customers. The company needs to keep track of information for all orders it received, including the order date, invoice number, and information about products purchased in an order such as IDs of products, and quantities, etc. Company’s products are stocked in several warehouses. So company also needs to keep track of the information about each warehouse such as its name, address, manager, telephone, etc. a. Create an E/R model for this scenario. In your E/R model you need to show the names of entities, names of attributes, keys and the name(s) of relationship(s). Also indicate maximum and minimum cardinalities You may hand-draw the ER model and insert its image here.

Answer 1

ER Diagram of above Description:

here, PK indicates for Primary Keys and FK indicates for Foreign Keys.

Description of ERD:

1. Each Entity contains Primary Key as a Unique Key.

2.All the entities are have relationships with other with their foreign keys.

3.Minimum ans Maximum Cardinality are represented by 1 or N to every relationships.

4.Relationships:

Customer to Products  (one to many)

Customer to Account (one to many)

Customer to order (one to many)

Account yo order (one to many)

Order to Products (one to many)

WareHouse to Products (one to many)

Manager to Warehouse (one to many)

5. Entities and their Attributes are shown in above Diagram.

If you have any doubt regarding this question please ask mein comments

//THANK YOU:-)