Write down the normalized entities in the correct format

Assignment Help Computer Engineering

Reference no: EM1329230

Normalize to the 3NF the following collections of data attributes, Write the normalized entities in the correct format and underline the attributes which form the primary key(s). Make whatever assumptions that you need to, but document your assumptions.

1) Video Tapes (Title, Director, Actors, Date, Music Tracks, Duration, Theme, Language, Country, Awards, Version, Rating, Format)
- Theme could be Mystery, Romance, Action, etc.
- Version could be Directors Cust, Edited for TV, Unrated, etc.
- Rating could be PG, R, NC17, etc.
- Format could be 16:9, or 4:3.

2) University(StudentID, StudentName, StudentEmail, CourseID, CourseSection, CourseGrade, ProfessorName, DegreeProgram)
- University students are in a degree program and take courses which professors teach.

3) Product(ProductID, PartID, ProductName, PartName, PartQuantity,
- A product is built from many parts.
- Many copies of the same part may be used in one product (ex. 1 inch pan headed screws). PartQuantity is the number of a specific part that is used in a specific product.

Reference no: EM1329230

Questions Cloud

Illustrate what is more important for them to monitor : Illustrate what is more important for them to monitor and target, inflation or interest rates.

Calculate the present value of a deposit : How much would you have to invest today to receive:

Strengths and criticisms of each of theories : Discuss the strengths and criticisms of each of the theories/models.

Elucidate what would be the budget request : Elucidate what would be the budget request for FY13 for this effort.

Write down the normalized entities in the correct format : Write down the normalized entities in the correct format.

Present value help : Basic Buildings Inc. has decided to go public with a $5,000,000 new equity issue. Its investment bankers agreed to take a smaller fee now (6 percent of par value versus 10 percent) in exchange for a 1-year option to purchase an additional 200,000 ..

Find the optimal job sequence for this serial system : Find the optimal job sequence for this serial system with the minimum makespan.

Provide reasons to explain what the government : Provide reasons to explain what the government would have to do to keep the unemployment rate

Find the collection of decidable languages is closed : find the collection of decidable languages is closed.

User Account

All Pages