Notes

drop table event cascade constraints;

create table event(
event_id varchar2(5) primary key,
event_name varchar2(20)

);

insert into event values('E1','Winter Party');
insert into event values('E2','Summer Party');
insert into event values('E3','Christmas eve');
insert into event values('E4','New years eve');
insert into event values('E5','Farewell Party');
insert into event values('E6','Welcome Party');
insert into event values('E7','DJ Party');
insert into event values('E8','Food fiesta');
insert into event values('E9','Regon Party');
insert into event values('E10','Fells Party');
insert into event values('E11','Twelve Noon');
insert into event values('E12','Raindrop Party');
insert into event values('E13','Bhotey Party');
insert into event values('E14','Snow Party');
insert into event values('E15','Reggie Party');




drop table staff cascade constraints;

create table staff(
staff_id varchar2(5) primary key,
staff_name varchar2(20)

);

insert into staff values ('S1','Alex');
insert into staff values ('S2','Angel');
insert into staff values ('S3','Biplove');
insert into staff values ('S4','Solar');
insert into staff values ('S5','Shuva');
insert into staff values ('S6','Shivesh');
insert into staff values ('S7','Pramosh');
insert into staff values ('S8','Sahil');
insert into staff values ('S9','Jenish');
insert into staff values ('S10','Pukar');
insert into staff values ('S11','Rojina');
insert into staff values ('S12','Sagarika');
insert into staff values ('S13','Sandesh');
insert into staff values ('S14','Annie');
insert into staff values ('S15','Rujal');

drop table stage cascade constraints;



drop table venue cascade constraints;
create table venue(
venue_id varchar2(5) primary key,
venue_name varchar2(20),
hire_price number(20,0),
venue_date date,
location varchar2(20),
venue_size varchar2(20),
event_id varchar2(5) references event(event_id),
staff_id varchar2(5) references staff(staff_id)
);

insert into venue values ('V1','Quicken Loans Arena','100000','12/1/18','Cleveland','300','E1','S1');
insert into venue values ('V2','Loans Arena','200000','12/2/18','San Antonio','200','E2','S2');
insert into venue values ('V3','Quicken Arena','300000','2/12/18','San Fransisco','100','E3','S3');
insert into venue values ('V4','Gilbert Arena','400000','1/12/18','Boston','400','E4','S4');
insert into venue values ('V5','Oracle Arena','500000','12/3/18','Phoneix','500','E5','S5');
insert into venue values ('V6','TD Arena','600000','12/4/18','Minnesota','600','E6','S6');
insert into venue values ('V7','NSC Arena','700000','12/12/17','Dallas','700','E7','S7');
insert into venue values ('V8','Bisec Arena','800000','12/12/16','Houston','800','E8','S8');
insert into venue values ('V9','Troll Arena','900000','12/12/12','Brooklyn','900','E9','S9');
insert into venue values ('V10','Q Arena','1000000','3/12/16','Toronto','150','E10','S10');
insert into venue values ('V11','L Loans Arena','1100000','1/1/18','Ontario','350','E11','S11');
insert into venue values ('V12','Dry Arena','1200000','2/2/18','Washington','230','E12','S12');
insert into venue values ('V13','Racin Arena','1300000','2/12/17','Phila','330','E13','S13');
insert into venue values ('V14','Vin Loans Arena','1400000','12/1/12','London','360','E14','S14');
insert into venue values ('V15','Ariza Arena','1500000','12/11/17','Berlin','390','E15','S15');

















drop table festival cascade constraints;
create table festival(
festival_id varchar2(5) primary key,
festival_name varchar2(20),
venue_id varchar2(5) references venue(venue_id),
staff_id varchar2(5) references staff (staff_id)

);


insert into festival values ('F1','Christmas','V1','S1');
insert into festival values ('F2','Dashain','V2','S2');
insert into festival values ('F3','Tihar','V3','S3');
insert into festival values ('F4','Id','V4','S4');
insert into festival values ('F5','Haloween','V5','S5');
insert into festival values ('F6','Raamjaan','V6','S6');
insert into festival values ('F7','Rajja','V7','S7');
insert into festival values ('F8','Doris','V8','S8');
insert into festival values ('F9','Nandey','V9','S9');
insert into festival values ('F10','Ciros','V10','S10');
insert into festival values ('F11','Crimson','V11','S11');
insert into festival values ('F12','Allah','V12','S12');
insert into festival values ('F13','Region','V13','S13');
insert into festival values ('F14','Solar','V14','S14');
insert into festival values ('F15','Jannat','V15','S15');



drop table agent cascade constraints;
create table agent(
agent_id varchar2(5) primary key,
agent_name varchar2(20),
agent_contact varchar2(20)
);

insert into agent values ('A1','Martin','9842387654');
insert into agent values ('A2','Ankit','9845987654');
insert into agent values ('A3','Marin','9843977654');
insert into agent values ('A4','Natin','9843987954');
insert into agent values ('A5','Rosy','9843987650');
insert into agent values ('A6','Alex','9843987651');
insert into agent values ('A7','Solar','9843987652');
insert into agent values ('A8','Pramosh','9843987653');
insert into agent values ('A9','Sahil','9843987644');
insert into agent values ('A10','Jenish','9843987655');
insert into agent values ('A11','Pukar','9843987656');
insert into agent values ('A12','Saugat','9843987657');
insert into agent values ('A13','Shuva','9843987658');
insert into agent values ('A14','Shivesh','9843987659');
insert into agent values ('A15','Rabin','9843987254');

drop table organizer cascade constraints;

create table organizer(
organizer_id varchar2(5) primary key,
organizer_contact varchar2(20),
oranizer_name varchar2(20),
agent_id varchar2(5) references agent(agent_id),
festival_id varchar2(5) references festival(festival_id)
);

insert into organizer values ('O1','9823353127','CC Entertainment','A1','F1');
insert into organizer values ('O2','9824353127','AG records','A2','F2');
insert into organizer values ('O3','9825353127','ARI Entertainment','A3','F3');
insert into organizer values ('O4','9826353127','CC records','A4','F4');
insert into organizer values ('O5','9827353127','Drop Entertainment','A5','F5');
insert into organizer values ('O6','9828353127','CRF Entertainment','A6','F6');
insert into organizer values ('O7','9829353127','Rolas','A7','F7');
insert into organizer values ('O8','9820353127','Bhotey Entertainment','A8','F8');
insert into organizer values ('O9','98231353127','Chammu Entertainment','A9','F9');
insert into organizer values ('O10','9823333127','Rolex Entertainment','A10','F10');
insert into organizer values ('O11','9823353127','DC records','A11','F11');
insert into organizer values ('O12','9823673127','Burjs station','A12','F12');
insert into organizer values ('O13','9823783127','Niva aspiration','A13','F13');
insert into organizer values ('O14','9823353927','Rezzy records','A14','F14');
insert into organizer values ('O15','9854353927','Olay records','A15','F15');


create table stage(
stage_id varchar2(5) primary key,
stage_location varchar2(20),

staff_id varchar2(5) references staff(staff_id),
equipment_id varchar2(5) references equipment(equipment_id)
);

insert into stage values ('St1','Cape town','S1','Eq1');
insert into stage values ('St2','Brooklyn','S2','Eq2');
insert into stage values ('St3','London','S3','Eq3');
insert into stage values ('St4','San fransisco','S4','Eq4');
insert into stage values ('St5','Thamel','S5','Eq5');
insert into stage values ('St6','Pokhara','S6','Eq6');
insert into stage values ('St7','Cairo','S7','Eq7');
insert into stage values ('St8','Los angeles','S8','Eq8');
insert into stage values ('St9','Phoenix','S9','Eq9');
insert into stage values ('St10','Toronto','S10','Eq10');
insert into stage values ('St11','Biratnagar','S11','Eq11');
insert into stage values ('St12','Mumbai','S12','Eq12');
insert into stage values ('St13','Delhi','S13','Eq13');
insert into stage values ('St14','Sikkim','S14','Eq14');
insert into stage values ('St15','Darjeeling','S15','Eq15');





drop table equipment cascade constraints;

create table equipment (
equipment_id varchar2(5) primary key,
equipment_name varchar2(20)
);

insert into equipment values ('Eq1','Guitar');
insert into equipment values ('Eq2','Drum');
insert into equipment values ('Eq3','Cagon');
insert into equipment values ('Eq4','Ukelele');
insert into equipment values ('Eq5','Sitar');
insert into equipment values ('Eq6','Piano');
insert into equipment values ('Eq7','Harmonium');
insert into equipment values ('Eq8','Broom');
insert into equipment values ('Eq9','Speaker');
insert into equipment values ('Eq10','DJ kit');
insert into equipment values ('Eq11','Water');
insert into equipment values ('Eq12','Mike');
insert into equipment values ('Eq13','Star');
insert into equipment values ('Eq14','Gijon');
insert into equipment values ('Eq15','Madal');