For the following question, prepare ER model and convert it to database designs (i.e., relational schemas). The ER model should have entities, attributes and relations and the database design should have primary and foreign keys. Comment on what normal form your database is in. If you make any assumptions, then write them below the models.

1. A company purchases products and sells them to its customers. Each time a sale occurs, an invoice is created listing the customer name, and a list of purchase product descriptions, the supplier name for the products, and the price of each product. The product number identifies each product and will appear again if another customer purchases the same product. Each supplier can supply many products which we can sell, but each product has only one supplier.