B5gbxZiU

1CREATE DATABASE IF NOT EXISTS sekolah;
2USE sekolah;
3CREATE TABLE IF NOT EXISTS siswa(
4    nim INT PRIMARY KEY,
5    nama CHAR(40)
6);
7
8CREATE TABLE IF NOT EXISTS dosen(
9    nid INT PRIMARY KEY,
10    nama char(40)
11);
12
13CREATE TABLE IF NOT EXISTS jadwal(
14	nim INT,
15    nid INT,
16    pelajaran CHAR(20),
17    FOREIGN KEY nim REFERENCES siswa(nim),
18    FOREIGN KEY nid REFERENCES dosen(nid)
19);
20
21INSERT IGNORE INTO siswa VALUES ('1', 'Wanandi'), ('2', 'Adi'), ('3', 'Ego');
22INSERT IGNORE INTO dosen VALUES ('1', 'DosenA'), ('2', 'DosenB'), ('3', 'DosenC');
23INSERT IGNORE INTO jadwal VALUES ('1', '2', 'Kimia'), ('2', '3', 'Fisika'), ('3', '1', 'Biologi');