Closed yoance closed 3 years ago
DROP TABLE IF EXISTS class;
CREATE TABLE class( class_id VARCHAR(7) NOT NULL PRIMARY KEY, class_name VARCHAR(12) NOT NULL, grade INTEGER NOT NULL ); INSERT INTO class(class_id,class_name,grade) VALUES ('10IPA1','Kelas 10 IPA',10); INSERT INTO class(class_id,class_name,grade) VALUES ('10IPS1','Kelas 10 IPS',10); INSERT INTO class(class_id,class_name,grade) VALUES ('11IPA1','Kelas 11 IPA',11); INSERT INTO class(class_id,class_name,grade) VALUES ('11IPS1','Kelas 11 IPS',11); INSERT INTO class(class_id,class_name,grade) VALUES ('12IPA1','Kelas 12 IPA',12); INSERT INTO class(class_id,class_name,grade) VALUES ('12IPS1','Kelas 12 IPS',12);
DROP TABLE IF EXISTS class;
CREATE TABLE class( class_id VARCHAR(7) NOT NULL PRIMARY KEY, class_name VARCHAR(12) NOT NULL, grade INTEGER NOT NULL ); INSERT INTO class(class_id,class_name,grade) VALUES ('10IPA1','Kelas 10 IPA',10); INSERT INTO class(class_id,class_name,grade) VALUES ('10IPS1','Kelas 10 IPS',10); INSERT INTO class(class_id,class_name,grade) VALUES ('11IPA1','Kelas 11 IPA',11); INSERT INTO class(class_id,class_name,grade) VALUES ('11IPS1','Kelas 11 IPS',11); INSERT INTO class(class_id,class_name,grade) VALUES ('12IPA1','Kelas 12 IPA',12); INSERT INTO class(class_id,class_name,grade) VALUES ('12IPS1','Kelas 12 IPS',12);