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