Note that, except for numeric datatypes, all data should be surrounded by quotes

Question

Note that, except for numeric datatypes, all data should be surrounded by quotes for insertion, and the data should be typed
in exactly as shown in the above table (e.g., the Joined attribute in User should be formatted exactly as shown.
Also note that there should be specific auto-generated values for some tuples/attributes, which will require
ordering your insertion statements in a particular way.

Gross MID DateReleased Title Movie MID MID Username AID. Stars Reviews Review FirstName Actor LastName User Joined AID Username CreditedAs

Explanation / Answer

crate database MovieReview;

use MovieReview;

create table Movies(
MID integer primary key autoincrement,
Title char(128),
Gross real not null,
DateReleased date);

create table Actor(
AID integer primary key autoincrement,
FirstName char(50) not null,
LastName char(50) not null,
CreditedAs char(50) null
);

create table User
(
Username char(20) not null unique,
Joined datetime not null);

create table Reviews(
MID integer not null ,
Username char(20) not null ,
Review text not null);

create table Star(
AID integer not null,
MID inetger not null);

insert into User(Username,Joined)values('movieJunkie','2001-08-02 13:45:45');
insert into Star(AID,MID)values(1,1);
insert into Star(AID,MID)values(2,1);
insert into Movies(Title,Gross,DateReleased)values('The Wild West','6502831.03','2004-10-05');
insert into Actor(FirstName,LastName,CreditedAs)values('John','Smith','');
insert into Actor(FirstName,LastName,CreditedAs)values('Emiley','Joenson','Em Jenson');

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.