This project consists of three parts. In Part $1,$ you are to create an Entity Relationship Diagram $($ERD$).$ In Part $2,$ you are to create a Relational Data Model $($Logical Schema$),$ and in Part $3,$ you are to create an ERD that diagrams more features. You will create a Microsoft Word document consisting of three pages with one part on each page. Page $1$ will show the ERD for part $1,$ page $2$ will show the Logical Data Model for part $2,$ and page $3$ will show the ERD for part $3.$ Project Submission Requirements: You must name your Word document using the syntax of LastName$-$FirstInitial$-$P$1.$docx, where LastName is your last name and FirstInitial is the initial representing your first name. Submit your Word document to the Project $1$ Assignment on the Canvas website before the end of the day of the due date. Overview: The objective of Project #$1$ is to develop a normalized relational data model describing the business processes of Polytechnic Supply Corporation $($PSC$).$ PSC is a wholesale distributor, The company purchases their products from various manufacturers, and they sell these products to their customers. The initial entities for your model are presented below: Initial Entities: CUSTOMER ORDER PRODUCT CustomerID OrderID ProductID CustomerName CustomerID ProductDescription CustomerAddress CustomerPONumber UnitPrice CreditLimit OrderDate StockQuantity DueDate ShipDate Part $1$ You are to create an Entity Relationship Diagram $($ERD$).$ Begin with the initial entities for CUSTOMER, ORDER, and PRODUCT provided above, and normalize your model to $3$rd Normal Form. Realize that the three entities shown above are not in $3$rd Normal Form. This is obvious because of the many$-$to$-$many relationship that would need to exist between ORDER and PRODUCT. You are to do the steps necessary to obtain $3$rd Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final design once you have achieved $3$rd Normal Form. Hint: The solution has more than three relations. Your answer will be within the Word document you submit as your Project $1$ Assignment response along with the other deliverables for this assignment. Part $2$ You will convert the ERD you created in Part $1$ into the format of a Relational Data Model. Hint: Instead of showing the entities and relationships in the ERD format, your Relational Data Model will show Relations and Relationships. Part $3$ Now add features to the ERD you created in Part $1$ to model these business rule: Business Rules: $$ 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$.$ A Sales Rep may service multiple customers. $$ Employees that are Sales Reps are paid commission on their sales based on a commission rate for the Sales Representative. Different Sales Reps may have different commission rates. $$ All products are purchased from suppliers, and multiple suppliers can provide each product. Create a new ERD beginning with the information contained in Part $1$ and add entities, attributes and relationships to model the business rules. You must maintain $3$rd Normal Form in this enhanced model.