Question: can someone help me debug this code? I am not sure why i am getting the errors i am getting. ***SQL Code*** create database Stream;

can someone help me debug this code? I am not sure why i am getting the errors i am getting. ***SQL Code***

create database Stream;

Use Stream; create table Movie( Movie_ID int NOT NULL, MovieTitle varchar(50) NOT NULL, MovieCategory varchar(50), MovieActor varchar(50), MovieRun varchar(250), PRIMARY KEY (Movie_ID), FOREIGN KEY (MovieTitle) REFERENCES Title(MovieTitle) );

Use Stream; create table Shows( Show_ID int NOT NULL, ShowTitle varchar(50) NOT NULL, ShowType varchar(50), ShowCast varchar(50), ShowInfo varchar(250), PRIMARY KEY (Show_ID), FOREIGN KEY (ShowTitle) REFERENCES Name(ShowTitle) );

Use Stream; create table Lists( Watched_Titles int, PlusTitles varchar(50), LikedTitles varchar(50), SeasonalTitles varchar(50), RecommendedTitles varchar(50), PRIMARY KEY (Watched_Titles), FOREIGN KEY (PlusTitles) REFERENCES Added(PlusTitles) );

Use Stream; create table Features( Features_ID int, DownloadOff varchar(50), ConnectivityUse varchar(50) NOT NULL, ConsumerFAQ varchar(50) NOT NULL, PRIMARY KEY (Features_ID), FOREIGN KEY (ConsumerFAQ) REFERENCES FAQ(ConsumerFAQ) );

Use Stream; create table Search( Search_ID int NOT NULL, SearchBox varchar(50) NOT NULL, RelevantTitles varchar(50) NOT NULL, KeywordResult varchar(50) NOT NULL, PRIMARY KEY (Search_ID), FOREIGN KEY (SearchBox) REFERENCES Search(SearchBox) );

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!