Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have just started a dog business. You want to create a to keep of your customers and their dogs. Use the concepts and techniques

image text in transcribed

You have just started a dog business. You want to create a to keep of your customers and their dogs. Use the concepts and techniques presented in this chapter to design a database to meet the following requirements. 1. The Dog walkers database must support the following requirements: a. For each d list the dog ID, dog name, breed name - for example, Dalmatian, mixed, collie and so on - size (large, medium, small) gender, number of times walked per day, and owner first name and last name as well as cell telephone number. b. For each customer, list the customer ID. the customers first name, last name, address (street city, postal code), home telephone number, cell telephone number, current amount due, and amount paid. c. The database also must store the cost per walk. The cost to walk each dog depends on both the dog and the customer. A dog belongs to only one breed, but a breed can have many dogs. An owner also can have many dog. Based on these requirements: a. Identify and list the entities and the attributes of those entities. b. Identify and list the functional dependencies. c. Create a set of 3NF relations using the shorthand notation given in the chapter. Be sure to identify all primary keys and foreign keys appropriately. Submit your database design in the format specified by your instructor

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual Basic.NET

Authors: Ying Bai

1st Edition

0521712351, 978-0521712354

More Books

Students also viewed these Databases questions