Posted: June 20th, 2020

build a database in bold, business and finance homework help

Question description

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.Table 1: KoKo’s Canine Pet Club Client DataCNoCLastNameCFirstNameCAddressCCityCStateCZipCPhoneCEmergencyPhone0001LeeSharry8385 North First StreetEdmondOK73003606-8975606-50390002StoneDavid1408 Peter Pan DriveYukonOK73069899-8182606-34020003YuWilliam7120 LakeridgeMidwest CityOK73099899-4979899-22220004MonacLevitica303 NorthridgeEdmondOK73099899-2395909-86790005RuazMonica1701 Memorial RoadOklahoma CityOK73001905-8440606-41020006BarkerGayle1983 Sliding GlassEdmondOK73034754-3666359-1588Table 2: Available WalkerWalkerNoWFirstNameWLastNameW001BobLegierW002KyleMorganW003BurlonJordanW004KellyLamontTable 3: Available Walk TimesTimeCodeWalkTimeDescription1Early Morning2Late Morning3Early Afternoon4Late Afternoon5Early EveningTable 4: Pet DataPetNoPetNameCNoWalkerNoQuotedPriceTimeCodeEnrollmentDateComments0001Mickey0001W001$7.0016/1/03Is a very friendly, well-behaved poodle0002Fiedo0001W001$10.0016/1/03Is a friendly miniature schnauzer. Keep on chain. He will run away, if he is off his chain0003Molly0005W002$10.0027/12/03Is a sensitive Pomeranian. Needs lots of attention0004Sir Lancelot0005W002$7.0027/12/03Is a playful German Shepard, but is hesitant around strangers0005Bruno0002W003$8.0038/15/03Is a well-behaved Chow Chow. The owner wants Bruno walked by himself and not with other pets0006Sally0003W003$8.0038/22/03Is a well-behaved mixed breed. She does frighten easily. Please keep her on a leash0007Peek-A-Poo0004W004$7.0038/22/03Is a mixed-breed. Very playful0008Bear0004W004$8.0038/22/03Is a Black Labrador0009Gretchen0004W004$8.0038/22/03Is a Black Labrador0010Prancy0006W004$8.5058/13/03Prancy can be aggressive towards other animals0011Lacy0006W004$8.5058/13/03Is very affectionate. Lacy will run, if she gets off of her leash0012Dazzle0006W004$10.0058/13/03Dazzle is afraid of strangersAfter reviewing these data, you notice that the Client table stores contact information for each client and that the client identification number serves as the primary key. The Walker table stores basic information about each walker and the Walk Times table stores a set of walk time codes. When a client registers a pet, a walk time code is assigned to each pet. This walk time code indicates the pet owner's preference for the time of day when the pet should be walked. The Pet table stores information about each pet, including the pet number, pet name, client identification number, walker identification number, quoted price, preferred walk time, enrollment date, and any relevant comments.After studying these data, you decide three relationships are necessary. First, a relationship between the Pet and Client tables is needed. Since each table contains a ClientNo field, you use the ClientNo field to create the relationship. Second, a relationship between the Walker and Pet tables is necessary. The Walker and Pet tables have a WalkerNo field, and you use this field to create a relationship between the Walker and Pet tables. Third, both the Walk and Pet tables have a WalkTimeCode field. You use the EalkTimeCode field to create the relationship between the Walk and Pet tables. You decide each relationship should enforce referential integrity.After creating data tables, you should create two forms: Client form and Pet form. When a new client enrolls his pet with the walking service, Caedee uses this form to input the contact information about the client. The form header includes the company name and the form's name. After a client registers, Caedee enrolls his pet using a Pet form. The Pet form captures basic information about the pet, such as the pet's name, walk time, and walker preference. You can use the Form Wizard to build initial Client form and Pet form. Once the forms are built, you can edit the forms in Design view.Caedee also requests Walker Schedule and Client List reports. The Walker Schedule report is generated on a weekly basis and tells Caedee when her walkers are scheduled to walk the pets. Since the Walker Schedule report uses data from four tables, you build a select query, and then base the report on the select query. The Walker Schedule report header contains the company name, a report title, and the current date. The information in the report body lists the walkers in ascending order based on the walker's last name. The Client List report provides a listing of the current clients. You may use the Report Wizard to speed initial report development, and then edit this report in Design view. The Client List report's header contains the company name, report name, and current data. While you are free to work with the design of the forms and reports, each form and report should have a consistent, professional appearance.Based on the above requirements, you build a database that contains four tables, two forms, and two reports.

Tags: Ace-myhomework Assignment, Affordable College Homework, APA Citation Assignment Help, Custom Essay Writing