100%(1)1 out of 1 people found this document helpful
This preview shows page 1 - 3 out of 5 pages.
You have been selected as the Database Designer to draft a model of an end to end application that a small auto parts store will use to manage: Inventory, Finance, Personnel, Services Performed. The current system uses a series of Microsoft Excel Workbooks, but it has been proven inefficient to accurately manage the business operations.Company Profile:EmployeesLaurel and Hardy’s Service Center employs the following staff and their titles:Stan Laurel - Owner Oliver Hardy – Co-Owner Moses Horwitz – Shop ForemanSamuel Horwitz – Parts ClerkLouis Feinberg - Parts ClerkJerome Horwitz – CashierJoe Besser – CashierJoseph Wardell – Human Resource SpecialistLou Costello – Loading Dock ClerkBudd Abbot – Sales ClerkJulius Marx – Service TechnicianLeonard Marx – Service TechnicianArthur Marx – Service TechnicianThey provide some the following products in their parts store:Inventory1
Wiper BladesBatteriesBrakes: Disk and DrumTires (Domestic and Foreign), Cars, Trucks Sedans, SUV’s, Motor CyclesOil: Synthetic and Non-SyntheticThey also provide the following service directly in their storeServiceBasic Oil ChangeTire RotationWiper Blade InstallationDetailingThe store must also accurately manage all their revenue streams and expensesFinancialsExpenses include:Inventory CostRent and Utility Cost