Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Movie(ID char(20), Title varchar(256), RelDate DateTime, Genre varchar(32), Quantity int(4),
- Primary Key(ID));
- create table Actor(Name varchar (30), Address varchar (256),
- Primary Key(Name));
- create table StarsIn(Actor varchar (30), Movie char(20),
- Foreign Key(Movie) references Movie(ID),
- Foreign Key(Actor) references Actor(Name));
- create table Customer(Name varchar(50) not null, Address varchar(256) not null, ID char(12), BirthDate DateTime,
- Primary Key(ID));
- create table Loan(CustomerID varchar(12), Date DateTime, Movie char(20), ReturnDate DateTime,
- Foreign Key(CustomerID) references Customer(ID),
- Foreign Key(Movie) references Movie(ID));
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000000", "Harry Potter 1", "20001201", "Fantasy", "12");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000001", "Harry Potter 2", "20021201", "Fantasy", "15");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000002", "Harry Potter 3", "20041201", "Fantasy", "8");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000003", "Harry Potter 4", "20061201", "Fantasy", "17");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000015", "Harry Potter 5", "20081201", "Fantasy", "17");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000004", "Harry Potter 6", "20121201", "Fantasy", "17");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000005", "Harry Potter 7 Part 1", "20161201", "Fantasy", "1");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000006", "Harry Potter 7 Part 2", "20161229", "Fantasy", "174");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000007", "Disturbed Children and their Mum's", "20061201", "Comedy", "11");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000008", "Willy bum bum", "20140806", "Erotic", "0");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000009", "Anchorman", "20161201", "Comedy", "1237");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000010", "Bob the Builder", "20161201", "Cartoon", "17");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000011", "Home and Away", "20161201", "Drama", "2");
- insert into movie(ID, Title, RelDate, Genre, Quantity) values ("000000000012", "Speedy Sloth's - the Sloth's that don't slow down (Part 2)", "20161201", "Documentry", "2");
- insert into Customer(Name, Address, ID, BirthDate) values ("Hayden", "Unit 49 / 2 Brighton Road, Rivervale, 6103", "000000000001", "19930110");
- insert into Customer(Name, Address, ID, BirthDate) values ("Rhys", "13 Sutton Way, Busselton, 6103", "000000000002", "19950514");
- insert into Loan(CustomerID, Date, Movie) values ("000000000001", "20160110", "000000000007");
- insert into Loan(CustomerID, Date, Movie) values ("000000000002", "20160110", "000000000007");
- insert into Loan(CustomerID, Date, Movie) values ("000000000001", "20160110", "000000000012");
- insert into Loan(CustomerID, Date, Movie) values ("000000000002", "20160110", "000000000012");
- insert into Loan(CustomerID, Date, Movie) values ("000000000002", "20160110", "000000000012");
- insert into Actor(Name, Address) values ("Rhys", "420 Hell yes close");
- insert into Actor(Name, Address) values ("Zeg", "Big wet fart lane, methane box, unit 69");
- insert into StarsIn(Actor, Movie) values ("Zeg", "000000000012");
- insert into StarsIn(Actor, Movie) values ("Zeg", "000000000002");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement