Andre Long
					cisa 321 SQL
					November 16, 2004
					Quiz2


//first make tables

drop table customer;

create table customer
( 
   Cust_ID          number(3),
   Name              varchar2(30),
   Addr                varchar2(35),
   City                 varchar2(40),
   State               varchar2(45),
   Zip                  varchar2(5)
);


drop table stocktable;

create table stocktable
(
   Stock_Name          varchar2(30),
   Price                      number(5,2),
   Div                         number(5,2),
   Shares                   number(6,0),
   Value                     number(6,2)
);


drop table customer_stock_relation;

create table customer_stock_relation
(
   Cust_ID          number(3),
   Name              varchar2(30),
   Stock_Name   varchar2(30)
);     

// put data into tables

insert into customer    values
( 3, 'Lee', '123 Main', 'Ann Arbor', 'MI', '48109' );

insert into customer    values
(4, 'Jones', '234 Ann', 'Ann Arbor', 'MI' , '48104');

insert into customer    values
(4, 'Jones', '234 Ann', 'Ann Arbor', 'MI', '48103');

insert into stocktable values
('IBM', 100, 2.25, 20, 2000);

insert into stocktable values
('ATT', 30, 1, 6, 180);

insert into stocktable values
('GM', 50, 1.25, 20, 1000);

insert into stocktable values
('IBM', 100, 2.25, 10, 1000);

insert into customer_stock_relation values
(3, 'Lee', 'IBM');

insert into customer_stock_relation values
(4, 'Jones', 'ATT');

insert into customer_stock_relation values
(4, 'Jones', 'GM');
									a