◦ The product manufacturer name ◦ The product model number ◦ The number in stock ◦ The wholesale price ◦ The retail pric

[answerhappygod]

◦ The product manufacturer name
◦ The product model number
◦ The number in stock
◦ The wholesale price
◦ The retail price
A manufacturer has many products, eachof which has a product number that is unique for that manufacturer.However, two manufacturers could have the same product numbers forsome of their products.
For the sales transactions, thecompany tracks the following
◦ The customer id of thecustomer making the sale
◦ The date of the sale
◦ The product purchased modelnumber
◦ The product purchased manufacturername
◦ The price paid includingtax
Assume that a customer makes only oneorder on any given day.
Develop the schemas for each of theabove relations, including primary keys and foreign keys, usingonly attributes representing the information described above. Notethat for the sales transaction relation, you must develop foreignkeys that refer to the customer table and the inventory table.