INSERT INTO MovieDVD VALUES ('Anm001', 'Frozen', 2013, 'Animated', 'Chris Buck', 1000, 29.99, 'A001');
INSERT INTO MovieDVD VALUES ('Anm002', 'Toy Story', 1995, 'Animated', 'John Lasseter', 100, 9.99, 'A001');
INSERT INTO MovieDVD VALUES ('Anm003', 'Finding Nemo', 2003, 'Animated', ' Andrew Stanton', 300, 12.99, 'A001');
INSERT INTO MovieDVD VALUES ('Anm004', 'The Lion King', 1994, 'Animated', 'Rob Minkoff', 50, 9.99, 'A001');
INSERT INTO MovieDVD VALUES ('Anm005', 'Shrek', 2001, 'Animated', 'Andrew Adamson', 250, 11.99, 'A001');

INSERT INTO MovieDVD VALUES ('Adv001', 'The Hunger Games', 2012, 'Adventure', 'Gary Ross', 500, 24.99, 'A001');
INSERT INTO MovieDVD VALUES ('Adv002', 'Jurassic Park', 1993, 'Adventure', 'Steven Spielberg', 300, 9.99, 'A001');
INSERT INTO MovieDVD VALUES ('Adv003', 'The Avengers', 2012, 'Adventure', ' Joss Whedon', 600, 24.99, 'A001');
INSERT INTO MovieDVD VALUES ('Adv004', 'Star Wars: Episode IV - A New Hope', 1977, 'Adventure', 'George Lucas', 10, 29.99, 'A001');
INSERT INTO MovieDVD VALUES ('Adv005', 'Avatar', 2009, 'Adventure', 'James Cameron', 500, 14.99, 'A001');

INSERT INTO MainStar VALUES ('Anm001', 'Kristen Bell');
INSERT INTO MainStar VALUES ('Anm001', 'Idina Menzel');
INSERT INTO MainStar VALUES ('Anm002', 'Tom Hanks');
INSERT INTO MainStar VALUES ('Anm002', 'Tim Allen');
INSERT INTO MainStar VALUES ('Anm003', 'Albert Brooks');
INSERT INTO MainStar VALUES ('Anm003', 'Ellen DeGeneres');
INSERT INTO MainStar VALUES ('Anm004', 'Matthew Broderick');
INSERT INTO MainStar VALUES ('Anm004', 'Jeremy Irons');
INSERT INTO MainStar VALUES ('Anm005', 'Mike Myers,');
INSERT INTO MainStar VALUES ('Anm005', 'Eddie Murphy');


INSERT INTO MainStar VALUES ('Adv001', 'Jennifer Lawrence');
INSERT INTO MainStar VALUES ('Adv001', 'Josh Hutcherson');
INSERT INTO MainStar VALUES ('Adv002', 'Sam Neill');
INSERT INTO MainStar VALUES ('Adv002', 'Laura Dern');
INSERT INTO MainStar VALUES ('Adv003', 'Robert Downey Jr.');
INSERT INTO MainStar VALUES ('Adv003', 'Chris Evans');
INSERT INTO MainStar VALUES ('Adv004', 'Mark Hamill');
INSERT INTO MainStar VALUES ('Adv004', 'Harrison Ford');
INSERT INTO MainStar VALUES ('Adv005', 'Sam Worthington');
INSERT INTO MainStar VALUES ('Adv005', 'Zoe Saldana');

Customer

CustID
CustEmail
CustPassword
BankAccounts

CREATE TABLE Customer
(
    CustID			VARCHAR(15)	NOT NULL,
    CustEmail		VARCHAR(50)	NOT NULL,
    CustPassword	VARCHAR(50)	NOT NULL,
    BankAccounts	VARCHAR(16)	NOT NULL,

    PRIMARY KEY     (CustID),
    FOREIGN KEY     (AdminID) REFERENCES Administrator (AdminID)
);

INSERT INTO Customer VALUES ('C001', 'jsmith@gmail.com', '123John456Smith', '3951392965135342', 'A001');
INSERT INTO Customer VALUES ('C002', 'jharmon@aol.com', 'paassword', '2956346310773825', 'A001');
INSERT INTO Customer VALUES ('C003', 'gmendoza@gmail.com', 'securepassword', '1333126171304496', 'A001');
INSERT INTO Customer VALUES ('C004', 'opatton@yahoo.com', 'ilovepasswords', '9211860548818519', 'A001');
INSERT INTO Customer VALUES ('C005', 'dtaylor@gmail.com', 'wordpass', '8276776123212429', 'A001');
INSERT INTO Customer VALUES ('C006', 'ryanwells1994@gmail.com', 'neverguessmypass', '7310271052104892', 'A001');
INSERT INTO Customer VALUES ('C007', 'bradleycastillo@comcast.net', 'password123', '5299232863876924', 'A001');
INSERT INTO Customer VALUES ('C008', 'dsimmons@gmail.com', 'password312', '0322374377940080', 'A001');
INSERT INTO Customer VALUES ('C009', 'pbrooks@yahoo.com', 'whatismypass', '1677261792452656', 'A001');
INSERT INTO Customer VALUES ('C010', 'brandoningram@gmail.com', 'mypassiscool', '9151313190525290', 'A001');
INSERT INTO Customer VALUES ('C011', 'csantos213@yahoo.com', 'mypassiscooler', '3527505303821717', 'A001');
INSERT INTO Customer VALUES ('C012', 'shirleyparkspoorly@gmail.com', 'whatsapass', '3424864052881083', 'A001');
INSERT INTO Customer VALUES ('C013', 'stevekelley@comcast.net', 'mypassisbest', '9001043401494209', 'A001');
INSERT INTO Customer VALUES ('C014', 'cfernandez@gmail.com', 'pass', '7888591686333616', 'A001');
INSERT INTO Customer VALUES ('C015', 'janeburton1982@gmail.com', 'wordpass1234', '6174819139570395', 'A001');
INSERT INTO Customer VALUES ('C016', 'krob@comcast.net', 'securepassword11', '7720013072975512', 'A001');
INSERT INTO Customer VALUES ('C017', 'eflem@comcast.net', 'mypassiscoolest', '6572296880241671', 'A001');
INSERT INTO Customer VALUES ('C018', 'shellyweaver@yahoo.com', 'mypassis1231', '2648212113290553', 'A001');
INSERT INTO Customer VALUES ('C019', 'jimmiehines1992@gmail.com', 'mypassis1', '5917381979254322', 'A001');
INSERT INTO Customer VALUES ('C020', 'bradleygriffin@gmail.com', 'password', '0800127399230728', 'A001');