Membuat Database Praktek: Laporan 1 Basisdata 2 Putri Sakinah Mi 2B 1101091008
Membuat Database Praktek: Laporan 1 Basisdata 2 Putri Sakinah Mi 2B 1101091008
Membuat Database Praktek: Laporan 1 Basisdata 2 Putri Sakinah Mi 2B 1101091008
+--------------------+
| information_schema |
| latihan1
| latihan2
| mysql
+--------------------+
4 rows in set (0.00 sec)
mysql> use mysql;
Database changed
mysql> show tables;
+---------------------------+
| columns_priv
| db
| func
| help_category
| help_keyword
| help_relation
| help_topic
| host
| proc
| procs_priv
| tables_priv
| time_zone
| time_zone_leap_second
| time_zone_name
| time_zone_transition
| time_zone_transition_type |
| user
+---------------------------+
17 rows in set (0.00 sec)
------+-------------+-----------+-------------+---------------+--------------+----------+------------+-----------------+------------+------------+-------------+------------+-----------------------+------------------+--------------+----------------+------------------+------------------+----------------+--------------------+--------------------+------------------+----------+------------+------------+--------------+---------------+-------------+-----------------+---------------------+
| Host
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|Y
|
0|
|Y
0|
|Y
|Y
|
0|
0|
+-----------+------+----------+-------------+-------------+-------------+------------+-------------+-----------+-------------+---------------+--------------+----------+------------+-----------------+------------+------------+-------------+------------+-----------------------+------------------+--------------+----------------+------------------+------------------+----------------+--------------------+--------------------+------------------+----------+------------+------------+--------------+---------------+-------------+-----------------+---------------------+
1 row in set (0.00 sec)
2. Membuat sebuah Tabel. Terdapat beberapa perintah yaitu :
*Membuat database praktek
*Membuat tabel mahasiswa dengan struktur
-nobp varchar(15) pknn,nama varchar(30) nn);
*Membuat tabel film dengan struktur
- IdFilm char 5 primary key not null
- Judul fil varchar 30 not null
Membuat tabel karyawan
- IdKaryawan char 5 pk nn
- Nama varchar 30 nn
- Alamat varchar 50 nn
- Bagian varchar 30 nn
mysql> create database praktek;
Query OK, 1 row affected (0.02 sec)
Tabel Mahasiswa
mysql> create table mahasiswa (nobp varchar(15) primary key not null,nama varcha
r(30) not null);
Query OK, 0 rows affected (0.03 sec)
Tabel Film
mysql> create table film (id_film varchar(5) primary key not null,judul varchar(
30) not null, aktor varchar(30) not null);
Query OK, 0 rows affected (0.06 sec)
Tabel Karyawan
mysql> create table karyawan(idkaryawan char(5) primary key not null,nama varcha
r(30) not null,alamat varchar(50) not null,bagian varchar(30) not null);
Query OK, 0 rows affected (0.08 sec)
Show tables
mysql> show tables;
+---------------------------+
| Tables_in_mysql
+---------------------------+
| columns_priv
| db
| film
| func
| help_category
| help_keyword
| help_relation
| help_topic
| host
|
|
| mahasiswa
| proc
|
|
| procs_priv
| tables_priv
| time_zone
| time_zone_leap_second
| time_zone_name
| time_zone_transition
| time_zone_transition_type |
| user
+---------------------------+
20 rows in set (0.00 sec)
+-------+-------------+------+-----+---------+-------+
| nobp | varchar(15) | NO | PRI |
| nama | varchar(30) | NO |
|
|
|
|
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
+-------+-------------+------+-----+---------+-------+
| nobp | varchar(15) | NO | PRI |
| nama | varchar(30) | NO |
|
|
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.02 sec)
|
|
+-------+-------------+------+-----+---------+-------+
| nobp | varchar(15) | NO | PRI |
| nama | varchar(30) | NO |
|
|
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
|
|
Tabel Film
mysql> desc film;
+---------+-------------+------+-----+---------+-------+
| Field | Type
+---------+-------------+------+-----+---------+-------+
| id_film | varchar(5) | NO | PRI |
| judul | varchar(30) | NO |
| aktor | varchar(30) | NO |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
+---------+-------------+------+-----+---------+-------+
| id_film | varchar(5) | NO | PRI |
| judul | varchar(30) | NO |
| aktor | varchar(30) | NO |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
+---------+-------------+------+-----+---------+-------+
| id_film | varchar(5) | NO | PRI |
| judul | varchar(30) | NO |
| aktor | varchar(30) | NO |
+---------+-------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
Tabel Karyawan
mysql> desc karyawan;
+------------+-------------+------+-----+---------+-------+
| Field
| Type
+------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5)
| NO | PRI |
| nama
| varchar(30) | NO |
| alamat
| varchar(50) | NO |
| bagian
| varchar(30) | NO |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
| Type
+------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5)
| NO | PRI |
| nama
| varchar(30) | NO |
| alamat
| varchar(50) | NO |
| bagian
| varchar(30) | NO |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)
| Type
+------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5)
| NO | PRI |
| nama
| varchar(30) | NO |
| alamat
| varchar(50) | NO |
| bagian
| varchar(30) | NO |
+------------+-------------+------+-----+---------+-------+
4 rows in set (0.01 sec)
Tabel mahasiswa
Melakukan penambahan field pada tabel mahasiswa
mysql> alter table mahasiswa add kelas char(5),add prodi varchar(30),add jurusan
varchar(30);
Query OK, 0 rows affected (0.11 sec)
Records: 0 Duplicates: 0 Warnings: 0
Tabel Karyawan
Melakukan penambahan field pada tabel karyawan
mysql> alter table karyawan add tunjangananak float not null,add jumanak int not
null;
Query OK, 0 rows affected (0.13 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql> desc karyawan;
+---------------+-------------+------+-----+---------+-------+
| Field
| Type
| Null | Key | Default | Extra |
+---------------+-------------+------+-----+---------+-------+
| idkaryawan | char(5) | NO | PRI |
|
|
| nama
| varchar(30) | NO | |
|
|
| alamat
| varchar(50) | NO | |
|
|
| bagian
| varchar(30) | NO | |
|
|
| tunjangananak | float
| NO | |
|
|
| jumanak
| int(11) | NO | |
|
|
+---------------+-------------+------+-----+---------+-------+
6 rows in set (0.00 sec)