Question
Case in Point 9.2 CyberToys You handle administrative support for CyberToys, a small chain that sells computer hardware and software and specializes in personal service.The
Case in Point 9.2 CyberToys
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started