CREATE TABLE customers
(c_id		NUMBER(6), 
 c_name		varchar2(12),
 c_address	varchar2(12),
 C_city		varchar2(12),
 c_state	varchar2(2),
CONSTRAINT customer_cust_id_pk PRIMARY KEY(c_id));

CREATE TABLE stocks
(s_id		NUMBER(6),
 s_stock	varchar2(10),
 s_price	NUMBER(6),
 s_dividen	NUMBER(6),
 s_value	NUMBER(6),
 s_share	NUMBER(6),
CONSTRAINT stocks_s_id_pk PRIMARY KEY (s_id));

CREATE TABLE customerStocks
(c_id		NUMBER(6),
 s_id		NUMBER(6),
 c_name		varchar2(12),
 c_address	varchar2(12),
 C_city		varchar2(12),
 c_state	varchar2(2),
 s_stock	varchar2(10),
 s_price	NUMBER(6),
 s_dividen	NUMBER(6),
 s_value	NUMBER(6),
 s_share	NUMBER(6),
 CONSTRAINT	customerStocks_c_id_fk FOREIGN KEY (c_id) REFERENCES customers(c_id),
 CONSTRAINT customerStocks_s_id_fk FOREIGN KEY (s_id) REFERENCES stocks(s_id));
 
 INSERT INTO customers
 VALUES(3, 'Lee', '123 Main St.', 'Lodi', 'CA');
 
 INSERT INTO customers
 VALUES(4, 'Jones', '234 First St', 'Lodi', 'CA');
 
 INSERT INTO stocks
 VALUES(1, 'IBM', 100, 2.25, 2000, 20);
 
 INSERT INTO stocks
 VALUES(2, 'ATT', 30, 1, 180, 6);
 
 INSERT INTO stocks
 VALUES(3, 'GM', 50, 1.25, 1000, 20);
 
 INSERT INTO stocks
 VALUES(4, 'IBM', 100, 2.25, 1000, 10);
 
 INSERT INTO customerStocks
 VALUES(3, 1, 'Lee', '123 Main St', 'Lodi', 'CA', 'IBM', 100, 2.25, 2000, 20);
 
 INSERT INTO customerStocks
 VALUES(4, 2, 'Jones', '234 First St', 'Lodi', 'CA', 'ATT', 30, 1, 180, 6);
 
 INSERT INTO customerStocks
 VALUES(4, 3, 'Jones', '234 First St', 'Lodi', 'CA', 'GM', 50, 1.25, 1000, 20);
 
 INSERT INTO customerStocks
 VALUES(4, 4, 'Jones', '234 First St', 'Lodi', 'CA', 'IBM', 100, 2.25, 1000, 10);
 
 
 SELECT *
 FROM customerStocks;