SQLize Online / PHPize Online  /  SQLtest Online

/*create table*/ CREATE TABLE student( studID varchar (11), studLname varchar (15), studFname varchar (15), primary key (studID)); CREATE TABLE class( classcode varchar (8), className varchar(45), classUnits int, primary key (classcode)); CREATE TABLE enrollment( enrollmentcode varchar (10), studID varchar (11), classcode varchar (8), grades decimal (2,1), primary key (enrollmentcode), foreign key (studID) references student(studID), foreign key (classcode) references class(classcode)); /*Adding data to tables*/ INSERT INTO student VALUES ('2019-0001A', 'Cruz', 'Juan'); INSERT INTO student VALUES ('2020-0001A', 'Cortez', 'Salvacion'); INSERT INTO student VALUES ('2020-0002A', 'Santos', 'Joselito'); INSERT INTO student VALUES ('2019-0002A', 'Alayon', 'Kristina'); INSERT INTO student VALUES ('2018-2001A', 'Pastol', 'Antonio'); INSERT INTO class VALUES ('ICT 109', 'Information Management', '3'); INSERT INTO class VALUES ('ICT 102', 'Introduction to Computing', '3'); INSERT INTO class VALUES ('CS 1', 'Programming', '3'); INSERT INTO class VALUES ('ICT 126', 'Multimedia Programming', '3'); INSERT INTO class VALUES ('ICT 104', 'Intermediate Programming', '3'); INSERT INTO enrollment VALUES ('2018-0001', '2018-2001A', 'ICT 102', '1.2'); INSERT INTO enrollment VALUES ('2018-1025', '2018-2001A', 'CS 1', '1.5'); INSERT INTO enrollment VALUES ('2019-1121', '2018-2001A', 'ICT 104', '1.5'); INSERT INTO enrollment VALUES ('2020-1022', '2018-2001A', 'ICT 109', '1.4'); INSERT INTO enrollment VALUES ('2019-0021', '2019-0001A', 'ICT 102', '1.4'); INSERT INTO enrollment VALUES ('2019-1027', '2019-0001A', 'CS 1', '1.7'); INSERT INTO enrollment VALUES ('2020-1228', '2019-0002A', 'ICT 104', '1.6'); INSERT INTO enrollment VALUES ('2019-0001', '2019-0002A', 'ICT 102', '1.6'); INSERT INTO enrollment VALUES ('2019-4025', '2019-0002A', 'CS 1', '1.9'); INSERT INTO enrollment VALUES ('2020-1324', '2019-0002A', 'ICT 104', '1.8'); INSERT INTO enrollment VALUES ('2020-0501', '2020-0001A', 'ICT 102', '1.1'); INSERT INTO enrollment VALUES ('2020-1345', '2020-0001A', 'CS 1', '1.3'); /*save changes to the work*/ commit;