Cannot Create Database
763672Apr 26 2010 — edited Apr 26 2010I am unable to create all the tables. Please someone help. Thank You
CREATE TABLE Client
(Client_Code CHAR (4) PRIMARY KEY,
Client_Name CHAR (15),
Client_Address CHAR (20),
Client_City CHAR (22),
Client_State CHAR (2),
Client_Zip CHAR (5),
Client_Phone CHAR (10)) ;
CREATE TABLE Event
(Event_Date DATE (8) PRIMARY KEY,
Client_Code CHAR (4),
Event_Time CHAR (4),
Event_Menu CHAR (35));
CREATE TABLE Supply
(Supply_Code CHAR (5) PRIMARY KEY,
Supply_Name CHAR (25),
Supply_Quantity CHAR (5),
Supply_Cost CHAR (6));
CREATE TABLE Provider
(Provider_Code CHAR (7) PRIMARY KEY,
Supply_Code CHAR (5),
ProviderName CHAR (15));
INSERT INTO Client
VALUES ('1000', 'Tom Kane', '1019 Dungan St', 'Philadelphia', 'PA', '19152', '2156732216');
INSERT INTO Client
VALUES ('1001', 'Mark Rocca', '343 Capital Way', 'Washington', 'DC', '62359', '4646932668');
INSERT INTO Client
VALUES ('1002', 'Larry Cone', '7275 Dennis Road', 'Santa Monica', 'CA', '49215', '6095576339');
INSERT INTO Client
VALUES ('1003', 'Sally Finegan', '6628 Lynford St', 'Wildwood', 'NJ', '23462', '2678923650');
INSERT INTO Client
VALUES ('1004', 'Hal Romero', '8620 Colony Dr', 'Tampa', 'FL', '73068', '7639958636');
INSERT INTO Event
VALUES ('5/15/10', '1000', '3:30pm', 'Steak and Lobster');
INSERT INTO Event
VALUES ('5/23/10', '1001', '12:15pm', 'Deli Sandwiches');
INSERT INTO Event
VALUES ('5/29/10', '1002', '10:00am', 'Pancakes, Eggs, and Toast');
INSERT INTO Event
VALUES ('6/5/10', '1003', '12:30pm', 'Roast Beef and Pork');
INSERT INTO Event
VALUES ('6/13/10', '1004', '2:00pm', 'Meatballs and Pasta');
INSERT INTO Supply
VALUES ('10001', 'Sams Club', '100', '12050', to_Date('5/15/10','mm/dd/yyyy'));
INSERT INTO Supply
VALUES ('10002', 'Sams Club', '125', '14199', to_Date('5/23/10','mm/dd/yyyy'));
INSERT INTO Supply'
VALUES ('10003', 'Sams Club', '150', '9687', to_Date('5/29/10','mm/dd/yyyy'));
INSERT INTO Supply
VALUES ('10004', 'Sams Club', '175', '10567', to_Date('6/5/10','mm/dd/yyyy'));
INSERT INTO Supply
VALUES ('10005', 'Sams Club', '200', '8623', to_Date('6/13/10','mm/dd/yyyy'));
INSERT INTO Provider
VALUES ('50001', '10001', 'Walmart');
INSERT INTO Provider
VALUES ('50002', '10002', 'Walmart');
INSERT INTO Provider
VALUES ('50003', '10003', 'Walmart');
INSERT INTO Provider
VALUES ('50004', '10004', 'Walmart');
INSERT INTO Provider
VALUES ('50005', '10005', 'Walmart');