RelationalDBDesign RelationalDBDesign 


Petstore Database  

PRODUCT_OBJ_TABLE

PRODUCT_OBJ_TABLE
PRODUCT_ID PRODUCT_NAME PACKAGE_ID CURRENT_INVENTORY_COUNT STORE_COST SALE_PRICE LAST_UPDATE_DATE UPDATED_BY_USER PET_FLAG ITEM_DESCRIPTION ITEM_CATEGORY
2Box Turtle  55.9815.5  JANETYLand turtle with large, square back.OTHER
3Fish Tank  1118.7524.9511-JUN-99MARKNTen gallon tank with gravel, filter, and light.FISH
4Dog Food21503.455.1510-MAY-99JANETN   
5Rabbit  102.53.9921-SEP-99JANETY  OTHER
6 Cat 20 8 25 45 15-SEP-99 MARK Y   CAT
7Cat Food20334.226.501-JUL-99JANETN  CAT
8 Canary   4 12.5 29 30-OCT-99 MARK Y   BIRD
9Cocketiel  5359528-FEB-99JANETY  BIRD
10Bird Food  152.253.515-APR-99MARKN  BIRD
11Fish  150.25.9923-OCT-99JANETY  FISH
12Fish Food  251.252.2524-NOV-99MARKN  FISH
13Air Filter  3152001-JAN-00JANETN  FISH
14 Chew Toy 21 23 3.5 6.5 22-FEB-00 HENRY N   DOG
15Catnip2061.121.9915-DEC-99MARKN  CAT
16Bird Treat  23.14.519-NOV-99JANETN  BIRD
17Bunny Food  103.56.7530-MAY-99MARTINN  OTHER
18Dog Collar21122.435.6514-JUL-99MARTINN  DOG
19Cat Collar20152.244.9914-JUL-99MARTINN  CAT
20Kitty Package  532.585511-JUN-99HENRYNStarter kit for bringing home all you need for your new kitty.CAT
21Puppy Package  552.387814-OCT-99JANETN  DOG
22 Puppy 21 5 40 65 15-JUL-99 JANET Y   DOG
39Guinea Pig Package 423.231.3529-AUG-99MARTINN OTHER
33 Guinea Pig Food Package 39 35 1.15 1.35 25-AUG-99 MARTIN N   OTHER
34Guinea Pig Vitamins33153.129.9505-AUG-99MARTINN OTHER
35 Guinea Pig Pellets 33 15 2.45 4.95 05-AUG-99 MARTIN N   OTHER
36Guinea Pig Cage391122.4534.9505-AUG-99MARTINN OTHER

CUSTOMER_OBJ_TABLE Table
CUST_IDFIRSTNAMELASTNAMESTREET_ADDRESSPO_BOX_
ADDRESS
CITYSTATEZIPPHONE_LISTBIRTHDATELAST_UPDATEUPDATED_
BY_USER
1AmyBlack100 West Main OmahaNE987651-808-876-6543
1-088-209-0987
11-FEB-6722-DEC-99JANET
25MarvinRedding457 Apple Lane MakenaHI998001-608-888-3243
1-876-435-0987
31-MAY-5915-NOV-99HENRY
26LesterLee197 Betty Lane HollywoodCA102931-233-443-2198
1-506-987-2320
08-SEP-5110-JUN-99HENRY
29JacobLaurel1558 South Kihei Rd KiheiHI398731-344-234-5678
1-554-543-1234
07-JUN-7415-NOV-99JANET

SALE_HEADER

SALE_HEADER Table
SALES_IDCUST_IDDETAIL_TOTALTAX_AMOUNTSHIPPING_AMOUNTSALE_TOTALSALES_DATEDETAIL_NEST
(PRODUCT_ID, ITEM_QTY,
DETAIL_AMOUNT)
22 1 89.45 3.58 15 108.03 01-MAR-00 21
1
78
4
1
5.15
332540.450040.4502-JAN-992
1
15.5
342638.991.1712.552.6614-JUL-998
1
29
10
1
3.5
16
1
4.5
15
1
1.99
351551.655.2561.912-DEC-9920
1
55
36 26 17.3 .87 2.3 20.47 29-FEB-00 14
1
6.5
18
1
5.65
4
1
5.15
PET_CARE_LOG_OBJ_TABLE Table
PRODUCT_IDLOG_DATETIMECREATED_BY_USERLOG_TEXTLAST_UPDATE_
DATETIME
2215-JAN-00JANETNew puppy needs shots.16-JAN-00
11 10-DEC-99 HENRY Fish in the big tank need only the food in the red bucket. Fish in the small front tank need only the food in the green box. 19-DEC-99
11 12-DEC-99 MARK Fish that are sold must be written down on the FISH LOG sheet for proper refunds if needed. 12-DEC-99
2 15-DEC-99 JANET Give each turtle a leaf of lettuce. Separate while eating.  


MONTHLY_SALES View
SALES_MONTH TOTAL_SALES
1999-DECEMBER 61.90
1999-JANUARY 40.45
1999-JULY52.99
2000-FEBRUARY220.47
2000-MARCH108.03

PRODUCT_PHOTO_OBJ_TABLE Table
PRODUCT_IDLAST_UPDATE_DATEPRODUCT_PHOTO
201-JAN-00boxturtle.gif
403-MAR-00dogfood.gif
5 03-JAN-00  
9 11-MAR-00 parrot.gif
1915-APR-00collar.gif
2215-MAR-00puppy.jpg