Question
The following represents a database table called movies. Design relations in such a way that the data is in at least Second Normal Form. The
The following represents a database table called "movies". Design relations in such a way that the data is in at least Second Normal Form. The solution should include all the "table" relations required to meet this normalization requirement. Higher forms of normalization (3NF etc) are okay. *Tip: Pay attention to fields like "genres" which contain multiple results.
Field List Example
budget 237000000 genres [{"id": 28, "name": "Action"}, {"id": 12, "name": "Adventure"}, {"id": 14, "name": "Fantasy"}, {"id": 878, "name": "Science Fiction"}] homepage http://www.avatarmovie.com/ id 19995 keywords [{"id": 1463, "name": "culture clash"}, {"id": 2964, "name": "future"}, {"id": 3386, "name": "space war"}, {"id": 3388, "name": "space colony"}, {"id": 3679, "name": "society"}] original_language en original_title Avatar overview In the 22nd century, a paraplegic Marine is dispatched to the moon Pandora on a unique mission, but becomes torn between following orders and protecting an alien civilization. popularity 150.437577 production_companies [{"name": "Ingenious Film Partners", "id": 289}, {"name": "Twentieth Century Fox Film Corporation", "id": 306}, {"name": "Dune Entertainment", "id": 444}] production_countries [{"iso_3166_1": "US", "name": "United States of America"}, {"iso_3166_1": "GB", "name": "United Kingdom"}] release_date 12/10/2009 revenue 2787965087 runtime 162 spoken_languages [{"iso_639_1": "en", "name": "English"}, {"iso_639_1": "es", "name": "Espa\u00f1ol"}] status Released tagline Enter the World of Pandora. title Avatar vote_average 7.2 vote_count 11800
Field List budget genres homepage id keywords original _language original title overview popularity production_companiesname": "Ingenious Film Partners", "id": 289], f"name": "Twentieth Century Fox Film Corporation", "id": 306]] production countries [{"iso 3166 1":"US", "name": "United States of America"), {"iso 3166 1":"GB", "name": "United Kingdom" release date revenue runtime spoken_languages "iso_639_1": "en", "name": "English"J, f"iso_639_1": "es", "name": "Espa u00f1ol"] status tagline title vote_average vote_count Exanple 237000000 K"id": 28, "name": "Action"], ["id": 12, "name": "Adventure"]] http://www.avatarmovie.com/ 19995 f"id": 1463, "name": "culture clash"], f"id": 2964, "name": "future")] en Avatar In the 22nd century, a paraplegic Marine is dispatched to the moo... 150.437577 12/10/2009 2787965087 162 Released Enter the World of Pandora Avatar 7.2 11800Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started