Notes

CREATE table strings
(
STID integer(4),
PID integer(4) references product(PID),
Year integer(4),
Pickup char(15),
Wood char(15),
No_of_Strings integer(2),
primary key(STID, PID)
);


CREATE table wind
(
WID integer(4),
PID integer(4) references product(PID),
Year integer(4),
Material char(15),
primary key(WID, PID)
);


CREATE table percussion
(
PEID integer(4),
PID integer(4) references product(PID),
Year integer(4),
Skin char(15),
no_cymbals integer(3),
cymbals char(15),
piece integer(2),
primary key(PEID, PID)
);

CREATE table Accessories
(
AID integer(4),
PID integer(4) references product(PID),
Add_info char(50),
primary key(AID,PID)
);


insert into product values(1001,'Guitar','Fender','Telecaster',80000);
insert into product values(1101,'Bass','ESP','F-104',75000);
insert into product values(1201,'Cello','Fender','Telecaster',80000);
insert into product values(1301,'Piano','Stuart and sons','T50',150000);
insert into product values(1401,'Ukelele','Mahalo','MK1 Tabiro',20000);

insert into product values(2001,'Flute','Jean-Paul','F-N220',50000);
insert into product values(2101,'Saxophone','Yamaha','YAS52',60000);
insert into product values(2201,'Clarinet','Yamaha','C210',14600);

insert into product values(3001,'Drums','Pearl','Road Show 1000',250000);
insert into product values(3101,'Cajon','Pearl','PB57',30000);
insert into product values(3201,'Djembe','-','-',15000);

insert into product values(4001,'Bow','Arbor','Hanks 21-32',10000);
insert into product values(4101,'Guitar Picks','Dunlop','0.5"',500);
insert into product values(4201,'Amplifier','Laney','G210',50000);
insert into product values(4301,'Drum Sticks','RegalTip','111NT',7000);



insert into strings values(100,1001,2012,'F Single-Coil','Maple',6,'Electric');
insert into strings values(200,1101,2014,'ESP Humbucle','Maple',5,'Electric');
insert into strings values(300,1201,1998,'-','Maple',4,'Acoustic');
insert into strings values(400,1301,2018,'-','Spruce',78,'Electric');
insert into strings values(500,1401,2000,'-','Maple',4,'Acoustic');

insert into wind values(100,2001, 2012, 'Rosewood');
insert into wind values(200,2101, 1970, 'Brass');
insert into wind values(300,2201, 2011, 'Afr-Hardwood');

insert into percussion values(100,3001, 2012, 'Remo', 3,'Sabian/Paiste', 7);
insert into percussion values(200,3101, 2017, '-', 0,'-', 1);
insert into percussion values(300,3201, 1979, 'Goat-skin',0,'-', 1);

insert into Accessories values(100,4001,'Horse hair, 24"-32",Maplewood');
insert into Accessories values(200,4101,'0.25mm-1mm, Jazz picks');
insert into Accessories values(300,4201,'40W,21x22x10inch,2input,Overdrive');
insert into Accessories values(400,4301,'Length:15.5, Diameter:0.523,Birch');