repert, Sql Server

repert

create table travel
(
    eid int primary key,
    ph_no int,
    address varchar(20)
    )

create table travelers 
    (
        eno int primary key,
        gender varchar(2),
        age int
        )
create table manages
(
    eid int foreign key references travel(eid) on delete cascade on update cascade,
    eno int foreign key references travelers(eno) on delete cascade on update cascade
    )
   
   create table Nepalese_community 
   (
       nid int primary key,
       location varchar (30)
       )
       
       create table visiting
       (
           eno int foreign key references travelers(eno) on delete cascade on update cascade,
           nid int foreign key references nepalese_community(nid) on delete cascade on update cascade
           )
           
           create table agencies 
           (
               aid int primary key,
               contact_no int
               )
          
          create table contacts_to
          (
              aid int foreign key references agencies(aid) on delete cascade on update cascade,
              nid int foreign key references Nepalese_community(nid) on delete cascade on update cascade
              )
               
           insert into travel (eid, ph_no, address) values(1, 555555,'kalanki');
           insert into travel (eid, ph_no, address) values(2, 566665,'kalimti');
           insert into travel (eid, ph_no, address) values(3, 777775,'teku');
           insert into travel (eid, ph_no, address) values(4, 888885,'pokhara');
           insert into travel (eid, ph_no, address) values(6, 999995,'koteshwor');
           insert into travel (eid, ph_no, address) values(7, 533335,'nakhu');
           insert into travel (eid, ph_no, address) values(8, 444455,'bhanimandal');
           insert into travel (eid, ph_no, address) values(9, 511211,'satungal');
           insert into travel (eid, ph_no, address) values(10, 550005,'thankot');
           insert into travel (eid, ph_no, address) values(11, 533355,'sanepa');
           insert into travel (eid, ph_no, address) values(12, 555855,'sinamngal');
           insert into travel (eid, ph_no, address) values(13, 515555,'baneshwor');
           insert into travel (eid, ph_no, address) values(14, 523555,'tripureshwor');
           insert into travel (eid, ph_no, address) values(15, 895555,'balkhu');
           insert into travel (eid, ph_no, address) values(16, 555555,'ekantakuna');
           insert into travel (eid, ph_no, address) values(17, 355555,'patan');
           insert into travel (eid, ph_no, address) values(18, 855555,'tinkuney');
           insert into travel (eid, ph_no, address) values(19, 455555,'tokha');
           insert into travel (eid, ph_no, address) values(20, 558955,'jhor');
           
           insert into travelers(eno, gender, age) values(21, 'M',13)
           insert into travelers(eno, gender, age) values(22, 'F',12)
           insert into travelers(eno, gender, age) values(23, 'M',14)
           insert into travelers(eno, gender, age) values(24, 'M',19)
           insert into travelers(eno, gender, age) values(25, 'F',10)
           insert into travelers(eno, gender, age) values(26, 'F',15)
           insert into travelers(eno, gender, age) values(27, 'M',13)
           insert into travelers(eno, gender, age) values(28, 'M',19)
           insert into travelers(eno, gender, age) values(29, 'F',14)
           insert into travelers(eno, gender, age) values(30, 'M',11)
           insert into travelers(eno, gender, age) values(31, 'M',13)
           insert into travelers(eno, gender, age) values(32, 'F',15)
           insert into travelers(eno, gender, age) values(33, 'M',23)
           insert into travelers(eno, gender, age) values(34, 'M',20)
           insert into travelers(eno, gender, age) values(35, 'M',30)
           insert into travelers(eno, gender, age) values(36, 'F',31)
           insert into travelers(eno, gender, age) values(37, 'M',43)
           insert into travelers(eno, gender, age) values(38, 'F',23)
           insert into travelers(eno, gender, age) values(39, 'F',33)
           insert into travelers(eno, gender, age) values(40, 'M',22)
           
          insert into manages(eid, eno) values(1,21);
          insert into manages(eid, eno) values(2,22);
          insert into manages(eid, eno) values(3,23);
          insert into manages(eid, eno) values(4,24);
          insert into manages(eid, eno) values(6,25);
          insert into manages(eid, eno) values(7,26);
          insert into manages(eid, eno) values(8,27);
          insert into manages(eid, eno) values(9,28);
          insert into manages(eid, eno) values(10,29);
          insert into manages(eid, eno) values(12,30);
          insert into manages(eid, eno) values(12,31);
          insert into manages(eid, eno) values(13,32);
          insert into manages(eid, eno) values(14,33);
          insert into manages(eid, eno) values(15,34);
          insert into manages(eid, eno) values(16,35);
          insert into manages(eid, eno) values(17,36);
          insert into manages(eid, eno) values(18,37);
          insert into manages(eid, eno) values(19,38);
          insert into manages(eid, eno) values(20,39);
          insert into manages(eid, eno) values(20,40);
          
          
          insert into Nepalese_community(nid,location)values(50,'kathmandu')
          insert into Nepalese_community(nid,location)values(51,'Pokhara')
          insert into Nepalese_community(nid,location)values(52,'Chitwan')
          insert into Nepalese_community(nid,location)values(53,'Pharping')
          insert into Nepalese_community(nid,location)values(54,'Nagarkot')
          insert into Nepalese_community(nid,location)values(55,'kulekhani')
          insert into Nepalese_community(nid,location)values(56,'Butwal')
          insert into Nepalese_community(nid,location)values(57,'lumbini')
          insert into Nepalese_community(nid,location)values(58,'bhairawa')
          insert into Nepalese_community(nid,location)values(59,'kanchanpur')
          insert into Nepalese_community(nid,location)values(60,'khotang')
          insert into Nepalese_community(nid,location)values(61,'dang')
          insert into Nepalese_community(nid,location)values(62,'kashi')
          insert into Nepalese_community(nid,location)values(63,'kailali')
          insert into Nepalese_community(nid,location)values(64,'mustang')
          insert into Nepalese_community(nid,location)values(65,'manag')
          insert into Nepalese_community(nid,location)values(66,'jhor')
          insert into Nepalese_community(nid,location)values(67,'bhaktapur')
          insert into Nepalese_community(nid,location)values(68,'patan')
           insert into Nepalese_community(nid,location)values(69,'changunarayan')
            insert into Nepalese_community(nid,location)values(70,'kalanki')


run \| edit \| history \| help	0