Normalize each of the following tables by splitting the table into
two tables to eliminate repeating groups:
Rewrite the field names under appropriate table names.
Put the initial PK in front of the columns forming the primary key and
FK in front of each foreign key. If the table does not have a
suitable primary key, you may add columns to the table.
Each table must have a primary consisting of one or more columns.
If necessary, you may add one or more fields to a table to provide
a suitable primary key.
PersonnelTable
FirstName
LastName
EmployeeID
Address
City
State
Zip
EmployeePhoneNumbers (repeats 1-n times)
ChildFirstName
Age
Allergies (repeats 1 to n times)
AllergyType
CD Table
CDTitle
Artist
YearRecorded
Genre (rock, pop, hiphop, etc.)
YearPurchased
TrackInfo (repeats 1 to n times)
TrackTitle
TrackLength
RealEstateAgentListings Database
Listing Table
ListingID
Address
City
NumberStories
NumberofBedrooms
FrameType
Basement (Yes or No)
HeatingType
Taxes
SchoolDistrict
RoomInfo (repeats 1 to n times)
RoomID
Width
Length
FlooringType
AgentInfo (repeats 1 to n times)
AgentID
AgentName
Agent Table
Name
AgentID
Address
City
Phone
ListingInfo (repeats 1 to n times)
ListingID
Part B 10 points each
Look at each of the following website pages. For each website, identify
the primary key, if there is one, and explain in
a short paragraph whether the data on that page could be arranged into
table that satisfies the
Three Database Rules.
In particular, identify any repeating groups or data anomalies.
You must comment on each of the three database rules for each of the
following four examples for full credit.