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");