TABLES: Playtime with
Telly
Cat Toys
|
ID(Pk) |
Color |
Rating |
Lendable |
Description |
GiverID(Fk) |
BorrowedID |
|
001 |
yellow |
3 |
no |
small mouse |
003 |
|
|
002 |
magenta |
2 |
yes |
bell ball |
004 |
001 |
|
003 |
orange |
7 |
no |
feather post |
001 |
|
|
004 |
multi |
10 |
no |
bookmark |
006 |
|
|
005 |
blue |
10 |
yes |
milk ring |
006 |
|
|
006 |
green |
5 |
yes |
feather ball |
005 |
004 |
Type
|
ID(Pk) |
Type |
Description |
|
001 |
mouse |
small furry creature |
|
002 |
ball |
round, rolls |
|
003 |
feather |
feathers |
|
004 |
yarn |
wound ball |
|
005 |
Household |
Things around the house Telly has adopted. |
Use
|
ID(Pk) |
Start Time |
End Time |
Accidental Use |
CatToyID(Fk) |
|
001 |
10/07/2005 1:20 |
10/07/2005 1:23 |
no |
001 |
|
002 |
10/08/2005 12:51 |
10/08/2005 12:52 |
no |
002 |
|
003 |
10/08/2005 23:24 |
10/08/2005 23:28 |
no |
005 |
|
004 |
10/09/2005 9:27 |
10/09/2005 9:35 |
yes |
001 |
|
005 |
10/09/2005 4:46 |
10/09/2005 4:48 |
no |
004 |
Locations
|
ID(Pk) |
Hidden |
Room |
GPS Coordinates |
CatToyID(Fk) |
|
001 |
yes |
living |
23.5, 23.7 |
001 |
|
002 |
no |
kitchen |
24.6, 24.8 |
004 |
|
003 |
no |
borrowed |
55.2,55.3 |
002 |
|
004 |
yes |
bedroom |
22.8, 22.8 |
003 |
|
005 |
yes |
bedroom |
22.7,22.4 |
005 |
Givers
|
ID(Pk) |
First Name |
Last Name |
Rating |
Relationship |
|
001 |
Susan |
Freed |
8 |
Grandma |
|
002 |
Jeanette |
Anderson |
5 |
Great-grandma |
|
003 |
Alexis |
Smith |
10 |
Aunt |
|
004 |
Sarah |
Burks |
6 |
Aunt |
|
005 |
April |
Bauchmoyer |
3 |
Aunt |
|
006 |
Jenny |
Freed |
10 |
Mummy |
Borrower
|
ID(Pk) |
Name |
Friend |
Relationship |
|
001 |
Thisbe |
no |
Sister |
|
002 |
Isis |
no |
Sister |
|
003 |
Moulder |
no |
Cousin |
|
004 |
Jupiter |
no |
Neighbor |
|
005 |
Bubba |
no |
Cousin |
Address
|
ID(Pk) |
Street |
City |
State |
Zip |
|
001 |
Woodfield |
Bloomington |
Il |
61704 |
|
002 |
86th |
Bloomington |
MN |
55425 |
|
003 |
R.R. 3 |
Bloomington |
IN |
47459 |
|
004 |
Forest Glen |
Green Bay |
WI |
54304 |
|
005 |
10 PR |
Oxford |
MS |
38655 |
|
006 |
Country Fair, Apt. 47 |
Champaign |
IL |
61821 |
|
007 |
Country Fair, Apt. 48 |
Champaign |
IL |
61821 |
Type-Cat Toys(Primary Key:
CatToyID + TypeId)
|
CatToyId (FK) |
TypeId(FK) |
|
001 |
001 |
|
002 |
002 |
|
003 |
003 |
|
004 |
005 |
|
005 |
005 |
|
006 |
003 |
Borrower-Address (Primary
Key: BorrowerID + AddressId)
|
BorrowerId(FK) |
AddressId(Fk) |
|
001 |
001 |
|
002 |
001 |
|
003 |
002 |
|
004 |
007 |
|
005 |
003 |
Givers-Address (Primary
Key: GiverID + AddressId)
|
GiverID(Fk) |
AddressId(Fk) |
|
001 |
001 |
|
002 |
004 |
|
003 |
002 |
|
004 |
003 |
|
005 |
005 |
|
006 |
006 |