Database Purpose: Track the history of Concerts, when they were held, the artist
ID: 656356 • Letter: D
Question
Database Purpose: Track the history of Concerts, when they were held, the artist, and the production company involved with each concert.
Assume that the artist represents the whole performing group
Concerts
ConcertID_PK
StreetAddress
City
State
ZipCode
Artist Name
ArtistPhoneNo
ProductionCompanyName
CompanyStreetAddress
CompanyCity
CompanyState
CompanyZipCode
ArtistsConcertPrice
ConcertDate
Project Requirements:
List all fields that violate the third normal form.
Redesign the database on paper that includes at least the information in the table
design above and meets the following business rules and design requirements.
Business Rules:
Should be able to track every concert, including the artist price for that concert, date and the production company.
Assume that only one phone number is needed for an artist.
Assume that an artist can work with multiple production company
Explanation / Answer
Concert
ConcertId (Primary key)
StreetAddress
City
State
ZipCode
Artist
ArtistName(Primary Key)
ArtistPhoneNo
Company
ProductionCompanyName( P K)
CompanyStreetAddress
CompanyCity
CompanyState
ArtistConcertPrice
ConcertDate
In the above table the first table is connected to the third table ie Concert is connected to company through ConcertDate
Second to the third ie Artist is connected to company through ArtistConcertPrice
sorry forget to mention two field in the above table
ConcertId (Primary key)
StreetAddress
City
State
ZipCode
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.