Create table Student and Teacher are related with many to many relationship

Create table Student and Teacher  are related with many to many relationship 






Consider the following database

 Student (Roll_No int, Sname varchar (20), Sclass char (10)) 

Teacher (T_No int, Tname char (20), Experience int) 

The Student and Teacher are related with many to many relationship with the descriptive attribute Subject.




Create table Student

Student (Roll_No int, Sname varchar (20), Sclass char (10)) 


Create table Student (rollno int primary key , name varchar(30),class varchar(10));


Insert values Student table


insert into Student  values ( 1,' AAAA','fy-bcs');

insert into Student  values ( 2,' BBBB','sy-bca');

insert into Student  values ( 3,' CCCC','ty-bcs');

insert into Student  values ( 4,' DDDD','sy-bcs');

insert into Student  values ( 5,' EEEE','ty-bca');



create table Teacher 


Teacher (T_No int, Tname char (20), Experience int) 


create table Teacher (tno int primary key, tname char (20), Expe int);


Insert values Teacher table


insert into Teacher values ( 1,' aa',15 );

insert into Teacher values ( 2,' bb',19 );

insert into Teacher values ( 3,' cc', 16);

insert into Teacher values ( 4,' dd',12 );

insert into Teacher values ( 5,' ee', 10);



create table stdteach are related with M-M realtion 


create table stdteach ( rollno int references student (rollno),tno int references Teacher (tno));


Insert values in stdteach table 


insert into stdteach values (1,1  ); 

insert into stdteach values (  1 , 2 ); 

insert into stdteach values (  1 , 3 ); 

insert into stdteach values (  1 , 4 ); 

insert into stdteach values (  1 , 5 ); 

insert into stdteach values (  2 , 1 ); 

insert into stdteach values (  2 , 3 ); 

insert into stdteach values (  2 , 4 ); 

insert into stdteach values (  2 , 5 ); 

insert into stdteach values (  3 , 1 ); 

insert into stdteach values (  3 , 2 ); 

insert into stdteach values (  3 , 4 ); 

insert into stdteach values (  3 , 5 ); 

insert into stdteach values (  4 , 1 ); 

insert into stdteach values (  4 , 2 ); 

insert into stdteach values (  4 , 3 ); 

insert into stdteach values (  4 , 5 ); 

insert into stdteach values (  5 , 1 ); 

insert into stdteach values (  5 , 2 ); 

insert into stdteach values (  5 , 3 ); 

insert into stdteach values (  5 , 4 ); 


Post a Comment

0 Comments