LEARNING DATABASE (SQLSERVER QUERY) PART.1

Cases:
1. Create Database "nilaiSiswa"
2. The tables are table "siswa", "matkul", "nilai".
3. The fields of table "siswa" are "nim", "namaDepan", "namaBelakang", "alamatSiswa", "tanggalLahir".
4. The fields of table matkul are "kodeMatkul", "namaMatkul", "sks".
5. The fields of table nilai are "idNilai" [auto increment], "nim", "kodeMatkul", "uts", "uas".

1. Create Database "nilaiSiswa"
     USE master;
     CREATE database nilaiSiswa;

2. Create Table "siswa"
     USE nilaiSiswa;
     CREATE TABLE siswa (
     nim VARCHAR(8) PRIMARY KEY NOT NULL,
     namaDepan VARCHAR(10) NOT NULL,
     namaBelakang VARCHAR(10),
     alamatSiswa VARCHAR(10) NOT NULL,
     tanggalLahir DATE NOT NULL);

3. Create Table "matkul"
     USE nilaiSiswa;
     CREATE TABLE matkul(
     kodeMatkul VARCHAR(5) PRIMARY KEY NOT NULL,
     namaMatkul VARCHAR(30) NOT NULL,
     sks INT NOT NULL);

4.  Create Table "nilai"
     USE nilaiSiswa;
     CREATE TABLE nilai(
     idNilai INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
     nim VARCHAR(8) FOREIGN KEY REFERENCES siswa(nim),
     kodeMatkul VARCHAR(5) FOREIGN KEY REFERENCES matkul(kodeMatkul),
     uts INT,
     uas INT);