use Movies

print 'inserting data into Director'
insert Director(DirID,FirstName,LastName) values('D0001','J.Lee','Thompson')
insert Director(DirID,FirstName,LastName) values('D0002','Martin','Campbell')
insert Director(DirID,FirstName,LastName) values('D0003','Mel','Gibson')
insert Director(DirID,FirstName,LastName) values('D0004','David','Lean')
insert Director(DirID,FirstName,LastName) values('D0005','Roger','Spottiswoode')
insert Director(DirID,FirstName,LastName) values('D0006','Roland','Emmerich')
insert Director(DirID,FirstName,LastName, DOB, Background) values('D0007','James','Cameron','16-Aug-54','Man obsessed with perfecting the art of story telling.')
insert Director values('D0008','Steven','Spielberg','18-Dec-46','Birthplace : Cincinnati, Ohio, USA.The brilliant mind of Steven Spielberg brings the world more wonders than most would expect from their religion, and amazement which takes us back to our childhood.')
insert Director(DirID,FirstName,LastName) values('D0009','Mark L.','Lester')
insert Director(DirID,FirstName,LastName) values('D0010','Ted','Kotcheff')
insert Director(DirID,FirstName,LastName) values('D0011','Renny','Harlin')
insert Director(DirID,FirstName,LastName) values('D0012','Richard','Attenborough')

print 'inserting data into Producer'
insert Producer values('P0001','Columbia/Tristar')
insert Producer values('P0002','Paramount Pictures')
insert Producer values('P0003','MGM Home Entertainment')
insert Producer values('P0004','Twentyth Century Fox')
insert Producer values('P0005','James Cameron')
insert Producer values('P0006','Universal Studios')
insert Producer values('P0007','Artisan Entertainment')


print 'inserting data into Movie'
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0001','Mackenna Gold','D0001','P0001',128)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0002','The Mask of Zorro','D0002','P0001',137)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0003','BraveHeart','D0003','P0002',177)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0004','Lawrence of Arabia','D0004','P0001',228)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0005','Tomorrow Never Dies','D0005','P0003',117)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0006','Independence Day','D0006','P0004',120)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0007','The Terminator','D0007','P0005',108)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0008','Indiana Jones and the Last Crusade','D0008','P0002',128)
insert Movie(MovID,MovTitle,DirID,ProdID,Duration) values('M0009','Indiana Jones and the Temple of Doom','D0008','P0002',118)

print 'inserting data into Actor'
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0001','Gregory','Peck','5-Apr-1916','Fullname: Eldred Gregory Peck')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0002','Antonio','Banderas','10-Aug-1960','Fullname: Jose Antonio Dominguez Bandera, Birthplace:Malaga, Spain')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0003','Anthony','Hopkins','31-Dec-1937','Fullname: Philip Anthony Hopkins, Birthplace:Port Talbot, Wales')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0004','Mel','Gibson','3-Jan-1956','Birthplace : Peekskill, New York, USA')
insert Actor(ActorID,FirstName,LastName) values('A0005','Patrick','McGoohan')
insert Actor(ActorID,FirstName,LastName) values('A0006','Joes','Ferrer')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0007','Pierce','Brosnan','16-May-1956','Birthplace : Navan, County Meath, Ireland')
insert Actor(ActorID,FirstName,LastName) values('A0008','Jonathan','Pryce')
insert Actor(ActorID,FirstName,LastName) values('A0009','Will','Smith')
insert Actor(ActorID,FirstName,LastName) values('A0010','Bill','Pullman')
insert Actor(ActorID,FirstName,LastName) values('A0011','Jeff','Goldblum')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0012','Arnold','Schwarzenegger','30-Jul-1947','Birthplace : Thal, Austria. Bodybuilder turned Actor.')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0013','Linda','Hamilton','26-Sep-1956','Birthplace : Salisbury,Maryland,USA.')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0014','Harrison','Ford','13-Jul-1942','Birthplace : Chicago, Illinois.The legendary Indiana Jones.')
insert Actor(ActorID,FirstName,LastName) values('A0015','Roy','Scheider')
insert Actor(ActorID,FirstName,LastName) values('A0016','Sam','Neill')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0017','Leonardo','Di Caprio','11-Nov-1974','Birthplace : Los Angels, CA. The handsome young lad aboard the dream starliner called Titanic.')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0018','Kate','Winslet','5-Oct-1975','Birthplace :Reading, England. One of the 50 Most Beautiful People in the world.')
insert Actor(ActorID,FirstName,LastName,DOB,Background) values('A0019','Sylvester','Stallon','1946','Fullname: Sylvester Enzio Stallon, Birthplace:New York. Known for his memorable role as John Rambo in First Blood among others.')

print 'inserting data into Video'
insert video values('V0001','M0001','VHS',10)
insert video values('V0002','M0002','VHS',14)
insert video values('V0003','M0002','DVD',19.5)
insert video values('V0004','M0003','VHS',21.2)
insert video values('V0005','M0004','VHS',18.7)
insert video values('V0006','M0005','VHS',30)
insert video values('V0007','M0005','DVD',24.5)
insert video values('V0008','M0006','VHS',14)
insert video values('V0009','M0007','VHS',10)
insert video values('V0010','M0007','DVD',21)
insert video values('V0011','M0008','VHS',14)
insert video values('V0012','M0009','VHS',14)

print 'inserting data into ActorMovie'
insert ActorMovie values('A0001','M0001','L')
insert ActorMovie values('A0002','M0002','L')
insert ActorMovie values('A0003','M0002','N')
insert ActorMovie values('A0004','M0003','L')
insert ActorMovie values('A0005','M0003','N')
insert ActorMovie values('A0006','M0004','L')
insert ActorMovie values('A0007','M0005','L')
insert ActorMovie values('A0008','M0005','N')
insert ActorMovie values('A0009','M0006','L')
insert ActorMovie values('A0010','M0006','N')
insert ActorMovie values('A0011','M0006','N')
insert ActorMovie values('A0012','M0007','L')
insert ActorMovie values('A0013','M0007','N')
insert ActorMovie values('A0014','M0008','L')
insert ActorMovie values('A0014','M0009','L')
insert ActorMovie values('A0003','M0002','N')

print 'Inserting record into Customer table'
INSERT INTO Customer (FirstName, LastName, Address, City, State, Zip, Phone, Email, DOB, CreditCardNum, CreditCardValidUpto)
VALUES ('John', 'Lee', '12345, Street', 'Salt Lake', 'Utah', '11009', '9762779485', 'jlee@hotmail.com', '01/01/1990', '123456789012345', '01/01/2005')
