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
Get step-by-step solutions from verified subject matter experts
