CASE 1: 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 in malls and is planning more. 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 names and technician home telephones and fields for up to four sales rep names and sales rep home telephones.
TASK:
Draw their suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of their design and why? What would you propose?
Note: For this assignment, you must draw the design suggested and also your proposed design.
Sample Solution
Section I: INTRODUCTION TO THE STUDY Introduction The country is encountering a basic deficiency of medical care suppliers, a lack that is supposed to increment in the following five years, similarly as the biggest populace in our country’s set of experiences arrives at the age when expanded clinical consideration is vital (Pike, 2002). Staffing of emergency clinics, facilities, and nursing homes is more basic than any time in recent memory as the huge quantities of ‘gen X-ers’ start to understand the requirement for more continuous clinical mediation and long haul care. Interest in turning into a medical caretaker has disappeared lately, likely because of the historical backdrop of the extraordinary and requesting instructive cycle, low compensation, firm and extended periods of time, and fast ‘wear out’ of those rehearsing in the calling (Wharrad, 2003). A complex oversaw care climate in this country is restricting the dollars accessible to be spent on nursing care. Numerous wellbeing callings, particularly>
GET ANSWER
Section I: INTRODUCTION TO THE STUDY Introduction The country is encountering a basic deficiency of medical care suppliers, a lack that is supposed to increment in the following five years, similarly as the biggest populace in our country’s set of experiences arrives at the age when expanded clinical consideration is vital (Pike, 2002). Staffing of emergency clinics, facilities, and nursing homes is more basic than any time in recent memory as the huge quantities of ‘gen X-ers’ start to understand the requirement for more continuous clinical mediation and long haul care. Interest in turning into a medical caretaker has disappeared lately, likely because of the historical backdrop of the extraordinary and requesting instructive cycle, low compensation, firm and extended periods of time, and fast ‘wear out’ of those rehearsing in the calling (Wharrad, 2003). A complex oversaw care climate in this country is restricting the dollars accessible to be spent on nursing care. Numerous wellbeing callings, particularly>
