paper.docx - You have been selected as the Database...

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: Employees Laurel and Hardy’s Service Center employs the following staff and their titles: Stan Laurel - Owner Oliver Hardy – Co-Owner Moses Horwitz – Shop Foreman Samuel Horwitz – Parts Clerk Louis Feinberg - Parts Clerk Jerome Horwitz – Cashier Joe Besser – Cashier Joseph Wardell – Human Resource Specialist Lou Costello – Loading Dock Clerk Budd Abbot – Sales Clerk Julius Marx – Service Technician Leonard Marx – Service Technician Arthur Marx – Service Technician They provide some the following products in their parts store: Inventory 1
Wiper Blades Batteries Brakes: Disk and Drum Tires (Domestic and Foreign), Cars, Trucks Sedans, SUV’s, Motor Cycles Oil: Synthetic and Non-Synthetic They also provide the following service directly in their store Service Basic Oil Change Tire Rotation Wiper Blade Installation Detailing The store must also accurately manage all their revenue streams and expenses Financials Expenses include: Inventory Cost Rent and Utility Cost

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture