Racquets Unlimited Relational Database

Components

Comp-Num	Comp-Name	Cost	Sup-Num
F11	Standard Frame	11.17	2607
F14	Enhanced Frame	13.26	2843
F23	Crusher Frame	18.45	2607
G02	Standard Grip	5.50	4175
G06	Destroyer Grip	6.11	4386
G35	Crusher Grip	7.45	4386
S27	Nylon	8.26	6784
S45	Imitation Gut	9.11	6923
S58	Gutex	10.55	6923
S63	Thunder Gut	12.72	6784

Supplier

Sup-Num	Sup-Name	Sup-Address
2607	Graphite World	Detroit, Michigan
2843	Frame Joint	Chicago, Illinois
4175	Grip City	Columbus, Ohio
4386	Grip and Rip	Atlanta, Georgia
6784	String Place	Birmingham, Alabama
6923	Guts R Us	Mobile, Alabama

SELECT Racquet WHERE Grip == G02

Racquet

Model	Name	Frame	Grip	String
24D	Mangler	F14	G02	S58
74C	Thumper	F11	G02	S45

PROJECT Components (Comp-Name, Cost)

Components

Comp-Name	Cost
Standard Frame	11.17
Enhanced Frame	13.26
Crusher Frame	18.45
Standard Grip	5.50
Destroyer Grip	6.11
Crusher Grip	7.45
Nylon	8.26
Imitation Gut	9.11
Gutex	10.55
Thunder Gut	12.72

JOIN Components, Supplier BY Sup-Num

Components, Supplier

Comp-Num	Comp-Name	Cost	Sup-Num	Sup-Name	Sup-Address
F11	Standard Frame	11.17	2607	Graphite World	Detroit, Michigan
F14	Enhanced Frame	13.26	2843	Frame Joint	Chicago, Illinois
F23	Crusher Frame	18.45	2607	Graphite World	Detroit, Michigan
G02	Standard Grip	5.50	4175	Grip City	Columbus, Ohio
G06	Destroyer Grip	6.11	4386	Grip and Rip	Atlanta, Georgia
G35	Crusher Grip	7.45	4386	Grip and Rip	Atlanta, Georgia
S27	Nylon	8.26	6784	String Place	Birmingham, Alabama
S45	Imitation Gut	9.11	6923	Guts R Us	Mobile, Alabama
S58	Gutex	10.55	6923	Guts R Us	Mobile, Alabama
S63	Thunder Gut	12.72	6784	String Place	Birmingham, Alabama

SELECT [JOIN Components, Supplier BY Sup-Num] WHERE Comp-Num == F*

Components, Supplier

Comp-Num	Comp-Name	Cost	Sup-Num	Sup-Name	Sup-Address
F11	Standard Frame	11.17	2607	Graphite World	Detroit, Michigan
F14	Enhanced Frame	13.26	2843	Frame Joint	Chicago, Illinois
F23	Crusher Frame	18.45	2607	Graphite World	Detroit, Michigan

Return to homepage of CS 590M - Information Systems