Oh srry about that, its a rather long project so i tried to spare some goring detail but here.

CREATE DATABASE Webstore

CREATE TABLE Customers

(

Customer_ID number(5) not null primary key,

Name varchar2(32) not null,

Shipping_Address varchar2(32) not null,

Email varchar2(32) not null,

Credit_Card# integer(16) not null,

);

CREATE TABLE Movies

(

Barcode number(3) not null ,

TitleVarchar2(32),

GenreVarchar2(32) not null,

YearNumber(4)

Media_TypeChar(1) not null,

Cost money not null,

CONSTRAINT Medt primary key (barcode)

);

CREATE TABLE DVD

(

Format char(10) not null,

Costmoney not null,

Quantity number(2) not null,

CONSTRAINT Medt

Foreign Key(barcode) references Movies(barcode),

);

CREATE TABLE Videos

(

Format char(10) not null,

Costmoney not null,

Quantity number(2) not null,

CONSTRAINT Medt

Foreign Key(barcode) references Movies(barcode),

);

Insert Statement

INSERT INTO CustomerVALUES (11111, ‘Mike Smith’, ‘111 Ship Lane, IL 67892’, ‘mikesmith@gmail.com’, 1234 5678 9101 1121);

INSERT INTO CustomerVALUES (22222, ‘John Doe’, ‘222 Miss Lane, IL 64592’, ‘jdoe@gmail.com’, 9876 5678 9101 3456);

INSERT INTO CustomerVALUES (33333, ‘Rick Slick’, ‘333 tree Lane, IL 61253’, ‘slickrick@gmail.com’, 4589 5980 1256 1631)

INSERT INTO CustomerVALUES (44444, ‘Cheap Guy’, ‘444 cheap Lane, IL 60007’, ‘nothing@gmail.com’, 1276 5980 9876 1631)

INSERT INTO MoviesVALUES (223, ‘Dark Knight’, ‘Action’, 2013, ‘D’, $20.00);

INSERT INTO MoviesVALUES (132, ‘Titanic’, ‘Romance’, 1998, ‘V’, $8.00);

INSERT INTO MoviesVALUES (213, ‘Avengers’, ‘Action’, 2013, ‘D’, $20.00);

INSERT INTO MoviesVALUES (145, ‘Lion King’, ‘Children’, 1996, ‘V’, $6.00);

INSERT INTO SalesVALUES (10, $28.00, 11/3/2013, 157, 11111);

INSERT INTO SalesVALUES (11, $40.00, 10/28/2013, 289, 22222);

INSERT INTO SalesVALUES (12, $6.00, 11/10/2013, 865, 33333);

INSERT INTO SalesVALUES (13, $20.00, 11/11/2013, 865, 33333);

INSERT INTO DVDVALUES (‘DVDd’, $100.00, 5, 223);

INSERT INTO VideoVALUES (‘SVHS’, $32.00, 4, 132 );

INSERT INTO MoviesVALUES (‘DVDplus’, $100.00, 5, 213);

INSERT INTO VideoVALUES (‘VHS’, $60.00, 10, 145);

i was told to forget about the shopping cart.