View the step-by-step solution to:

HW1: ER Diagram for MOVIE Database length_in_minute title genre name plot_outline year_of_release Director Movie Directs date_of_birth Produces quote...

I need help in database i have a question it answer related to another answer. i want the answer to be clear and related to the pervious answer, the question is the write SQL statmente and create correspond relation. the question easy but i want good and right answer for it, that is way i am asking for help. here is the question and i attached the two file regarding to it the answer would be.

Consider the scenario from Homework1 and homework2 where you designed an
database for the Movie database. Write SQL statements to create the
corresponding relations and capture as many of the constraints as possible. If
you cannot capture some constraints, explain why.
Note: You can use the attached ER diagram and relation schema for this
assignment.
Movie Company ctor Director year_of_release title length_in_minute genre plot_outline Has Acts name date_of_birth role quote Directs name date_of_birth Produces name address HW1: ER Diagram for MOVIE Database
Background image of page 1
HW2: Relation Schema Movies(movie_year_of_release, movie_title, length_in_minutes, plot_outline, company_name) Directors(director_name, director_date_of_birth) Companies(company_name, address) Actors(actor_name, actor_date_of_birth) Direct(movie_year_of_release, movie_title, director_name, director_date_of_birth) Act (movie_year_of_release, movie_title, actor_name, actor_date_of_birth, role) Movie_Genres(genre, movie_year_of_release, movie_title) Quotes(movie_year_of_release, moive_title, actor_name, actor_date_of_birth, quote)
Background image of page 1
Sign up to view the entire interaction

Top Answer

Dear Student , PFA the Sql statement to... View the full answer

8436864.~sql

CREATE TABLE Movies(
Movie_Year_Of_Release
Number ,
Movie_Title
Varchar2(40),
Length_In_Minutes
Number,
Plot_Outline
Varchar2(40),
Company_Name
Varchar2(40),
CONSTRAINT MOVIES__Pk PRIMARY KEY (...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online