Normalization Homework(#3) Below is data in flat file notation. Show each of the

Question

Normalization Homework(#3) Below is data in flat file notation. Show each of the following in 3rd normal form. You may show the intermediate steps or just the final 3rd normal form. The format is as follows: (...) shows the entire file. { are repeating groups within the file. Sometimes there are repeating groups within repeating groups (i.e. Author names for a book or Actor names for a film. DVDs (DVD#, MovieName.(ActorFirst, ActorLast, Lead), DirectorName, Rating, RentersName, DateBorrowed, DateReturned)) CarDealer(vin#, make, year, color, owners name, {service date.(service, description, mechanicname, costperhr)))

Explanation / Answer

The 3nf tables are as follows:

Rent table:

DVD# RentersName Dateborrowed DateReturned

Movie table:

Movieid MovieName Actors DirectorName Rating

DVD Table

DVD# MovieID

Car Dealer:

Service Master table

ServiceID Servicename ServiceDescription costperhour

Mechanic table

MechanicID MechanicName

Service Transaction table

Vehiclenumber ServiceID Mechanic ID ServiceDate

Vehicle table

VehicleNumber make year color ownername

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.