drop table printer;
drop table laptop;
drop table pc;
drop table products;


create table products(
	maker varchar(10),
	model integer,
	type varchar(10)
	);

insert into products values ('A',1001,'pc');
insert into products values ('A',1002,'pc');
insert into products values ('A',1003,'pc');
insert into products values ('A',2004,'laptop');
insert into products values ('A',2005,'laptop');
insert into products values ('A',2006,'laptop');
insert into products values ('B',1004,'pc');
insert into products values ('B',1005,'pc');
insert into products values ('B',1006,'pc');
insert into products values ('B',2007,'laptop');
insert into products values ('C',1007,'pc');
insert into products values ('D',1008,'pc');
insert into products values ('D',1009,'pc');
insert into products values ('D',1010,'pc');
insert into products values ('D',3004,'printer');
insert into products values ('D',3005,'printer');
insert into products values ('E',1011,'pc');
insert into products values ('E',1012,'pc');
insert into products values ('E',1013,'pc');
insert into products values ('E',2001,'laptop');
insert into products values ('E',2002,'laptop');
insert into products values ('E',2003,'laptop');
insert into products values ('E',3001,'printer');
insert into products values ('E',3002,'printer');
insert into products values ('E',3003,'printer');
insert into products values ('F',2008,'laptop');
insert into products values ('F',2009,'laptop');
insert into products values ('G',2010,'laptop');
insert into products values ('H',3006,'printer');
insert into products values ('H',3007,'printer');


create table pc(
	model integer,
	speed float,
	ram integer,
	hd integer,
	price integer
	);

insert into pc values (1001,2.66,1024,250,2114);
insert into pc values (1002,2.10,512,250,995);
insert into pc values (1003,1.42,512,80,478);
insert into pc values (1004,2.80,1024,250,649);
insert into pc values (1005,3.20,512,250,630);
insert into pc values (1006,3.20,1024,320,1049);
insert into pc values (1007,2.20,1024,200,510);
insert into pc values (1008,2.20,2048,250,770);
insert into pc values (1009,2.00,1024,250,650);
insert into pc values (1010,2.80,2048,300,770);
insert into pc values (1011,1.86,2048,160,959);
insert into pc values (1012,2.80,1024,160,649);
insert into pc values (1013,3.06,512,80,529);


create table laptop(
	model integer,
	speed float,
	ram integer,
	hd integer,
	screen float,
	price integer
	);

insert into laptop values (2001,2.00,2048,240,20.1,3673);
insert into laptop values (2002,1.73,1024,80,17.0,949);
insert into laptop values (2003,1.80,512,60,15.4,549);
insert into laptop values (2004,2.00,512,60,13.3,1150);
insert into laptop values (2005,2.16,1024,120,17.0,2500);
insert into laptop values (2006,2.00,2048,80,15.4,1700);
insert into laptop values (2007,1.83,1024,120,13.3,1429);
insert into laptop values (2008,1.60,1024,100,15.4,900);
insert into laptop values (2009,1.60,512,80,14.1,680);
insert into laptop values (2010,2.00,2048,160,15.4,2300);


create table printer(
	model integer,
	color varchar(5),
	type varchar(15),
	price integer);

insert into printer values (3001,'yes','ink-jet',3673);
insert into printer values (3002,'no','laser',949);
insert into printer values (3003,'yes','laser',549);
insert into printer values (3004,'yes','ink-jet',1150);
insert into printer values (3005,'no','laser',2500);
insert into printer values (3006,'yes','ink-jet',1700);
insert into printer values (3007,'yes','laser',1429);

commit; 

select * from products;
select * from pc;
select * from laptop;
select * from printer;


grant select on products to public;
grant select on pc to public;
grant select on laptop to public;
grant select on printer to public;