Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I only need help with Deliverable 2. Should be in 3rd normal form. I even uploaded my deliverable 1 right below. Thank You! so for

I only need help with Deliverable 2. Should be in 3rd normal form. I even uploaded my deliverable 1 right below. Thank You!

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribed

so for this project it requires 3 parts. i already did the 1st part but i need help on the 2nd part (Deliverable #2). the first picture is a screenshot of my 1st part of the project.
this is all of the instructions i had.
Customer Customerlo CustomerName CustomerAddress CustomerPhone Product ProductiD ProductDesc UnitPrice QuantityInStock Order Order D Order Date DueDate ShipDate CustomeriD (FK) Orderline OrderLineID Quantity OrderID (FK) ProductiD (FK) 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 PRODUCT CustomerID Customer Name Customer Address CreditLimit OrderID CustomerID CustomerPONumber Order Date DueDate ShipDate ProductID Product Description Unit Price StockQuantity 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 30 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 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 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 formatting and capitalization, as well as the appropriate relationships. Deliverable tips: Within a Word document, submit all three deliverables in the exact order specified. Deliverable 1 with consist of the logical schema showing the relations and relationships Deliverable 2 will be in the same format as Deliverable 1, but it will contain many more relations and relationships Deliverable 3 will contain the same information as Deliverable 2 but it will be in a different format. Deliverable 3 will be in the format of an ERD, and you will develop your ERD in ERwin. You must also attach a copy of your ERwin data file. Include a table of contents. . Follow the instructions provided within the course syllabus regarding submitting projects. The first two deliverables must show relations and relationships The third deliverable mush show entities and relationships Customer Customerlo CustomerName CustomerAddress CustomerPhone Product ProductiD ProductDesc UnitPrice QuantityInStock Order Order D Order Date DueDate ShipDate CustomeriD (FK) Orderline OrderLineID Quantity OrderID (FK) ProductiD (FK) 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 PRODUCT CustomerID Customer Name Customer Address CreditLimit OrderID CustomerID CustomerPONumber Order Date DueDate ShipDate ProductID Product Description Unit Price StockQuantity 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 30 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 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 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 formatting and capitalization, as well as the appropriate relationships. Deliverable tips: Within a Word document, submit all three deliverables in the exact order specified. Deliverable 1 with consist of the logical schema showing the relations and relationships Deliverable 2 will be in the same format as Deliverable 1, but it will contain many more relations and relationships Deliverable 3 will contain the same information as Deliverable 2 but it will be in a different format. Deliverable 3 will be in the format of an ERD, and you will develop your ERD in ERwin. You must also attach a copy of your ERwin data file. Include a table of contents. . Follow the instructions provided within the course syllabus regarding submitting projects. The first two deliverables must show relations and relationships The third deliverable mush show entities and relationships

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 23rd International Conference Dexa 2012 Vienna Austria September 2012 Proceedings Part 1 Lncs 7446

Authors: Stephen W. Liddle ,Klaus-Dieter Schewe ,A Min Tjoa ,Xiaofang Zhou

2012th Edition

3642325998, 978-3642325991

More Books

Students also viewed these Databases questions