Each customer may place multiple orders, and each order may consist of multiple products each customer is serviced by a sales representative that is an employee of psc employees that are sales reps are paid commission on their sales based on a commission rate for the sales rep. different sales reps may have different commission rates all products are purchased from suppliers, and multiple suppliers can provide products; however, some products can also be fabricated by psc. different suppliers charge different amounts for the products. fabricated products consist of a bill of materials that describes the components (parts) of each product. component parts are products too each employee is required to complete a series of psc courses. it is essential to document the courses employees complete, as these skills are used to evaluate promotion eligibility complete the following tasks: begin with the initial entities for customer, order, and product provided above, transform them o relations, and normalize your model to 3rd normal form. this is your deliverable #1. a handwritten schema is acceptable, but make sure it includes proper formatting and capitalization, as well as the appropriate relationships. combine the relations from deliverable #1 with the business rules and decompose the report o a relational schema and show referential egrity constra s. be sure to maintain 3rd normal form. this is your deliverable #2. a handwritten schema is acceptable, but make sure it includes proper formatting, capitalization, and relationships.