Question
You handle administrative support for CyberToy, a small chain that sells computer hardware and software and specializes in personal service. The company has 6 stores
You handle administrative support for CyberToy, a small chain that sells computer hardware and software and specializes in personal service. The company has 6 stores in the Wilkes-Barre and Scranton area and is planning more. Each store has a manager, two technicians and between one to four sales reps.
Bruce and Marcia Berns, the owners, want you to create a personnel records database and they asked you to design it based on what Marcia thinks should be included in the design. She
would like the following information in the design: store number, location, store telephone, manager name, manager home phone number and cell number, technician name, technician home phone number and cell number, sales rep name, sales rep home phone number and cell number. Use the normalization concepts in chapter 9 and draw the design. You can add more fields that you feel are necessary and relevant but keep the fields that are suggested by Joan.
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