CREATE DATABASE SEKOLAH;

CREATE TABLE Guru (
    NIP CHAR(4) PRIMARY KEY,
    NamaGuru VARCHAR(50),
    MataPelajaran VARCHAR(30),
    NoHP VARCHAR(15)
);

CREATE TABLE Kelas (
    Kelas CHAR(3) PRIMARY KEY,
    Walikelas VARCHAR(50),
    Ruangan CHAR(4),
    NIPGuru CHAR(4),
    CONSTRAINT FK_Kelas_Guru FOREIGN KEY (NIPGuru)
        REFERENCES Guru(NIP)
);

CREATE TABLE Siswa (
    NIS CHAR(4) PRIMARY KEY,
    NamaSiswa VARCHAR(50),
    Kelas CHAR(3),
    JenisKelamin CHAR(1),
    CONSTRAINT FK_Siswa_Kelas FOREIGN KEY (Kelas)
        REFERENCES Kelas(Kelas)
);