Question
The Repair Clinic is run by Mr. Steve Johnson. He has two employees in the shop and has asked you to develop a database to
The Repair Clinic is run by Mr. Steve Johnson. He has two employees in the shop and has asked you to develop a database to help better track his data. He wants to keep data about customers, customer power equipment, repairs, employees, services offered, parts in inventory, appointment calls, and cash receipts. Customers call to make service appointments to bring their power equipment to the shop for a diagnosis visit. When customers call, one of the shop clerks records which equipment will be brought in and what kinds of services the equipment possibly requires (i.e.,oil change, blade sharpening. Carburetor tune up, etc.). Every appointment for a repair must involve at least one service and may involve many. If a customer has more than one piece of equipment (e.g., lawn mower and leaf blower) that needs a repair, they make back-to-back appointments for diagnosis on the same day.
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