dml.sql

-- Insert values into STUDENT table
INSERT INTO STUDENT VALUES ('lcg15cs001', 'Abhi', 'tumkur', '9875698410', 'M');
INSERT INTO STUDENT VALUES ('lcg15cs002', 'Amulya', 'Gubbi', '8896557412', 'F');
INSERT INTO STUDENT VALUES ('lcg16me063', 'Chethan', 'Nitur', '7894759522', 'M');
INSERT INTO STUDENT VALUES ('lcg14ec055', 'Raghavi', 'Sspuram', '9485675521', 'F');
INSERT INTO STUDENT VALUES ('lcg15ee065', 'Sanjay', 'Bangalore', '9538444404', 'M');

-- Insert values into SEMSEC table
INSERT INTO SEMSEC VALUES ('5A', 5, 'A');
INSERT INTO SEMSEC VALUES ('3B', 3, 'B');
INSERT INTO SEMSEC VALUES ('7A', 7, 'A');
INSERT INTO SEMSEC VALUES ('2C', 2, 'C');
INSERT INTO SEMSEC VALUES ('4B', 4, 'B');
INSERT INTO SEMSEC VALUES ('4C', 4, 'C');

-- Insert values into CLASS table
INSERT INTO CLASS VALUES ('lcg15cs001', '5A');
INSERT INTO CLASS VALUES ('lcg15cs002', '5A');
INSERT INTO CLASS VALUES ('lcg16me063', '3B');
INSERT INTO CLASS VALUES ('lcg14ec055', '7A');
INSERT INTO CLASS VALUES ('lcg15ee065', '3B');
INSERT INTO CLASS VALUES ('lcg15ee065', '4C');
INSERT INTO CLASS VALUES ('lcg15cs002', '4C');

-- Insert values into SUBJECT table
INSERT INTO SUBJECT VALUES ('10CS81', 'ACA', 8, 4);
INSERT INTO SUBJECT VALUES ('15cs53', 'Dbms', 5, 4);
INSERT INTO SUBJECT VALUES ('15cs33', 'ds', 3, 4);
INSERT INTO SUBJECT VALUES ('15cs34', 'Co', 3, 4);
INSERT INTO SUBJECT VALUES ('15cs158', 'Dba', 5, 2);
INSERT INTO SUBJECT VALUES ('10cs71', 'Oomd', 7, 4);

-- Insert values into IAMARKS table
INSERT INTO IAMARKS VALUES ('lcg15cs001', '15cs53', '5A', 18, 19, 15, NULL);
INSERT INTO IAMARKS VALUES ('lcg15cs002', '15cs53', '5A', 15, 16, 14, NULL);
INSERT INTO IAMARKS VALUES ('lcg16me063', '15cs33', '3B', 10, 15, 16, NULL);
INSERT INTO IAMARKS VALUES ('lcg14ec055', '10cs71', '7A', 18, 20, 21, NULL);
INSERT INTO IAMARKS VALUES ('lcg15ee065', '15cs33', '3B', 16, 20, 17, NULL);
INSERT INTO IAMARKS VALUES ('lcg15ee065', '15cs53', '4C', 19, 20, 18, NULL);