databace project

profilesholy9938
dbp-e14-cape-codd_original.accdb
Home>Computer Science homework help>databace project
CatalogID SKU SKU_Description Department CatalogPage DateOnWebSite
20130001 100100 Std. Scuba Tank, Yellow Water Sports 23 1/1/13
20130002 100500 Std. Scuba Tank, Light Green Water Sports 7/1/13
20130003 100600 Std. Scuba Tank, Dark Green Water Sports 7/1/13
20130004 101100 Dive Mask, Small Clear Water Sports 24 1/1/13
20130005 101200 Dive Mask, Med Clear Water Sports 24 1/1/13
20130006 201000 Half-dome Tent Camping 45 1/1/13
20130007 202000 Half-dome Tent Vestibule Camping 47 1/1/13
20130008 301000 Light Fly Climbing Harness Climbing 76 1/1/13
20130009 302000 Locking Carabiner, Oval Climbing 78 1/1/13
SKU_Description Department CatalogPage DateOnWebSite CatalogID SKU
Std. Scuba Tank, Yellow Water Sports 23 1/1/14 20140001 100100
Std. Scuba Tank, Light Blue Water Sports 23 1/1/14 20140002 100300
Std. Scuba Tank, Dark Blue Water Sports 8/1/14 20140003 100400
Dive Mask, Small Clear Water Sports 26 1/1/14 20140004 101100
Dive Mask, Med Clear Water Sports 26 1/1/14 20140005 101200
Half-dome Tent Camping 46 1/1/14 20140006 201000
Half-dome Tent Vestibule Camping 46 1/1/14 20140007 202000
Light Fly Climbing Harness Climbing 77 1/1/14 20140008 301000
Locking Carabiner, Oval Climbing 79 1/1/14 20140009 302000
CatalogID SKU SKU_Description Department CatalogPage DateOnWebSite
20150001 100100 Std. Scuba Tank, Yellow Water Sports 23 1/1/15
20150002 100200 Std. Scuba Tank, Magenta Water Sports 23 1/1/15
20150003 101100 Dive Mask, Small Clear Water Sports 27 8/1/15
20150004 101200 Dive Mask, Med Clear Water Sports 27 1/1/15
20150005 201000 Half-dome Tent Camping 45 1/1/15
20150006 202000 Half-dome Tent Vestibule Camping 45 1/1/15
20150007 203000 Half-dome Tent Vestibule - Wide Camping 4/1/14
20150008 301000 Light Fly Climbing Harness Climbing 76 1/1/15
20150009 302000 Locking Carabiner, Oval Climbing 78 1/1/15
WarehouseID SKU QuantityOnHand QuantityOnOrder SKU_Description
100 100100 250 0 Std. Scuba Tank, Yellow
200 100100 100 50 Std. Scuba Tank, Yellow
300 100100 100 0 Std. Scuba Tank, Yellow
400 100100 200 0 Std. Scuba Tank, Yellow
100 100200 200 30 Std. Scuba Tank, Magenta
200 100200 75 75 Std. Scuba Tank, Magenta
300 100200 100 100 Std. Scuba Tank, Magenta
400 100200 250 0 Std. Scuba Tank, Magenta
100 101100 0 500 Dive Mask, Small Clear
200 101100 0 500 Dive Mask, Small Clear
300 101100 300 200 Dive Mask, Small Clear
400 101100 450 0 Dive Mask, Small Clear
100 101200 100 500 Dive Mask, Med Clear
200 101200 50 500 Dive Mask, Med Clear
300 101200 475 0 Dive Mask, Med Clear
400 101200 250 250 Dive Mask, Med Clear
100 201000 2 100 Half-dome Tent
200 201000 10 250 Half-dome Tent
300 201000 250 0 Half-dome Tent
400 201000 0 250 Half-dome Tent
100 202000 10 250 Half-dome Tent Vestibule
200 202000 1 250 Half-dome Tent Vestibule
300 202000 100 0 Half-dome Tent Vestibule
400 202000 0 200 Half-dome Tent Vestibule
100 301000 300 250 Light Fly Climbing Harness
200 301000 250 250 Light Fly Climbing Harness
300 301000 0 250 Light Fly Climbing Harness
400 301000 0 250 Light Fly Climbing Harness
100 302000 1000 0 Locking Carabiner, Oval
200 302000 1250 0 Locking Carabiner, Oval
300 302000 500 500 Locking Carabiner, Oval
400 302000 0 1000 Locking Carabiner, Oval
OrderNumber SKU Price ExtendedPrice Quantity
1000 201000 ¤ 300.00 ¤ 300.00 1
1000 202000 ¤ 130.00 ¤ 130.00 1
2000 101100 ¤ 50.00 ¤ 200.00 4
2000 101200 ¤ 50.00 ¤ 100.00 2
3000 100200 ¤ 300.00 ¤ 300.00 1
3000 101100 ¤ 50.00 ¤ 100.00 2
3000 101200 ¤ 50.00 ¤ 50.00 1
OrderNumber StoreNumber OrderMonth OrderTotal OrderYear StoreZIP
1000 10 December ¤ 445.00 2014 98110
2000 20 December ¤ 310.00 2014 02335
3000 10 January ¤ 480.00 2015 98110
SKU SKU_Description Department Buyer
100100 Std. Scuba Tank, Yellow Water Sports Pete Hansen
100200 Std. Scuba Tank, Magenta Water Sports Pete Hansen
101100 Dive Mask, Small Clear Water Sports Nancy Meyers
101200 Dive Mask, Med Clear Water Sports Nancy Meyers
201000 Half-dome Tent Camping Cindy Lo
202000 Half-dome Tent Vestibule Camping Cindy Lo
301000 Light Fly Climbing Harness Climbing Jerry Martin
302000 Locking Carabiner, Oval Climbing Jerry Martin
WarehouseID WarehouseCity WarehouseState Manager SquareFeet
100 Atlanta GA Dave Jones 125000
200 Chicago IL Lucille Smith 100000
300 Bangor ME Bart Evans 150000
400 Seattle WA Dale Rogers 130000
500 San Francisco CA Grace Jefferson 200000
SELECT Department, Buyer FROM SKU_DATA;
SELECT SKU_DATA.Department, Count(*) AS Dept_SKU_Count FROM SKU_DATA WHERE (((SKU_DATA.SKU)<>302000)) GROUP BY SKU_DATA.Department ORDER BY Count(*);