You handle administrative support for CyberToys, 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 more. Each store has a manager, a technician, and between one and four sales reps. Bruce and Marcia Berns, the owners, want to create a personnel records database, and they asked you to review a table that Marcia designed. She suggested fields for store number, location, store telephone, manager name, and manager home telephone. She also wants fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones. Draw Marcia’s suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of Marcia’s design and why? What would you propose?
You handle administrative support for CyberToys, 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 more. Each store has a manager, a technician, and
between one and four sales reps.
Bruce and Marcia Berns, the owners, want to create a personnel records
and they asked you to review a table that Marcia designed. She suggested fields for store
number, location, store telephone, manager name, and manager home telephone. She
also wants fields for technician name and technician home telephone and fields for up to
four sales rep names and sales rep home telephones.
Draw Marcia’s suggested design and analyze it using the normalization concepts you
learned in the chapter. What do you think of Marcia’s design and why? What would you
propose?
Trending now
This is a popular solution!
Step by step
Solved in 7 steps with 4 images
