Need help solving problem. i have the entity relationship diagram but i need help with creating the relational model.

Database Design for a retail store Database Design COSC 531 Assignment \#2 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 1. 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. 2. Map the above E-R diagram to telational 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