vice. The company has four stores located at malls and is planning on expanding to other locations. Each store has a manager, a technician, and between one and four sales reps.
The owners want to create a personnel records database, and they asked you to review a table that they had designed. They suggested fields for Store Number, location, store telephone, manager name, and manager home telephone. They also want fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones.
Draw an Entity Relationship Diagram modeling their suggested design.
Analyze their original design using the normalization concepts you learned in Module 9. For this part of the question, make sure you begin with the original table in an unnormalized form as requested by the company. Work your way through 1st, 2nd, and 3rd normal forms. At each point, be sure you use the standard notation format to show the changes in the structure of your table(s) (Module 9; 9.6.1). During your analysis, be sure to explicitly illustrate/write about the reason behind the design decisions you make. Additionally, each normal form should have it's own section/heading.
Draw a final ERD showing your final analysis showing the relationship among the entities you identified during normalization
rvice. The company has four stores located at malls and is planning on expanding to other locations. Each store has a manager, a technician, and between one and four sales reps.
The owners want to create a personnel records database, and they asked you to review a table that they had designed. They suggested fields for Store Number, location, store telephone, manager name, and manager home telephone. They also want fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones.
a. Draw an Entity Relationship Diagram modeling their suggested design.
b. Analyze their original design using the normalization concepts you learned in Module 9. For this part of the question, make sure you begin with the original table in an unnormalized form as requested by the company. Work your way through 1st, 2nd, and 3rd normal forms. At each point, be sure you use the standard notation format to show the changes in the structure of your table(s) (Module 9; 9.6.1). During your analysis, be sure to explicitly illustrate/write about the reason behind the design decisions you make. Additionally, each normal form should have it's own section/heading.
c. Draw a final ERD showing your final analysis showing the relationship among the entities you identified during normalization