Below are tables that exist in a database. Construct/add the tables in such a wa

Question

Below are tables that exist in a database. Construct/add the tables in such a way that they are in inner join able, but most importantly are still in at least second normal form. The database as-is being in third normal form. Primary Keys are Red 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)

Explanation / Answer

Hi,

actor(actor_id, name, age, contact, movies_acted)

producer(producer_id,name,contact, id);

director(director_id,name, address, movies_directed)

movielocation(location_id,city,street,zip,state)

cameraman(cameramanid,name, phone, movieid)

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.