Databases Reference
In-Depth Information
Orchestra Name
City
Orchestra Name
Country
Orchestra Name
Music Director
Musician Number
Musician Name
Musician Number
Instrument
Musician Number
Annual Salary
Musician Number
Orchestra Name
Musician Number, Degree
University
Musician Number, Degree
Year
Composer Name
Country
F IGURE 7.38
List of defining associations (functional
dependencies) for the attributes of the
World Music Association example
Composer Name
Date of Birth
Composition Name, Composer Name
Year (composed)
Orchestra Name, Composition Name, Composer Name
Price, Year (recorded)
Example: World Music Association
The World Music Association example is straightforward in terms of data
normalization. The complete list of functional dependencies is shown in Figure 7.38.
Since degree is unique only within a musician and composition name is unique only
within a composer, note that three of the functional dependencies are:
Musician Number, Degree
University
Musician Number, Degree
Year
Composition Name, Composer Name
Year
The primary key attributes in first normal form are:
Orchestra Name
Musician Number
Degree
Composer Name
Composition Name
With this in mind, proceeding from first to second normal form will produce
the tables in Figure 7.23. These are free of data redundancy and are, indeed, also in
third normal form.
Example: Lucky Rent-A-Car
Figure 7.39 lists the Lucky Rent-A-Car functional dependencies. The primary key
attributes in first normal form are:
Manufacturer Name
Car Serial Number
Repair Number
Customer Number
Rental Date
Search WWH ::
Custom Search