Week4.Kennel.Exercise.Solution

Week4.Kennel.Exercise.Solution - PEN is a parent to DOG....

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Kennel Project Solution Create a database that keeps track of information to run a dog kennel.  This database must contain information about the owners of the dogs such as name,  address, phone number. It must also contain information about the dogs such as name, gender,  breed, age, and weight. Also the kennel must keep track of information about each individual  pen such as pen id, pen size, whether it is occupied, and whether it is clean.  An owner can have more than one dog. A pen can have more than one dog in it.  Data Modeling Structure DOGOWNER is a parent to DOG. ONE dog owner can have zero or more dogs and ONE dog can only have one owner. This relationship is a one-to-many relationship.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: PEN is a parent to DOG. ONE pen can have zero or many dogs in it and ONE dog can only belong to one pen. This relationship is a one-to-many relationship. DOGOWNER OWNERID (Primary Key)= dog owner ID# OWNERNAME = dog owner name OWNERADDRESS = dog owner address OWNERPHONE = dog owner phone number DOG DOGID (Primary Key) = dog leash ID# DOGNAME = dog name DOGGENDER = dog gender DOGBREED = dog breed DOGAGE = dog age DOGWEIGHT = dog weight DOGOWNERID (Foreign Key to P_DOGWNER) DOGPENID (Foreign Key to P_PEN) PEN PENID (Primary Key) = pen ID# PENSIZE = pen size PENOCCUPIED = pen is full (occupied) PENCLEAN = pen is empty (clean)...
View Full Document

Page1 / 3

Week4.Kennel.Exercise.Solution - PEN is a parent to DOG....

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online