Answer Happy

2. Consider the previous scenario. Suppose now that the companywants to also build relations that describe its inventory and salestransactions. For the inventory, the store keeps track of thefollowing: ◦ The product manufacturer name ◦ The product modelnumber ◦ The number in stock ◦ The wholesale price ◦ The retailprice A manufacturer has many products, each of which has a productnumber that is unique for that manufacturer. However, twomanufacturers could have the same product numbers for some of theirproducts. For the sales transactions, the company tracks thefollowing ◦ The customer id of the customer making the sale ◦ Thedate of the sale ◦ The product purchased model number ◦ The productpurchased manufacturer name ◦ The price paid including tax Assumethat a customer makes only one order on any given day. Develop theschemas for each of the above relations, including primary keys andforeign keys, using only attributes representing the informationdescribed above. Note that for the sales transaction relation, youmust develop foreign keys that refer to the customer