tw4
*-------------------TW4-----------------------------* CREATE TABLE STUDENT( USN VARCHAR (10) PRIMARY KEY, SNAME VARCHAR(25), ADDRESS VARCHAR(25), PHONE BIGINT(10), GENDER CHAR(1)); CREATE TABLE SEMSEC( SSID VARCHAR(5) PRIMARY KEY, SEM INT (5), SEC CHAR (1)); CREATE TABLE CLASS( USN VARCHAR (10), SSID VARCHAR (5), PRIMARY KEY(USN, SSID), FOREIGN KEY(USN) REFERENCES STUDENT(USN), FOREIGN KEY(SSID) REFERENCES SEMSEC(SSID)); CREATE TABLE SUBJECT( SUBCODE VARCHAR(10) PRIMARY KEY, TITLE VARCHAR(5), SEM INT, CREDITS INT); CREATE TABLE IAMARKS ( USN VARCHAR(10), SUBCODE VARCHAR(6), SSID VARCHAR(5), TEST1 INT(2), TEST2 INT(2), TEST3 INT(2), FINALIA INT(3), PRIMARY KEY(USN, SUBCODE, SSID), FOREIGN KEY(USN) REFERENCES STUDENT(USN), FOREIGN KEY(SUBCODE) REFERENCES SUBJECT(SUBCODE), FOREIGN KEY(SSID) REFERENCES SEMSEC(SSID)); INSERT INTO STUDENT VALUES('2KL20CS400','ADINATH','BELAGAVI',9821456230,'M'); INSERT INTO STUDENT VALUES(...
