CREATE TABLE [movie] ( [movieID] integer, [moviename] varchar(50), [genreID] integer, [releasedate] date, [duration] time, [language] varchar(50), PRIMARY
Question:
CREATE TABLE [movie] ( [movieID] integer, [moviename] varchar(50), [genreID] integer, [releasedate] date, [duration] time, [language] varchar(50), PRIMARY KEY ([movieID]) );
CREATE TABLE [rental] ( [rentalID] integer, [movieID] integer, [memberID] integer, [rentaldate] date, [returndate] date, [totalcost] decimal(10,2), PRIMARY KEY ([rentalID]), CONSTRAINT [FK_rental.movieID] FOREIGN KEY ([movieID]) REFERENCES [movie]([movieID]) );
CREATE TABLE [moviecharacter] ( [characterID] integer, [role] varchar(50), [movieID] integer, PRIMARY KEY ([characterID]), CONSTRAINT [FK_moviecharacter.movieID] FOREIGN KEY ([movieID]) REFERENCES [movie]([movieID]) );
CREATE TABLE [member] ( [memberID] integer, [firstname] varchar(50), [lastname] varchar(50), [registrationdate] date, PRIMARY KEY ([memberID]) );
CREATE TABLE [finepayments] ( [finepaymentsID] integer, [memberID] integer, [paymentdate] date, [paymentamount] decimal(10,2), PRIMARY KEY ([finepaymentsID]), CONSTRAINT [FK_finepayments.memberID] FOREIGN KEY ([memberID]) REFERENCES [member]([memberID]) );
CREATE TABLE [moviegenre] ( [movieID] integer, [genreID] integer, CONSTRAINT [FK_moviegenre.movieID] FOREIGN KEY ([movieID]) REFERENCES [movie]([movieID]) );
CREATE TABLE [genredata] ( [genreID] integer, [genrename] varchar(50), PRIMARY KEY ([genreID]), CONSTRAINT [FK_genredata.genreID] FOREIGN KEY ([genreID]) REFERENCES [movie]([genreID]),
);
CREATE TABLE [fine] ( [fineID] integer, [memberID] integer, [rentalID] integer, [finedate] date, [fineamount] decimal(10,2), PRIMARY KEY ([fineID]), CONSTRAINT [FK_fine.rentalID] FOREIGN KEY ([rentalID]) REFERENCES [rental]([rentalID]), CONSTRAINT [FK_fine.memberID] FOREIGN KEY ([memberID]) REFERENCES [member]([memberID]) );
Msg 2714, Level 16, State 6, Line 1 There is already an object named 'movie' in the database.
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris