Microsoft Windows [Version 10.0.18363.

1500]

(c) 2019 Microsoft Corporation. All rights reserved.

C:\Users\62877>cd\

C:\>cd xampp

C:\xampp>cd mysql

C:\xampp\mysql>cd bin

C:\xampp\mysql\bin>mysql -u root

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 8

Server version: 10.4.21-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)]> show databases;

+--------------------+

| Database |

+--------------------+

| bank_rendy |

| information_schema |

| mysql |

| penjualan |

| performance_schema |

| phpmyadmin |

| test |
+--------------------+

7 rows in set (0.370 sec)

MariaDB [(none)]> create database RESERVASI_PENERBANGAN

-> ;

Query OK, 1 row affected (0.047 sec)

MariaDB [(none)]> show databases;

+-----------------------+

| Database |

+-----------------------+

| bank_rendy |

| information_schema |

| mysql |

| penjualan |

| performance_schema |

| phpmyadmin |

| reservasi_penerbangan |

| test |

+-----------------------+

8 rows in set (0.001 sec)

MariaDB [(none)]> use reservasi_penerbangan;

Database changed

MariaDB [reservasi_penerbangan]> create table agen(

-> ID_Agen int not null,

-> Nama_Agen varchar(30) not null,

-> NomorHP varchar(20) not null,

-> primary key(ID_Agen)

-> );

Query OK, 0 rows affected (0.614 sec)

MariaDB [reservasi_penerbangan]> desc agen;

+-----------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-----------+-------------+------+-----+---------+-------+

| ID_Agen | int(11) | NO | PRI | NULL | |

| Nama_Agen | varchar(30) | NO | | NULL | |

| NomorHP | varchar(20) | NO | | NULL | |

+-----------+-------------+------+-----+---------+-------+

3 rows in set (0.068 sec)

MariaDB [reservasi_penerbangan]> create table pembeli(

-> ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near '' at line 1

MariaDB [reservasi_penerbangan]> drop table agen;

Query OK, 0 rows affected (0.972 sec)

MariaDB [reservasi_penerbangan]> desc agen;

ERROR 1146 (42S02): Table 'reservasi_penerbangan.agen' doesn't exist

MariaDB [reservasi_penerbangan]> create table agen(

-> ID_Agen int not null auto_increment primary key,

-> Nama_Agen varchar(30) not null,

-> NomorHP varchar(20) not null,

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near ')' at line 5

MariaDB [reservasi_penerbangan]> desc agen;

ERROR 1146 (42S02): Table 'reservasi_penerbangan.agen' doesn't exist

MariaDB [reservasi_penerbangan]> create table agen(

-> ID_Agen int not null auto_increment primary key,

-> Nama_Agen varchar(30) not null,

 -> NomorHP varchar(20) not null,

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near ')' at line 5

MariaDB [reservasi_penerbangan]> create table agen(

-> ID_Agen int not null auto_increment primary key,

-> Nama_Agen varchar(30) not null,

-> NomorHP varchar(20) not null

-> );

Query OK, 0 rows affected (0.399 sec)

MariaDB [reservasi_penerbangan]> desc agen;

+-----------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-----------+-------------+------+-----+---------+----------------+

| ID_Agen | int(11) | NO | PRI | NULL | auto_increment |

| Nama_Agen | varchar(30) | NO | | NULL | |

| NomorHP | varchar(20) | NO | | NULL | |

+-----------+-------------+------+-----+---------+----------------+

3 rows in set (0.028 sec)

MariaDB [reservasi_penerbangan]> create table pembeli(

-> Nomor_Pembeli int not null auto_increment primary key,

-> ID_Agen int,

-> Nama_Pembeli varchar(30) not null,

-> Tanggal_Lahir date,

-> umur int,

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen),

->

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near ')' at line 9
MariaDB [reservasi_penerbangan]> create table pembeli(

-> Nomor_Pembeli int not null auto_increment primary key,

-> ID_Agen int,

-> Nama_Pembeli varchar(30) not null,

-> Tanggal_Lahir date,

-> umur int,

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen)

-> );

Query OK, 0 rows affected (0.301 sec)

MariaDB [reservasi_penerbangan]> desc pembeli;

+---------------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+---------------+-------------+------+-----+---------+----------------+

| Nomor_Pembeli | int(11) | NO | PRI | NULL | auto_increment |

| ID_Agen | int(11) | YES | MUL | NULL | |

| Nama_Pembeli | varchar(30) | NO | | NULL | |

| Tanggal_Lahir | date | YES | | NULL | |

| umur | int(11) | YES | | NULL | |

+---------------+-------------+------+-----+---------+----------------+

5 rows in set (0.049 sec)

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null auto_increment primary key,

-> Nomor_Pembeli int,

-> ID_Maskapai varchar(30) not null auto_increment primary key,

-> ID_Agen int,

-> Waktu_Penerbangan date,

-> Tempat_Tujuan varchar(30),

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli,)
 -> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli
(Nomor_Pembeli,)

-> ;

ERROR 1063 (42000): Incorrect column specifier for column 'ID_Maskapai'

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null auto_increment primary key,

-> Nomor_Pembeli int,

-> ID_Maskapai varchar(30) not null auto_increment primary key,

-> ID_Agen int,

-> Waktu_Penerbangan date,

-> Tempat_Tujuan varchar(30),

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen)

-> );

ERROR 1063 (42000): Incorrect column specifier for column 'ID_Maskapai'

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null auto_increment primary key,

-> Nomor_Pembeli int,

-> ID_Maskapai int not null auto_increment primary key,

-> ID_Agen int,

-> Waktu_Penerbangan date,

-> Tempat_Tujuan varchar(30),

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen)

-> );

ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be
defined as a key

MariaDB [reservasi_penerbangan]> desc pemesanan;

ERROR 1146 (42S02): Table 'reservasi_penerbangan.pemesanan' doesn't exist

MariaDB [reservasi_penerbangan]> create table pemesanan(

 -> Kode_Pesan int not null auto_increment primary key,

-> Nomor_Pembeli int,

-> ID_Maskapai int not null,

-> ID_Agen int,

-> Waktu_Penerbangan date,

-> Tempat_Tujuan varchar(30),

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen)

-> );

ERROR 1005 (HY000): Can't create table `reservasi_penerbangan`.`pemesanan` (errno: 121

"Duplicate key on write or update")

MariaDB [reservasi_penerbangan]> Kode_Pesan int not null,

-> ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near 'Kode_Pesan int not null,' at line 1

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null,

-> Nomor_Pembeli int,

-> ID_Maskapai int not null,

-> ID_Agen int,

-> Waktu_Penerbangan date,

-> Tempat_Tujuan varchar(30),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen)

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli),

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near 'CONSTRAINT Nomor_Pembeli FOREIGN
KEY (Nomor_Pembeli) REFERENCES pembeli (Nomo...' at line 9

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null,

-> Nomor_Pembeli int,

 -> ID_Maskapai int not null,

-> ID_Agen int,

-> Waktu_Penerbangan date,

-> Tempat_Tujuan varchar(30),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen),

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli),

-> );

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near ')' at line 10

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null,

-> Nomor_Pembeli int,

-> ID_Maskapai int not null,

-> ID_Agen int,

-> Waktu_Penerbangan date,

-> Tempat_Tujuan varchar(30),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen),

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli)

-> );

ERROR 1005 (HY000): Can't create table `reservasi_penerbangan`.`pemesanan` (errno: 121

"Duplicate key on write or update")

MariaDB [reservasi_penerbangan]> desc pemesanan;

ERROR 1146 (42S02): Table 'reservasi_penerbangan.pemesanan' doesn't exist

MariaDB [reservasi_penerbangan]> show databases;

+-----------------------+

| Database |

+-----------------------+

| bank_rendy |

| information_schema |

| mysql |
| penjualan |

| performance_schema |

| phpmyadmin |

| reservasi_penerbangan |

| test |

+-----------------------+

8 rows in set (0.029 sec)

MariaDB [reservasi_penerbangan]> use reservasi_penerbangan;

Database changed

MariaDB [reservasi_penerbangan]> show table;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near '' at line 1

MariaDB [reservasi_penerbangan]> show tables;

+---------------------------------+

| Tables_in_reservasi_penerbangan |

+---------------------------------+

| agen |

| pembeli |

+---------------------------------+

2 rows in set (0.033 sec)

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null,

-> Nomor_Pembeli int,

-> ID_Maskapai varchar(30) not null,

-> ID_Agen int,

-> Waktu_Penerbangan int not null,

-> Tempat_Tujuan varchar(30) not null,

-> primary key(Kode_Pesan)

-> );
Query OK, 0 rows affected (0.306 sec)

MariaDB [reservasi_penerbangan]> show tables;

+---------------------------------+

| Tables_in_reservasi_penerbangan |

+---------------------------------+

| agen |

| pembeli |

| pemesanan |

+---------------------------------+

3 rows in set (0.001 sec)

MariaDB [reservasi_penerbangan]> desc pemesanan;

+-------------------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------------------+-------------+------+-----+---------+-------+

| Kode_Pesan | int(11) | NO | PRI | NULL | |

| Nomor_Pembeli | int(11) | YES | | NULL | |

| ID_Maskapai | varchar(30) | NO | | NULL | |

| ID_Agen | int(11) | YES | | NULL | |

| Waktu_Penerbangan | int(11) | NO | | NULL | |

| Tempat_Tujuan | varchar(30) | NO | | NULL | |

+-------------------+-------------+------+-----+---------+-------+

6 rows in set (0.039 sec)

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null,

-> Nomor_Pembeli int,

-> ID_Maskapai varchar(30) not null,

-> ID_Agen int,

-> Waktu_Penerbangan int not null,

 -> Tempat_Tujuan varchar(30) not null,

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen),

-> primary key(Kode_Pesan)

-> );

ERROR 1050 (42S01): Table 'pemesanan' already exists

MariaDB [reservasi_penerbangan]> show tables;

+---------------------------------+

| Tables_in_reservasi_penerbangan |

+---------------------------------+

| agen |

| pembeli |

| pemesanan |

+---------------------------------+

3 rows in set (0.001 sec)

MariaDB [reservasi_penerbangan]> drop table pemesanan;

Query OK, 0 rows affected (0.633 sec)

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null,

-> Nomor_Pembeli int,

-> ID_Maskapai varchar(30) not null,

-> ID_Agen int,

-> Waktu_Penerbangan int not null,

-> Tempat_Tujuan varchar(30) not null,

-> CONSTRAINT Nomor_Pembeli FOREIGN KEY (Nomor_Pembeli) REFERENCES pembeli

(Nomor_Pembeli),

-> CONSTRAINT ID_Agen FOREIGN KEY (ID_Agen) REFERENCES agen (ID_Agen),

-> primary key(Kode_Pesan)

-> );
ERROR 1005 (HY000): Can't create table `reservasi_penerbangan`.`pemesanan` (errno: 121
"Duplicate key on write or update")

MariaDB [reservasi_penerbangan]> desc pemesanan;

ERROR 1146 (42S02): Table 'reservasi_penerbangan.pemesanan' doesn't exist

MariaDB [reservasi_penerbangan]> create table pemesanan(

-> Kode_Pesan int not null,

-> Nomor_Pembeli int,

-> ID_Maskapai varchar(30) not null,

-> ID_Agen int,

-> Waktu_Penerbangan int not null,

-> Tempat_Tujuan varchar(30) not null,

-> primary key(Kode_Pesan)

-> );

Query OK, 0 rows affected (0.254 sec)

MariaDB [reservasi_penerbangan]> show tables;

+---------------------------------+

| Tables_in_reservasi_penerbangan |

+---------------------------------+

| agen |

| pembeli |

| pemesanan |

+---------------------------------+

3 rows in set (0.027 sec)

MariaDB [reservasi_penerbangan]> desc pemesanan;

+-------------------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------------------+-------------+------+-----+---------+-------+

| Kode_Pesan | int(11) | NO | PRI | NULL | |

| Nomor_Pembeli | int(11) | YES | | NULL | |

| ID_Maskapai | varchar(30) | NO | | NULL | |

| ID_Agen | int(11) | YES | | NULL | |

| Waktu_Penerbangan | int(11) | NO | | NULL | |

| Tempat_Tujuan | varchar(30) | NO | | NULL | |

+-------------------+-------------+------+-----+---------+-------+

6 rows in set (0.008 sec)

MariaDB [reservasi_penerbangan]> create table pembayaran(

-> Kode_Pembayaran int not null,

-> Kode_Pesan int,

-> Kode_Bank int not null,

-> Harga varchar(30) not null,

-> Jumlah_Beli int not null,

-> Total_Harga varchar(30) not null,

-> primary key(Kode_Pembayaran)

-> );

Query OK, 0 rows affected (0.309 sec)

MariaDB [reservasi_penerbangan]> show tables;

+---------------------------------+

| Tables_in_reservasi_penerbangan |

+---------------------------------+

| agen |

| pembayaran |

| pembeli |

| pemesanan |

+---------------------------------+

4 rows in set (0.001 sec)

MariaDB [reservasi_penerbangan]> desc pembayaran;

+-----------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |

+-----------------+-------------+------+-----+---------+-------+

| Kode_Pembayaran | int(11) | NO | PRI | NULL | |

| Kode_Pesan | int(11) | YES | | NULL | |

| Kode_Bank | int(11) | NO | | NULL | |

| Harga | varchar(30) | NO | | NULL | |

| Jumlah_Beli | int(11) | NO | | NULL | |

| Total_Harga | varchar(30) | NO | | NULL | |

+-----------------+-------------+------+-----+---------+-------+

6 rows in set (0.014 sec)

MariaDB [reservasi_penerbangan]> create table tiket(

-> No_Tiket int not null,

-> Kode_Pembayaran int,

-> No_Kursi int not null,

-> Gate int not null,

-> primary key(No_Tiket)

-> );

Query OK, 0 rows affected (0.247 sec)

MariaDB [reservasi_penerbangan]> create table maskapai(

-> ID_Maskapai int,

-> Kode_Pesan int,

-> Nama_Maskapai char not null,

-> primary key(ID_Maskapai)

-> );

Query OK, 0 rows affected (0.265 sec)

MariaDB [reservasi_penerbangan]> create table pesawat(

-> ID_Pesawat char not null,

-> ID_Maskapai varchar(30),

 -> Nama_Pesawat varchar(30) not null,

-> primary key(ID_Pesawat)

-> );

Query OK, 0 rows affected (0.247 sec)

MariaDB [reservasi_penerbangan]> show tables

-> ;

+---------------------------------+

| Tables_in_reservasi_penerbangan |

+---------------------------------+

| agen |

| maskapai |

| pembayaran |

| pembeli |

| pemesanan |

| pesawat |

| tiket |

+---------------------------------+

7 rows in set (0.002 sec)

MariaDB [reservasi_penerbangan]> create table pilot(

-> ID_Pilot char not null,

-> ID_Pesawat char,

-> Nama_Pilot char not null,

-> primary key(ID_Pilot)

-> );

Query OK, 0 rows affected (0.245 sec)

MariaDB [reservasi_penerbangan]> create table bank(

-> Kode_Bank int not null,

-> Nama_Bank char not null,

 -> Nama_Rek char not null,

-> No_Rek int not null,

-> primary key(Kode_Bank)

-> );

Query OK, 0 rows affected (0.232 sec)

MariaDB [reservasi_penerbangan]> show tables;

+---------------------------------+

| Tables_in_reservasi_penerbangan |

+---------------------------------+

| agen |

| bank |

| maskapai |

| pembayaran |

| pembeli |

| pemesanan |

| pesawat |

| pilot |

| tiket |

+---------------------------------+

9 rows in set (0.001 sec)

MariaDB [reservasi_penerbangan]> desc agen;

+-----------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-----------+-------------+------+-----+---------+----------------+

| ID_Agen | int(11) | NO | PRI | NULL | auto_increment |

| Nama_Agen | varchar(30) | NO | | NULL | |

| NomorHP | varchar(20) | NO | | NULL | |

+-----------+-------------+------+-----+---------+----------------+

3 rows in set (0.006 sec)

MariaDB [reservasi_penerbangan]> desc pembeli;

+---------------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+---------------+-------------+------+-----+---------+----------------+

| Nomor_Pembeli | int(11) | NO | PRI | NULL | auto_increment |

| ID_Agen | int(11) | YES | MUL | NULL | |

| Nama_Pembeli | varchar(30) | NO | | NULL | |

| Tanggal_Lahir | date | YES | | NULL | |

| umur | int(11) | YES | | NULL | |

+---------------+-------------+------+-----+---------+----------------+

5 rows in set (0.006 sec)

MariaDB [reservasi_penerbangan]> desc pemesanan;

+-------------------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-------------------+-------------+------+-----+---------+-------+

| Kode_Pesan | int(11) | NO | PRI | NULL | |

| Nomor_Pembeli | int(11) | YES | | NULL | |

| ID_Maskapai | varchar(30) | NO | | NULL | |

| ID_Agen | int(11) | YES | | NULL | |

| Waktu_Penerbangan | int(11) | NO | | NULL | |

| Tempat_Tujuan | varchar(30) | NO | | NULL | |

+-------------------+-------------+------+-----+---------+-------+

6 rows in set (0.006 sec)

MariaDB [reservasi_penerbangan]> desc pembayaran;

+-----------------+-------------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-----------------+-------------+------+-----+---------+-------+

| Kode_Pembayaran | int(11) | NO | PRI | NULL | |

| Kode_Pesan | int(11) | YES | | NULL | |

| Kode_Bank | int(11) | NO | | NULL | |

| Harga | varchar(30) | NO | | NULL | |

| Jumlah_Beli | int(11) | NO | | NULL | |

| Total_Harga | varchar(30) | NO | | NULL | |

+-----------------+-------------+------+-----+---------+-------+

6 rows in set (0.018 sec)

MariaDB [reservasi_penerbangan]> desc tiket;

+-----------------+---------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-----------------+---------+------+-----+---------+-------+

| No_Tiket | int(11) | NO | PRI | NULL | |

| Kode_Pembayaran | int(11) | YES | | NULL | |

| No_Kursi | int(11) | NO | | NULL | |

| Gate | int(11) | NO | | NULL | |

+-----------------+---------+------+-----+---------+-------+

4 rows in set (0.020 sec)

MariaDB [reservasi_penerbangan]> desc maskapai;

+---------------+---------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+---------------+---------+------+-----+---------+-------+

| ID_Maskapai | int(11) | NO | PRI | NULL | |

| Kode_Pesan | int(11) | YES | | NULL | |

| Nama_Maskapai | char(1) | NO | | NULL | |

+---------------+---------+------+-----+---------+-------+

3 rows in set (0.007 sec)

MariaDB [reservasi_penerbangan]> desc pesawat;

+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |

+--------------+-------------+------+-----+---------+-------+

| ID_Pesawat | char(1) | NO | PRI | NULL | |

| ID_Maskapai | varchar(30) | YES | | NULL | |

| Nama_Pesawat | varchar(30) | NO | | NULL | |

+--------------+-------------+------+-----+---------+-------+

3 rows in set (0.009 sec)

MariaDB [reservasi_penerbangan]> desc pilot;

+------------+---------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+------------+---------+------+-----+---------+-------+

| ID_Pilot | char(1) | NO | PRI | NULL | |

| ID_Pesawat | char(1) | YES | | NULL | |

| Nama_Pilot | char(1) | NO | | NULL | |

+------------+---------+------+-----+---------+-------+

3 rows in set (0.007 sec)

MariaDB [reservasi_penerbangan]> desc bank;

+-----------+---------+------+-----+---------+-------+

| Field | Type | Null | Key | Default | Extra |

+-----------+---------+------+-----+---------+-------+

| Kode_Bank | int(11) | NO | PRI | NULL | |

| Nama_Bank | char(1) | NO | | NULL | |

| Nama_Rek | char(1) | NO | | NULL | |

| No_Rek | int(11) | NO | | NULL | |

+-----------+---------+------+-----+---------+-------+

4 rows in set (0.008 sec)

MariaDB [reservasi_penerbangan]>