LastName
LastName / StudentNumberBaker / 100
Abernathy / 200
Jackson / 300
Johnson / 400,700
Tufte / 500
Smathers / 600
LastName / StudentNumber
Baker / 100
Abernathy / 200
Jackson / 300
Johnson / 400
Tufte / 500
Smathers / 600
Johnson / 700
Major / StudentNumber
Accounting / 100,300,500,700
Info Systems / 200,600
Marketing / 400
Major / StudentNumber
Accounting / 100
Info Systems / 200
Accounting / 300
Marketing / 400
Accounting / 500
Info Systems / 600
Accounting / 700
StudentNumber / Name / Name / Major
100 / James / Baker / Accounting
200 / Mary / Abernathy / Info Systems
300 / Beth / Jackson / Accounting
400 / Eldridge / Johnson / Marketing
500 / Chris / Tufte / Accounting
600 / John / Smathers / Info Systems
700 / Michael / Johnson / Accounting
700 / Michael / Johnson / Accounting
StudentNumber / FirstName / LastName / Major
100 / James / Baker / Accounting
200 / Mary / Abernathy / Info Systems
300 / Beth / Jackson / Accounting
400 / Eldridge / Johnson / Marketing
500 / Chris / Tufte / Accounting
600 / John / Smathers / Info Systems
700 / Michael / Johnson / Accounting
PROJECT relation (homework)
100A / Jones / 64K
100A / Smith / 51K
100B / Smith / 51K
200A / Jones / 64K
200B / Jones / 64K
200C / Parks / 28K
200C / Smith / 51K
200D / Parks / 28K
PROJECT (ProjectID, EmployeeName, EmployeeSalary)
Where
ProjectID is the name of a work project.
EmployeeName is the name of an employee who works on that project
EmployeeSalary is the salary of the employee whose name is EmployeeName
figure 5-3 p. 124
100 / Skiing / 200 / Smith
150 / Swimming / 50 / Jones
175 / Squash / 50 / Black
200 / Swimming / 50 / Blake
Figure 5-4 p 124
SID / Activity / Fee100 / Skiing / 200
100 / Golf / 65
150 / Swimming / 50
175 / Squash / 50
175 / Swimming / 50
200 / Swimming / 50
200 / Golf / 65
(SID,Activity) à Fee
Table above is NOT in 2nd Normal Form because it is not true that
All of the non-key attributes are dependent on the entire key
Fee is partially dependent of the key
SID / Activity100 / Skiing
150 / Swimming
175 / Squash
200 / Swimming
Activity / Fee
Skiing / 200
Swimming / 50
Squash / 50