Examine the following cases and answer
the questions by clicking on the correct buttons (try not to look at the
solution until you have answered the question.)
Example One:
Ship(BoatId, NbrOfPools, YearMade, Tonage, CompanyId, CompanyName)
The only functional dependencies for
this table are:
BoatId --> NbrOfPools, YearMade, Tonage,
CompanyId, CompanyName
CompanyId --> CompanyName
CompanyName --> CompanyId
Which Normal form is the Ship table in?
Repeating Groups Partial Key Dependencies Transitive Dependencies
Solution for Number One
Ship(BoatId, NbrOfPools, YearMade, Tonage, CompanyId)Company(CompanyId, CompanyName)
In this example CompanyId is a foreign key in the Ship table.