This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Spring '10