1 a) Design a database for a retail store that orders different products from various vendors (same product is not bought different vendors) and sells them to the customers.

The data requirements: maintain the customer information, product inventory, product vendors, orders placed with vendors and sales to the customers

Functional requirements: product inventory information, monthly sales, profits from sales

Present a conceptual database design using Entity-Relationship diagram (ERD). Determine the attributes of all the data sources from the functional requirements. Show all the entity types with possible primary keys and attributes identify the relationships with cardinality numbers and any attributes applicable to relationships.

Map the above E-R diagram to relational model and draw schema diagram, indicating the primary keys of each relation, foreign keys and showing the relationship between the tables. Create a new relation for m:n relationship with primary keys of the relations participating in the relationship as foreign keys and combination of the foreign keys as the primary key for the new relation and add attributes that new relation may have to save.