fMgsFT2Z

1DROP DATABASE IF EXISTS asrama;
2CREATE DATABASE IF NOT EXISTS asrama;
3USE asrama;
4
5CREATE TABLE IF NOT EXISTS anak (
6    id INT PRIMARY KEY AUTO_INCREMENT,
7    nama CHAR(40) NOT NULL,
8    jk CHAR(1) NOT NULL,
9    umur INT NOT NULL
10);
11
12CREATE TABLE IF NOT EXISTS sekolah (
13    id INT PRIMARY KEY AUTO_INCREMENT,
14    nama CHAR(40) NOT NULL,
15    tipe CHAR(6) NOT NULL
16);
17
18CREATE TABLE IF NOT EXISTS asosiasi_sekolah (
19    id INT PRIMARY KEY AUTO_INCREMENT,
20    id_anak INT NOT NULL,
21    id_sekolah INT NOT NULL,
22    tahun_mulai INT,
23    FOREIGN KEY (id_anak) REFERENCES anak(id),
24    FOREIGN KEY (id_sekolah) REFERENCES sekolah(id)
25);