I’m working on a Business exercise and need support.
Can you believe this is only 1 of my questions? smh This professor is ridiculous...
12 points) Achieving Operational Excellence: Building a Relational Database for Operation.
This exercise requires that you know how to develop a database using Microsoft Access, and know how to create forms, queries and reports.
KoKo's Canine Per Club is a dog-walking service, catering to caring, yet busy, pet owners. The service proves very popular with pet lovers who recognize the value of providing their pets with daily exercise. Although the service was only started six months ago, it currently provides pet walking services for 50 pets and is registering, on average, 5 pets per week. Paperwork is increasing, and Caedee Hannah, the owner, needs a better record keeping system.
During a meeting with Ms. Hannah, she explains to you that a new client must register with the service. During the registration process, the new client provides basic information about his pet(s), chooses a preferred walk time for his pet(s) and specifies a walker preference. During this time, a dog-walking fee is determined and recorded on the pet registration form. The dog-walking fee varies by pet and is based on the pet's size, temperament, and the number of pets the owner has. The pet owner can request that his pet be walked in the early morning, late morning, early afternoon, late afternoon, or early evening hours. Available walk times are currently kept on a clipboard by the phone. However, Caedee wants the available walk times, as well as walker, client, and pet information, kept in the database that you are building.
Caedee's record keeping needs are simple. She requires a database that tracks her clients, their pets, available walk times, and the pet walkers. Caedee gives you a partially completed data (see the following tables) and requests that you build and populate Client, Pet, Walker, and WalkTime tables in a database, create several relationships, design Client and Pet forms, design Walker Schedule and Client List report.