search

yudisentosa / SBDProjectSchool

0 stars 0 forks source link

Table - subject_master #10

Closed yudisentosa closed 3 years ago

yudisentosa commented 3 years ago

DROP TABLE IF EXISTS subject_master; CREATE TABLE subject_master( subject_id CHAR(6) NOT NULL PRIMARY KEY ,subject_name VARCHAR(35) NOT NULL ,grade INTEGER NOT NULL ,passing_score INTEGER NOT NULL ); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIN10','Bahasa Indonesia Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIG10','Bahasa Inggris Kelas 10',10,70); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMAN10','Bahasa Mandarin Kelas 10',10,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sPKN10','Pendidikan Kewarganegaraan Kelas 10',10,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sPAK10','Pendidikan Agama Kelas 10',10,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sOLG10','Olahraga Kelas 10',10,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMDS10','Musik dan Seni Kelas 10',10,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMTK10','Matematika Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIO10','Biologi Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sKIM10','Kimia Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sFIS10','Fisika Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sEKO10','Ekonomi Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sSEJ10','Sejarah Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sGEO10','Geografi Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIN11','Bahasa Indonesia Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIG11','Bahasa Inggris Kelas 11',11,70); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMAN11','Bahasa Mandarin Kelas 11',11,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sPKN11','Pendidikan Kewarganegaraan Kelas 11',11,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sPAK11','Pendidikan Agama Kelas 11',11,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sOLG11','Olahraga Kelas 11',11,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMDS11','Musik dan Seni Kelas 11',11,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMTK11','Matematika Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIO11','Biologi Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sKIM11','Kimia Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sFIS11','Fisika Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sEKO11','Ekonomi Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sSEJ11','Sejarah Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sGEO11','Geografi Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIN12','Bahasa Indonesia Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIG12','Bahasa Inggris Kelas 12',12,70); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMAN12','Bahasa Mandarin Kelas 12',12,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sPKN12','Pendidikan Kewarganegaraan Kelas 12',12,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sPAK12','Pendidikan Agama Kelas 12',12,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sOLG12','Olahraga Kelas 12',12,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMDS12','Musik dan Seni Kelas 12',12,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sMTK12','Matematika Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sBIO12','Biologi Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sKIM12','Kimia Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sFIS12','Fisika Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sEKO12','Ekonomi Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sSEJ12','Sejarah Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sGEO12','Geografi Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sKOM10','Komputer dan Kewirausahaan Kelas 12',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sKOM11','Komputer dan Kewirausahaan Kelas 12',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('sKOM12','Komputer dan Kewirausahaan Kelas 12',12,75);

yoance commented 3 years ago

DROP TABLE IF EXISTS subject_master; CREATE TABLE subject_master( subject_id CHAR(6) NOT NULL PRIMARY KEY ,subject_name VARCHAR(35) NOT NULL ,grade INTEGER NOT NULL ,passing_score INTEGER NOT NULL ); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIN10','Bahasa Indonesia Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIG10','Bahasa Inggris Kelas 10',10,70); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MAN10','Bahasa Mandarin Kelas 10',10,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('PKN10','Pendidikan Kewarganegaraan Kelas 10',10,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('PAK10','Pendidikan Agama Kelas 10',10,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('OLG10','Olahraga Kelas 10',10,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MDS10','Musik dan Seni Kelas 10',10,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MTK10','Matematika Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIO10','Biologi Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('KIM10','Kimia Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('FIS10','Fisika Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('EKO10','Ekonomi Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('SEJ10','Sejarah Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('GEO10','Geografi Kelas 10',10,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIN11','Bahasa Indonesia Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIG11','Bahasa Inggris Kelas 11',11,70); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MAN11','Bahasa Mandarin Kelas 11',11,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('PKN11','Pendidikan Kewarganegaraan Kelas 11',11,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('PAK11','Pendidikan Agama Kelas 11',11,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('OLG11','Olahraga Kelas 11',11,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MDS11','Musik dan Seni Kelas 11',11,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MTK11','Matematika Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIO11','Biologi Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('KIM11','Kimia Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('FIS11','Fisika Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('EKO11','Ekonomi Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('SEJ11','Sejarah Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('GEO11','Geografi Kelas 11',11,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIN12','Bahasa Indonesia Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIG12','Bahasa Inggris Kelas 12',12,70); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MAN12','Bahasa Mandarin Kelas 12',12,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('PKN12','Pendidikan Kewarganegaraan Kelas 12',12,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('PAK12','Pendidikan Agama Kelas 12',12,80); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('OLG12','Olahraga Kelas 12',12,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MDS12','Musik dan Seni Kelas 12',12,65); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('MTK12','Matematika Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('BIO12','Biologi Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('KIM12','Kimia Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('FIS12','Fisika Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('EKO12','Ekonomi Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('SEJ12','Sejarah Kelas 12',12,75); INSERT INTO subject_master(subject_id,subject_name,grade,passing_score) VALUES ('GEO12','Geografi Kelas 12',12,75);