CREATE TABLE customers6
(customer_ID number (6),
customer_last_name varchar2 (26),
customer_first_name varchar2 (26),
customer_street varchar2 (26),
customer_city varchar2 (26),
customer_state char(2),
customer_zip number(9), 
customer_phone varchar2 (12),
CONSTRAINT customers6_customer_id_pk PRIMARY KEY (customer_id)); 

CREATE TABLE kayaks6
(kayak_ID number (6),
kayak_manufacturer varchar2 (26),
kayak_model varchar2 (26),
kayak_year date, 
kayak_length number (2,1), 
kayak_type varchar2 (26),
kayak_price number (9), 
customer_id number (6), 
CONSTRAINT kayaks6_kayak_id_pk PRIMARY KEY (kayak_id),
CONSTRAINT kayaks6_cust_id_fk FOREIGN KEY (customer_id) REFERENCES customers6(customer_id));

CREATE TABLE discounts6
(kayak_ID number (6),
customer_id number (6), 
discount_percentage number (6),
CONSTRAINT discounts6_kayak_id_cust_id_pk PRIMARY KEY (kayak_id, customer_id));

INSERT INTO customers6 
VALUES (1234, 'Fred', 'Friendly', '123 Friendly Lane', 'Levittown', 
'NY', '11761', '516-773-5000');

INSERT INTO customers6 
VALUES (1235, 'Zelda', 'Fitzgerald', '111 Fairfield Place', 'Little Egg', 
'NY', '11024', '516-528-5370');



INSERT INTO kayaks6
VALUES (1, 'dagger', 'mamba 8.5', TO_DATE('2006', 'YYYY'), 8.5, 
'recreational', 429, 1234);             

   INSERT INTO kayaks6
VALUES (2, 'dagger', 'mamba 8.0', TO_DATE('2006', 'YYYY'), 8.0, 
'recreational', 409, 1235);

INSERT INTO discounts6
VALUES (1, 1234, 50);



SELECT * from KAYAKS6 where Kayak_ID =1; 

drop table kayaks4; 
drop table discounts4;
drop table customers4;