Create Table Student and Subject are related with :M-M relationship

Create Table Student  and Subject  are  related with :M-M relationship

Consider the following Student-Subject database 

Student (rollno integer, name varchar(30),city varchar(50),class varchar(10)) 

Subject (scode varchar(10),subject_name varchar(20)) Student-

Subject :M
-M relationship with descriptive attribute marks_scored. 

Create table Student

Student (rollno integer, name varchar(30),city varchar(50),class varchar(10)) 

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

Insert values in Student Table

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

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

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

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

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

Create table Subject

Subject (scode varchar(10),subject_name varchar(20)) 

create table Subject (sno int primary key ,subject_name varchar(20));

Insert values in subject Table

insert into Subject values ( 1,' aa' );

insert into Subject values ( 2,' bb' );

insert into Subject values ( 3,' cc' );

insert into Subject values ( 4,' dd' );

insert into Subject values ( 5,' ee' );

Create table stdsub are related with M-M relation

create table stdsub ( sno int references subject (sno),rollno int references student (rollno));

Insert values in Stdsub Table

insert into stdsub values (1,1  ); 

insert into stdsub values (  1 , 2 ); 

insert into stdsub values (  1 , 3 ); 

insert into stdsub values (  1 , 4 ); 

insert into stdsub values (  1 , 5 ); 

insert into stdsub values (  2 , 1 ); 

insert into stdsub values (  2 , 3 ); 

insert into stdsub values (  2 , 4 ); 

insert into stdsub values (  2 , 5 ); 

insert into stdsub values (  3 , 1 ); 

insert into stdsub values (  3 , 2 ); 

insert into stdsub values (  3 , 4 ); 

insert into stdsub values (  3 , 5 ); 

insert into stdsub values (  4 , 1 ); 

insert into stdsub values (  4 , 2 ); 

insert into stdsub values (  4 , 3 ); 

insert into stdsub values (  4 , 5 ); 

insert into stdsub values (  5 , 1 ); 

insert into stdsub values (  5 , 2 ); 

insert into stdsub values (  5 , 3 ); 

insert into stdsub values (  5 , 4 );