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) 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 in 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) Student and 

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

 

Insert valuse in 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 relation

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

Insrt values in stdtech

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 ); 

isert 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 );