2/170 ( Premiere Products )

1
2/170 ( Premiere Products )
2
2/170 ( Premiere Products )
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
3
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
4
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
5
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
6
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
7
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
8
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
9
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
(PartNum, Description,
Price,

NumShipped ) )
Lets normalize (1NF).
10
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
11
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
12
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
13
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
14
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
15
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
16
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
17
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
18
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
19
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
20
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
Lets eliminate partial dependencies (2NF)
21
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
22
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
23
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date,
PartNum,
Description,
Price,
NumShipped )
24
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date) InvoiceLine(
InvoiceNum, PartNum,
Description,
Price,
NumShipped
)
25
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date) InvoiceLine(
InvoiceNum, PartNum,
Description,
Price,
NumShipped
)
26
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date) InvoiceLine(
InvoiceNum, PartNum,
Description,
Price,
NumShipped
)
27
Now lets make sure the only determinants are
candidate keys (3NF).
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date) InvoiceLine(
InvoiceNum, PartNum,
Description,
Price,
NumShipped
)
28
Now lets make sure the only determinants are
candidate keys (3NF).
Invoice (InvoiceNum, CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip,
Date) InvoiceLine(
InvoiceNum, PartNum,
Description,
Price,
NumShipped
)
29
Invoice (InvoiceNum, Date,
CustomerNum, LastName,

FirstName,
Street,
City,

State,
Zip) InvoiceLine(
InvoiceNum, PartNum,
Description,
Price,
NumShipped
)
30
Invoice (InvoiceNum, Date, CustomerNum)
Customer ( CustomerNum, LastName,

FirstName,
Street,

City,
State,

Zip) InvoiceLine( InvoiceNum,
PartNum,
Description,
Price,
NumShipped )
31
Invoice (InvoiceNum, Date, CustomerNum)
Customer ( CustomerNum, LastName,

FirstName,
Street,

City,
State,
Zip) InvoiceLine
(InvoiceNum, PartNum,
Description,
Price,
NumShipped
)
32
Invoice (InvoiceNum, Date, CustomerNum)
Customer (CustomerNum, LastName,
FirstName,
Street,
City,
State,

Zip) InvoiceLine (InvoiceNum,
PartNum,
Description,
Price,
NumShipped )
33
Invoice (InvoiceNum, Date, CustomerNum)
Customer (CustomerNum, LastName,
FirstName,
Street,
City,
State,

Zip) InvoiceLine (InvoiceNum,
PartNum,
Description,
Price,
NumShipped )


34
Invoice (InvoiceNum, Date, CustomerNum)
Customer (CustomerNum, LastName,
FirstName,
Street,
City,
State,

Zip) InvoiceLine (InvoiceNum,
PartNum,
Description,
Price,
NumShipped )

End of story.

35
3/170 ( Premiere Products )
36
3/170 ( Premiere Products )
Part (PartNum, Description, Class, Price,
(WarehouseNum, WarehouseName,
OnHand), (SupplierNum,
SupplierName, LeadTime) )
37
Part (PartNum, Description, Class, Price,
(WarehouseNum, WarehouseName,
OnHand), (SupplierNum,
SupplierName, LeadTime) )
38
Part (PartNum, Description, Class, Price,
(WarehouseNum, WarehouseName,
OnHand),
(SupplierNum, SupplierName, LeadTime) )
39
Part (PartNum, Description, Class, Price,
(WarehouseNum, WarehouseName,
OnHand) ) Part (PartNum, Description, Class,
Price, (SupplierNum,
SupplierName, LeadTime) )
40
Part_Wh (PartNum, Description, Class, Price,
(WarehouseNum,
WarehouseName, OnHand) ) Part_Sp (PartNum,
Description, Class, Price,
(SupplierNum, SupplierName, LeadTime) )
41
Part_Wh (PartNum, Description, Class, Price,
WarehouseNum,
WarehouseName, OnHand ) Part_Sp (PartNum,
Description, Class, Price,
SupplierNum, SupplierName, LeadTime )
42
Part_Wh (PartNum, Description, Class, Price,
WarehouseNum,
WarehouseName, OnHand ) Part_Sp (PartNum,
Description, Class, Price,
SupplierNum, SupplierName, LeadTime )
43
Part_Wh (PartNum, Description, Class, Price,
WarehouseNum,
WarehouseName, OnHand ) Part_Sp (PartNum,
Description, Class, Price,
SupplierNum, SupplierName, LeadTime )
44
Part_Wh (PartNum, Description, Class, Price,
WarehouseNum,
WarehouseName, OnHand ) Part_Sp (PartNum,
Description, Class, Price,
SupplierNum,
LeadTime ) Supplier (SupplierNum, SupplierName)
45
Part_Wh (PartNum, Description, Class, Price,
WarehouseNum,
WarehouseName, OnHand ) Part_Sp (PartNum,
SupplierNum,
LeadTime ) Supplier (SupplierNum,
SupplierName) Part (PartNum, Description, Class,
Price)
46
Part_Wh (PartNum, Description, Class, Price,
WarehouseNum,
WarehouseName, OnHand ) Part_Sp (PartNum,
SupplierNum,
LeadTime ) Supplier (SupplierNum,
SupplierName) Part (PartNum, Description, Class,
Price)
47
Part_Wh (PartNum,
WarehouseNum, WarehouseName, OnHand ) Part_Sp
(PartNum,
SupplierNum,
LeadTime ) Supplier (SupplierNum,
SupplierName) Part (PartNum, Description, Class,
Price)
48
Part_Wh (PartNum,
WarehouseNum, WarehouseName, OnHand ) Part_Sp
(PartNum,
SupplierNum,
LeadTime ) Supplier (SupplierNum,
SupplierName) Part (PartNum, Description, Class,
Price)
49
Part_Wh (PartNum,
WarehouseNum, WarehouseName, OnHand ) Part_Sp
(PartNum, SupplierNum,
LeadTime) Supplier (SupplierNum,
SupplierName) Part (PartNum, Description, Class,
Price)
50
Part_Wh (PartNum, WarehouseNum, WarehouseName,
OnHand ) Part_Sp (PartNum, SupplierNum,
LeadTime) Supplier
(SupplierNum, SupplierName) Part (PartNum,
Description, Class, Price)
51
Part_Wh (PartNum, WarehouseNum, WarehouseName,
OnHand ) Part_Sp (PartNum, SupplierNum,
LeadTime) Supplier
(SupplierNum, SupplierName) Part (PartNum,
Description, Class, Price)
52
Part_Wh (PartNum, WarehouseNum, WarehouseName,
OnHand ) Part_Sp (PartNum, SupplierNum,
LeadTime) Supplier (SupplierNum,
SupplierName) Part (PartNum, Description, Class,
Price)
53
Part_Wh (PartNum, WarehouseNum, WarehouseName,
OnHand ) Part_Sp (PartNum, SupplierNum,
LeadTime) Supplier (SupplierNum,
SupplierName) Part (PartNum, Description, Class,
Price)
54
2-3/171 ( Henry Books Case )
55
2-3/171 ( Henry Books Case )
Course ( CourseNum, Description, NumCredits,
(Textbook), (InstructorNum, InstructorName)
)
56
Course ( CourseNum, Description, NumCredits,
(Textbook), (InstructorNum,
InstructorName) )
57
Course ( CourseNum, Description, NumCredits,
(Textbook)) Course ( CourseNum, Description,
NumCredits, (InstructorNum, InstructorName) )
58
Crs-Txt ( CourseNum, Description, NumCredits,
(Textbook)) Crs-Ins ( CourseNum, Description,
NumCredits, (InstructorNum, InstructorName) )
59
Crs-Txt ( CourseNum, Description, NumCredits,
(Textbook)) Crs-Ins ( CourseNum, Description,
NumCredits, (InstructorNum, InstructorName) )
60
Crs-Txt ( CourseNum, Description, NumCredits,
Textbook) Crs-Ins ( CourseNum, Description,
NumCredits, InstructorNum, InstructorName )
61
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, Description, NumCredits, Instructor
Num, InstructorName ) Course(CourseNum,
Description, NumCredits)
62
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum, InstructorName
) Course(CourseNum, Description, NumCredits)
63
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
64
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
65
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
66
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
67
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
68
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
69
Crs-Txt ( CourseNum, Textbook) Crs-Ins
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
70
CourseText ( CourseNum, Textbook) CourseInstructor
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName )
71
CourseText ( CourseNum, Textbook) CourseInstructor
( CourseNum, InstructorNum ) Course(CourseNum,
Description, NumCredits) Instructors (
InstructorNum, InstructorName ) End of
story.