Can you create a table named MovieReviews with the following columns ReviewID - int; auto increment MovieID
Fantastic news! We've Found the answer you've been seeking!
Question:
Can you create a table named "MovieReviews" with the following columns ReviewID - int; auto increment MovieID - int; nullable. (i.e. can be null) Score - decimal; 2 decimal places; not null Comment - text; 150 character limit; nullable DatePosted - datetime (freebie: datetime is the datatype); nullable Constraints: ReviewID is the primary key MovieID is the foreign key that references MovieID of the Movies table
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: