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.

The following represents a database table called "movies". Design relations in such

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 11800

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!