Unit 3 IPes Acess Data Base

profileGonza
u3agonzalez.mdb
Home>Information Systems homework help>Unit 3 IPes Acess Data Base
Category# Category
1 Antiques
2 Books, Movies, Music
3 Coins & Stamps
4 Collectibles
5 Computers
6 Dolls, Figures
7 Jewelry, Gemstones
8 Photo & Electronics
9 Pottery & Glass
10 Sports Memorabilia
11 Toys
12 Miscellaneous
Item# Seller Subcategory# Title Description Qty MinimumBid Duration ReservePrice Opened Visual
1 7 15 Wayne Gretsky 1981 Authentic autograph on his picture during the Stanley Cup playoffs 1 50 7 80 4/20/01
2 7 36 Ted Williams 1939 All-Star Game signing 1 200 7 300 4/20/01 #Baseball.doc#
3 2 3 18th Century Violin All parts original, needs some work 1 300 15 4/20/01 #Music.doc#
4 9 12 Pine Tree Shilling VF small planchet 1 2200 10 2600 4/21/01
5 9 12 Oak Tree Sixpence VG 1 500 10 650 4/21/01
6 9 12 Virginia Halfpenny Unc 1773 Halfpenny, no period 1 650 10 850 4/21/01
7 9 22 Cut ruby 1.5 carats 1 1500 9 1750 4/21/01
8 9 12 MA 1788 Half Cent EF original luster 1 750 10 800 4/21/01
9 9 12 Brasher Doubloon copy circa 1850 1 10 10 20 4/21/01
10 10 12 Virginia Halfpenny VF 1773 Halfpenny, no period 1 450 5 500 4/19/01
11 13 19 Bugs Bunny 1945 movie cell 1 45 10 4/18/01
12 13 19 Daffy Duck 1948 movie cell 1 40 10 4/18/01
13 13 29 1941 Ted Williams mint 1 250 7 300 4/23/01
14 13 29 1956 Mickey Mantle near mint 1 140 7 150 4/23/01
15 13 29 1958 Ted Williams rare year for Williams 1 100 7 110 4/23/01
16 13 29 1991 Barry Bonds mint 1 20 7 4/23/01
17 13 29 1962 Harmon Killebrew mint 1 45 7 45 4/23/01
18 13 29 1955 Willie Mays mint 1 90 7 100 4/23/01
19 13 29 1946 Joe DiMaggio near mint 1 175 7 200 4/23/01
20 13 36 1930 Hack Wilson 1 60 9 75 4/18/01
21 13 36 1927 Babe Ruth World Series signing 1 300 10 450 4/17/01
22 13 12 CT cent Fine sharp strike 1 120 7 150 4/27/01
23 13 30 1990 John Elway mint 1 40 8 50 5/27/01 #Football.doc#
Registrant# LastName FirstName MI Phone Email UserId Password
1 Zainea Amy M 9994530976 [email protected] Tiger regit
2 Petrosyan Edward K 9999544643 [email protected] Leopard drapoel
3 Do Khue M 9999750104 [email protected] Cobra arboc
4 Sanchez Valencia L 9992417599 [email protected] Firebrand dnarberi
5 Jukic Hava S 9998975916 [email protected] Panda adnap
6 Uzarski Mayra G 9996775349 [email protected] Tree Frog gorfeert
7 Ayala Francisco B 9998375919 [email protected] Polar Bear raebralo
8 Styne David R 9997352982 [email protected] Lizard drazil
9 Suarez Jorge R 9997840883 [email protected] Jaguar raugaj
10 Jiang Xinyan J 9996810191 [email protected] Lion noil
11 Bousu Michelle L 9998966978 [email protected] Crater retarc
12 Ramirez Rosalinda H 9994565815 [email protected] Llama amall
13 Koppelmann Jacob A 9994752955 [email protected] Lynx xnyl
14 Cook Kristine T 9996628878 [email protected] Opal lapo
15 Walker William J 9995311886 [email protected] Rhino onihr
16 Cook Marcia P 9992431241 [email protected] Cygnet tengyc
17 Visser Brad S 9995598652 [email protected] Eagle elgae
18 Cox Kelly W 9998910348 [email protected] Trout tuort
Subcategory# Subcategory Category#
1 General 1
2 Ancient World 1
3 Musical Instruments 1
4 Folk Art 1
5 Books: General 2
6 Books: Rare 2
7 Magazines: General 2
8 Magazines: Children 2
9 Music: General 2
10 Music: Tapes 2
11 Coins: US: General 3
12 Coins: US: Colonial 3
13 Stamps: World: Asia 3
14 Memorabilia: Baseball 10
15 Autographs: Sports: Hockey 10
16 Coins: Ancient 3
17 Coins: Medieval 3
18 Advertising 4
19 Animation Characters 4
20 Comic Books 4
21 Bears 4
22 Gemstones: General 7
23 Gemstones: Faceted 7
24 Gold: Antique 7
25 Gold: Comtemporary 7
26 Glass 9
27 Pottery 9
28 Porcelain 9
29 Trading Cards: Baseball 10
30 Trading Cards: Football 10
31 Trading Cards: Hockey 10
32 Trading Cards: Basketball 10
33 Vintage Barbie 6
34 Raggedy Ann, Andy 6
35 Beanie Babies 11
36 Autographs: Sports: Baseball 10
SELECT DISTINCTROW * FROM Category;
SELECT DISTINCTROW * FROM Category;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Item;
SELECT DISTINCTROW * FROM Registrant;
SELECT DISTINCTROW * FROM Registrant;
SELECT DISTINCTROW * FROM Subcategory;
SELECT DISTINCTROW * FROM Subcategory;
SELECT DISTINCTROW * FROM Subcategory;
SELECT [Subcategory].[Subcategory], [Category].[Category], [Item].[Title], [Item].[MinimumBid], [Registrant].[LastName], [Registrant].[FirstName], 2+(0.03*[MinimumBid]) AS ProjectedIncome FROM (Category INNER JOIN Subcategory ON [Category].[Category#]=[Subcategory].[Category#]) INNER JOIN (Registrant INNER JOIN Item ON [Registrant].[Registrant#]=[Item].[Seller]) ON [Subcategory].[Subcategory#]=[Item].[Subcategory#] ORDER BY [Item].[Title];
SELECT Item.[Item#], Item.Seller, Item.[Subcategory#], Item.Title, Item.Description, Item.Qty, Item.MinimumBid, Item.Duration, Item.ReservePrice, Item.Opened FROM Item WHERE (((Item.[Subcategory#])=[Enter Subcategory#:]));