Can someone help me with thge last two deliverables? I'm on a time crunch and could use the help.
Overview: The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of Polytechnic Supply Corporation (PSC). PSC is in the business of wholesale distribution, whereby they purchase most of their products directly from various manufacturers, and then they sell these products to their customers. PSC can actually fabricate some of the products they sell, in addition to purchasing them from the manufacturers The initial entities for your model are presented below. In addition to these initial entities, you are provided with several business rules You should treat this project as a business assignment in which your instructor is your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as, inaccurate or incomplete work. Your grade represents your pay Initial Entities CUSTOMER ORDER OrderID Customerld CustomerPONumber OrderDate DueDate ProductID ProductDescription UnitPrice StockQuantity CustomerID ustomerName CustomerAddress CreditLimit Deliverable 1 Begin with the initial entities for CUSTOMER, ORDER, and PRODUCT provided above, transform them into relations, and normalize your model to 3rd Normal Form. This is your deliverable #1. Realize that the three entities (or the three converted relations) are not in 3"d Normal Form. This is obvious by the many- to-many relationship that would need to exist between ORDER and PRODUCT. You are to do the steps necessary to obtain 3 Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come up with (and their relationships) once you have achieved 3rd Normal Form. Hint: The solution has more than three relations. Your answer will be within the Word document you submit along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships).This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships rd Page 1 of3 Overview: The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of Polytechnic Supply Corporation (PSC). PSC is in the business of wholesale distribution, whereby they purchase most of their products directly from various manufacturers, and then they sell these products to their customers. PSC can actually fabricate some of the products they sell, in addition to purchasing them from the manufacturers The initial entities for your model are presented below. In addition to these initial entities, you are provided with several business rules You should treat this project as a business assignment in which your instructor is your customer. You are to deliver the results of this project in a very professional and accurate format. The quality of your project submission is a reflection of your attention to detail, and it is an important factor that influences how your customers will think of you and how quickly they will pay you. Your instructor (customer) will deduct points for incorrect formatting, as well as, inaccurate or incomplete work. Your grade represents your pay Initial Entities CUSTOMER ORDER OrderID Customerld CustomerPONumber OrderDate DueDate ProductID ProductDescription UnitPrice StockQuantity CustomerID ustomerName CustomerAddress CreditLimit Deliverable 1 Begin with the initial entities for CUSTOMER, ORDER, and PRODUCT provided above, transform them into relations, and normalize your model to 3rd Normal Form. This is your deliverable #1. Realize that the three entities (or the three converted relations) are not in 3"d Normal Form. This is obvious by the many- to-many relationship that would need to exist between ORDER and PRODUCT. You are to do the steps necessary to obtain 3 Normal Form. You do not have to show how you got there, but you are to provide a document that shows the final relations you come up with (and their relationships) once you have achieved 3rd Normal Form. Hint: The solution has more than three relations. Your answer will be within the Word document you submit along with the other deliverables for this assignment. Be sure to format this showing the logical schema (Rectangle boxes for relations in alphabetical order and lines between the relations to indicate the relationships).This format is NOT an ERD. Make sure it includes proper formatting and capitalization, as well as the appropriate relationships rd Page 1 of3
