Question: Mark Twain is a dog trainer. He would like you to design a database that would keep track of her customers and appointments. O He

Mark Twain is a dog trainer. He would like you to

Mark Twain is a dog trainer. He would like you to design a database that would keep track of her customers and appointments. O He needs to know the contact information for each customer (name, phone, and address), as well as key facts about each dog, including name, gender, breed, age, weight, vet's name, whether the dog has been neutered, and optional comments such as "will bite or likes bacon better than cheese. H A customer may have more than one dog, of course. + o Usually, owners schedule appointments for Mark to come their homes or meet at a dog park for training. However, sometimes a customer makes an appointment for another customer's dog (for example, if they are friends with each other). So, in addition to the dog and owner information, Mark needs to record the customer who booked the appointment. o The appointments and fees are $35 for 1 hour, and $50 for one hour. Thus, each entry in the schedule should show the length of the session, where it is located, the date, the starting time, and whether it is kept or cancelled. After each appt, Mark would like to be able to make a few notes about the session

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!