TEST-A3, Sql Server

TEST-A3

Create table STUDENT(USN int primary key ,Sname varchar(20) NOT NULL ,Address varchar(50) ,Phone int ,Gender varchar(10));
Create table SEMSEC(SSID int primary key ,Sem int , Sec varchar(10));
Create table CLASS(USN int , SSID int , foreign key(USN) references STUDENT(USN),foreign key(SSID) references SEMSEC(SSID));
Create table SUBJECT(Subcode varchar(10) primary key ,Title varchar(30) ,Sem int , Credits int ,SSID int ,foreign key(SSID) references SEMSEC(SSID));
insert into Student(USN,Sname,Address,Phone,Gender) values(1,'Anubhav','abc',750011,'Male'),(2,'Anupam','abcd',751111,'Male'),(3,'Adnan','ab',751011,'Male'),(4,'Anush','abcde',75011,'Male'),(5,'Dhanush','abce',750111,'Male');
Select * from student;
insert into SEMSEC(SSID,Sem,Sec) values (200,4,'A'),(201,3,'B'),(202,4,'C'),(203,4,'C'),(204,3,'C');
Select * from SEMSEC;
insert into CLASS(USN,SSID) values(2,201),(1,200),(3,201),(4,204),(5,203);
Select * from CLASS;
insert into SUBJECT(Subcode,Title,Sem,Credits,SSID) values ('DD','Digital Design',4,4,200),('DS','Data Structures',3,4,201),('OOPS','Object Oriented Programming',4,5,202),('DBMS','Database management',4,5,203),('GT','Graph Theory',3,3,204);
Select * from SUBJECT;
Select S.USN,S.Sname,S.Address,S.Phone,S.Gender from STUDENT as S, SEMSEC as SE, CLASS as C where S.USN=C.USN and C.SSID=SE.SSID and SE.Sem=4 and SE.Sec='C';


run \| edit \| history \| help	0