Question: Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID , Title, Year Released, Genre (
Design the database in an MS Excel spreadsheet as a single relation called Movie. It should contain an ID Title, Year Released, Genre eg scifi comedy, thriller, etc. Rating eg G PG R etc. Format eg VHS DVD MP etc. a freeform Comments field, plus the main cast and crew members. Add the following entry plus at least two of your own: Title: Star Trek Year: Genre: SciFi Rating: PG Format: DVD Director: J J Abrams Starring: Chris Pine Capt Kirk Zachary Quinto Mr Spock Zoe Saldana Uhura Karl Urban Bones McCoy What normal form is this design? Why? What should be done to correct the design?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
