Program 4 (Create and Insert)

Creation of Tables

CREATE TABLE STUDENT(Usn char(10)PRIMARY KEY,Sname varchar(20),Address varchar(30),Phone int,Gender char);

CREATE TABLE SEMSEC(Ssid char(2)PRIMARY KEY,Sem int,Sec char);

CREATE TABLE CLASS(Usn char(10) PRIMARY KEY,Ssid char(2), FOREIGN KEY(Ssid)REFERENCES SEMSEC(ssid),FOREIGN KEY(Usn)REFERENCES STUDENT(Usn));

CREATE TABLE SUBJECT(Subcode varchar(10) PRIMARY KEY,Title varchar(30), Semint,Credits int);

CREATE TABLE IAMARKS(Usn char(10)REFERENCES STUDENT(Usn), Subcode varchar(10)REFERENCES SUBJECT(Subcode),Ssid char(2)REFERENCES SEMSEC(Ssid), Test1 int,Test2 int,Test3 int,FinalIA int,PRIMARY KEY(Usn,Subcode,Ssid));

Insertion of rows to the table

INSERT INTO STUDENT VALUES('&Usn', '&SName','&Address','&Phone','&Gender');

INSERT INTO SEMSEC VALUES('&SSID','&Sem','&Sec');

INSERT INTO CLASS VALUES('&Usn','&SSID');

INSERT INTO SUBJECT VALUES('&Subcode','&Title','&Sem','&Credits');

INSERT INTO IAMARKS VALUES('&Usn','&Subcode','&SSID','&Test1','&Test2','&Test3',NULL);