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

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 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": "Espau00f1ol"}]
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

Explanation / Answer

Tables in 3NF

movie(movieid,budget,homepage, release_date,revenue,runtime, status,original_language,original_title, tagline,title, vote_average, vote_vount,overview,popularity)

genre(genreid,name)

keywords(keywordid,name)

production_companies(id,name)

production_countries(name,iso_3166_1)

spoken_languages(name,iso_639_1)

underlined are primary keys

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---