What are the steps to creating the first deliverable? Thanks! I know that another entity will be created to change the many to many relationship but confused on how the final model should look.

CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed OfTheSouth-X File Home Insert Draw Design Layout References Mailings Review View Help Tell me what you want to do Share omments CIS305 Project 1 Project Description The project is designing a complete database management system to address a practical database need and implementing a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization. The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of Pine Valley Furniture Company (PVF). PVF 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. PVF can actually fabricate some of the products they sell, in addition to purchasing them from the manufacturers The initial entities for your model are CUSTOMER, ORDER, and PRODUCT. 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. Youare 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 influences how your customers will think of you and how quickly thev will pav you. Your instructor (customer) will deduct points for incorrect formatting, as well as, inaccurate or incomplete work. Your grade represents your pay factor that CUSTOMER ( CustomerlD, CustomerName, CustomerAddress, CreditLimit) ORDER (OrderlD, CustomerID, CustomerPoNuber, OrderDate, DueDate, ShipDate) PRODUCT ProductID. ProductDescription, UnitPrice, StockQuentity) Page 1 of 4 1302 words CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed OfTheSouth-X File Home Insert Draw Design Layout References Mailings Review View Help Tell me what you want to do Share omments 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 tree entities (or the three converted relations) are not in 3rd 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 3rd 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 with (and thr relatioships) once you have achieved 3rd Normal Form Hint: You answer will be within the Word document you submit as your Project 1 Assignment response 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 fomatting and capitalization, as well as the appropriate relationships Deliverable 2 In Deliverable 2 you will start with a copy of your Deliverable 1, and build upon it by adding the necessary functionality to support the following business rules 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 isan 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 Res may have different commission rates All products are purchased from suppliers, and multiple suppliers can provide each product, 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, asthesekills are used to evaluate promotion eligibility In Deliverable 2, You will add the additional relations and relationships t the relational schema you created in Deliverable 1. You must maintain 3rd Normal Form in this enhanced model. Be sure to list your relations in alphabetical order, and be sure to include the relationships between the relations (al of these lines may look a little messy). Also, keep in mind that all of the relations must be shown flush left against the left margin of the page and in alphabetical order Be sure to use the correct capitalization formatting with RELATION names beiginglar and in Page 2 of 4 1302 words CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed OfTheSouth-X File Home Insert Draw Design Layout References Mailings Review View Help Tell me what you want to do Share omments CIS305 Project 1 Project Description The project is designing a complete database management system to address a practical database need and implementing a relational database based on that design. Your database system should be designed to perform general information management tasks such as systematic collection, update, and retrieval of information for a small organization. The objective of Project #1 is to develop a normalized relational data model describing the primary business processes of Pine Valley Furniture Company (PVF). PVF 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. PVF can actually fabricate some of the products they sell, in addition to purchasing them from the manufacturers The initial entities for your model are CUSTOMER, ORDER, and PRODUCT. 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. Youare 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 influences how your customers will think of you and how quickly thev will pav you. Your instructor (customer) will deduct points for incorrect formatting, as well as, inaccurate or incomplete work. Your grade represents your pay factor that CUSTOMER ( CustomerlD, CustomerName, CustomerAddress, CreditLimit) ORDER (OrderlD, CustomerID, CustomerPoNuber, OrderDate, DueDate, ShipDate) PRODUCT ProductID. ProductDescription, UnitPrice, StockQuentity) Page 1 of 4 1302 words CIS3050-03 Project 1 - Protected View- Saved to this PC ApacheWarloed OfTheSouth-X File Home Insert Draw Design Layout References Mailings Review View Help Tell me what you want to do Share omments 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 tree entities (or the three converted relations) are not in 3rd 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 3rd 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 with (and thr relatioships) once you have achieved 3rd Normal Form Hint: You answer will be within the Word document you submit as your Project 1 Assignment response 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 fomatting and capitalization, as well as the appropriate relationships Deliverable 2 In Deliverable 2 you will start with a copy of your Deliverable 1, and build upon it by adding the necessary functionality to support the following business rules 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 isan 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 Res may have different commission rates All products are purchased from suppliers, and multiple suppliers can provide each product, 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, asthesekills are used to evaluate promotion eligibility In Deliverable 2, You will add the additional relations and relationships t the relational schema you created in Deliverable 1. You must maintain 3rd Normal Form in this enhanced model. Be sure to list your relations in alphabetical order, and be sure to include the relationships between the relations (al of these lines may look a little messy). Also, keep in mind that all of the relations must be shown flush left against the left margin of the page and in alphabetical order Be sure to use the correct capitalization formatting with RELATION names beiginglar and in Page 2 of 4 1302 words