CyberToys is a small chain that sells computer hardware and software and specializes in personal service. 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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

CyberToys is a small chain that sells computer hardware and software and specializes in personal service. 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 1^st, 2^nd, and 3^rd 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

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions