RelasiTabel

Setting environment for using XAMPP for Windows.
LENOVO@DESKTOP-S6731P1 c:\xamp
# color a

LENOVO@DESKTOP-S6731P1 c:\xamp
# mysql -u root -p
Enter password:
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 1023
Server version: 10.4.24-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database schools;
Query OK, 1 row affected (0.476 sec)

MariaDB [(none)]> use schools;
Database changed
MariaDB [schools]> create table majors(ID int primary key auto_increment, NISN int(100) not null, Nama_Lengkap varchar(100) not null);
Query OK, 0 rows affected (12.413 sec)

MariaDB [schools]> create table groups(ID int primary key auto_increment, Jenjang varchar(10) not null, Jurusan varchar(20) not null);
Query OK, 0 rows affected (3.726 sec)

MariaDB [schools]> create table Students(ID int primary key auto_increment, Lolos_Jalur varchar(255) not null, Alamat varchar(255) not null);
Query OK, 0 rows affected (3.531 sec)

MariaDB [schools]> alter table majors add column Jenis_Kelamin varchar(50) not null after Nama_Lengkap;
Query OK, 0 rows affected (1.102 sec)
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [schools]> insert into majors values(null, '20221410.215544.00', 'Revi Nur Yunita', 'Perempuan');
Query OK, 1 row affected, 1 warning (1.466 sec)

MariaDB [schools]> insert into majors values(null, '20221410.215544.01', 'Muhammad Ihsan Nuril A', 'Laki-Laki');
Query OK, 1 row affected, 1 warning (0.465 sec)

MariaDB [schools]> insert into majors values(null, '20221410.215544.01', 'Nadira Arevia Hermawan', 'Perempuan');
Query OK, 1 row affected, 1 warning (0.537 sec)

MariaDB [schools]> delete from majors where id = 2;
Query OK, 1 row affected (1.506 sec)

MariaDB [schools]> delete from majors where id = 3;
Query OK, 1 row affected (0.708 sec)

MariaDB [schools]> insert into majors values(null, '20221410.215544.02', 'Nadira Arevia Hermawan', 'Perempuan');
Query OK, 1 row affected, 1 warning (0.311 sec)

MariaDB [schools]> insert into groups values(null, 'XII', 'Rekayasa Perangkat Lunak');
Query OK, 1 row affected, 1 warning (0.412 sec)

MariaDB [schools]> insert into groups values(null, 'XII', 'Kontark Mekanik B');
Query OK, 1 row affected (0.420 sec)

MariaDB [schools]> insert into groups values(null, 'XII', 'Kontrol Proses A');
Query OK, 1 row affected (0.509 sec)

MariaDB [schools]> insert into students values(null, 'SNMPTN', 'Jl.Semangka No.12');
Query OK, 1 row affected (1.501 sec)

MariaDB [schools]> insert into students values(null, 'SNMPTN', 'Jl.Melon Gg.10');
Query OK, 1 row affected (0.375 sec)

MariaDB [schools]> insert into students values(null, 'SNMPTN', 'Jl.Degan Blok.AB');
Query OK, 1 row affected (0.128 sec)

MariaDB [schools]> select * from majors;
+----+------------+------------------------+---------------+
| ID | NISN       | Nama_Lengkap           | Jenis_Kelamin |
+----+------------+------------------------+---------------+
|  1 | 2147483647 | Revi Nur Yunita        | Perempuan     |
|  4 | 2147483647 | Nadira Arevia Hermawan | Perempuan     |
+----+------------+------------------------+---------------+
2 rows in set (0.107 sec)

MariaDB [schools]> select * from groups;
+----+---------+----------------------+
| ID | Jenjang | Jurusan              |
+----+---------+----------------------+
|  1 | XII     | Rekayasa Perangkat L |
|  2 | XII     | Kontark Mekanik B    |
|  3 | XII     | Kontrol Proses A     |
+----+---------+----------------------+
3 rows in set (0.001 sec)

MariaDB [schools]> select * from students;
+----+-------------+-------------------+
| ID | Lolos_Jalur | Alamat            |
+----+-------------+-------------------+
|  1 | SNMPTN      | Jl.Semangka No.12 |
|  2 | SNMPTN      | Jl.Melon Gg.10    |
|  3 | SNMPTN      | Jl.Degan Blok.AB  |
+----+-------------+-------------------+
3 rows in set (0.564 sec)

MariaDB [schools]> insert into majors values(null, '20221410.215544.01', 'Muhammad Ihsan Nuril A', 'Laki-Laki');
Query OK, 1 row affected, 1 warning (0.601 sec)

MariaDB [schools]> select * from majors;
+----+------------+------------------------+---------------+
| ID | NISN       | Nama_Lengkap           | Jenis_Kelamin |
+----+------------+------------------------+---------------+
|  1 | 2147483647 | Revi Nur Yunita        | Perempuan     |
|  4 | 2147483647 | Nadira Arevia Hermawan | Perempuan     |
|  5 | 2147483647 | Muhammad Ihsan Nuril A | Laki-Laki     |
+----+------------+------------------------+---------------+
3 rows in set (0.001 sec)

MariaDB [schools]> desc majors;
+---------------+--------------+------+-----+---------+----------------+
| Field         | Type         | Null | Key | Default | Extra          |
+---------------+--------------+------+-----+---------+----------------+
| ID            | int(11)      | NO   | PRI | NULL    | auto_increment |
| NISN          | int(100)     | NO   |     | NULL    |                |
| Nama_Lengkap  | varchar(100) | NO   |     | NULL    |                |
| Jenis_Kelamin | varchar(50)  | NO   |     | NULL    |                |
+---------------+--------------+------+-----+---------+----------------+
4 rows in set (2.643 sec)

MariaDB [schools]> desc groups;
+---------+-------------+------+-----+---------+----------------+
| Field   | Type        | Null | Key | Default | Extra          |
+---------+-------------+------+-----+---------+----------------+
| ID      | int(11)     | NO   | PRI | NULL    | auto_increment |
| Jenjang | varchar(10) | NO   |     | NULL    |                |
| Jurusan | varchar(20) | NO   |     | NULL    |                |
+---------+-------------+------+-----+---------+----------------+
3 rows in set (0.347 sec)

MariaDB [schools]> desc students;
+-------------+--------------+------+-----+---------+----------------+
| Field       | Type         | Null | Key | Default | Extra          |
+-------------+--------------+------+-----+---------+----------------+
| ID          | int(11)      | NO   | PRI | NULL    | auto_increment |
| Lolos_Jalur | varchar(255) | NO   |     | NULL    |                |
| Alamat      | varchar(255) | NO   |     | NULL    |                |
+-------------+--------------+------+-----+---------+----------------+
3 rows in set (0.046 sec)

MariaDB [schools]> select s.Nama_Lengkap as Nama_Lengkap, s.Jenis_Kelamin Jenis_Kelamin, j.Jenjang as Jenjang, m.Lolos_Jalur as Lolos_Jalur, m.Alamat as Alamat from majors as s join groups as j on s.ID=j.ID join students as m on j.ID=m.ID;
+-----------------+---------------+---------+-------------+-------------------+
| Nama_Lengkap    | Jenis_Kelamin | Jenjang | Lolos_Jalur | Alamat            |
+-----------------+---------------+---------+-------------+-------------------+
| Revi Nur Yunita | Perempuan     | XII     | SNMPTN      | Jl.Semangka No.12 |
+-----------------+---------------+---------+-------------+-------------------+
1 row in set (0.224 sec)

MariaDB [schools]>