Latih Ulang Latihan Membuat Database tanggal 18/04/2012

 Berikut tutorialnya :

1. Membuat Database
mysql> create database Jadwal_TIC;
Query OK, 1 row affected (0.00 sec)

2.Memilih Datababe
mysql> use Jadwal_TIC;
Database changed

3.Membuat Table 1 "Matkul"
mysql> create table Matkul(
    -> Id_Matkul varchar (5) not null primary key,
    -> Nm_Matkul varchar (20),
    -> SKS int,
    -> Smt int
    -> );
Query OK, 0 rows affected (1.26 sec)

4.Melihat Tampilan Tabel 1 "Matkul"
mysql> desc Matkul;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| Id_Matkul | varchar(5)  | NO   | PRI | NULL    |       |
| Nm_Matkul | varchar(20) | YES  |     | NULL    |       |
| SKS       | int(11)     | YES  |     | NULL    |       |
| Smt       | int(11)     | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.16 sec)

5.Membuat Table 2 "Ruang"
mysql> create table Ruang(
    -> Id_Ruang varchar (2) not null primary key,
    -> Nm_Ruang varchar (10),
    -> Kapasitas int
    -> );
Query OK, 0 rows affected (0.52 sec)

6. Melihat Tampilan Table 2 "Ruang"
mysql> desc Ruang;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| Id_Ruang  | varchar(2)  | NO   | PRI | NULL    |       |
| Nm_Ruang  | varchar(10) | YES  |     | NULL    |       |
| Kapasitas | int(11)     | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

7.Membuat Table 3 "Jadwal"
mysql> create table Jadwal(
    -> Id_Jadwal varchar (3) not null primary key,
    -> Id_Matkul varchar (5),
    -> Id_Ruang varchar (2),
    -> Hari varchar (10)
    -> );
Query OK, 0 rows affected (0.82 sec)

8. Melihat Tampilan Table 3 "Jadwal"
mysql> desc jadwal;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| Id_Jadwal | varchar(3)  | NO   | PRI | NULL    |       |
| Id_Matkul | varchar(5)  | YES  |     | NULL    |       |
| Id_Ruang  | varchar(2)  | YES  |     | NULL    |       |
| Hari      | varchar(10) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (1.17 sec)

9.Mengisi Data di  Table 1 "Matkul"
mysql> insert into Matkul values
    -> ('MK001','Jaringan Komputer','2','5');
Query OK, 1 row affected (0.27 sec)

mysql> insert into Matkul values
    -> ('MK002','Basis Data 2','2','4');
Query OK, 1 row affected (0.48 sec)

mysql> insert into Matkul values
    -> ('MK003','Kewirausahaan','3','4');
Query OK, 1 row affected (0.00 sec)

10. Menampilkan Isi Data  Table 1 "Matkul"
mysql> select * from Matkul;
+-----------+-------------------+------+------+
| Id_Matkul | Nm_Matkul         | SKS  | Smt  |
+-----------+-------------------+------+------+
| MK001     | Jaringan Komputer |    2 |    5 |
| MK002     | Basis Data 2      |    2 |    4 |
| MK003     | Kewirausahaan     |    3 |    4 |
+-----------+-------------------+------+------+
3 rows in set (0.06 sec)

11. Mengisi Data di  Table 2 "Ruang"
mysql> insert into Ruang values
    -> ('R1','R. Teori A','40');
Query OK, 1 row affected (0.73 sec)

mysql> insert into Ruang values
    -> ('R2','R. Teori B','35');
Query OK, 1 row affected (0.03 sec)

mysql> insert into Ruang values
    -> ('R3','R. Teori C','40');
Query OK, 1 row affected (0.31 sec)

12.Menampilkan Isi Data  Table 2 "Ruang"
mysql> select * from Ruang;
+----------+------------+-----------+
| Id_Ruang | Nm_Ruang   | Kapasitas |
+----------+------------+-----------+
| R1       | R. Teori A |        40 |
| R2       | R. Teori B |        35 |
| R3       | R. Teori C |        40 |
+----------+------------+-----------+
3 rows in set (0.00 sec)

13. Mengisi Data di  Table 3 "Jadwal"
mysql> insert into Jadwal values
    -> ('J01','Senin','MK001','R1');
Query OK, 1 row affected, 1 warning (0.16 sec)

mysql> insert into Jadwal values
    -> ('J02','Senin','MK003','R2');
Query OK, 1 row affected, 1 warning (0.05 sec)

mysql> insert into Jadwal values
    -> ('J03','Selasa','MK003','R2');
Query OK, 1 row affected, 2 warnings (0.73 sec)

mysql> insert into Jadwal values
    -> ('J04','Selasa','MK002','R3');
Query OK, 1 row affected, 2 warnings (0.27 sec)

14.Menampilkan Isi Data  Table 3 "Jadwal"
mysql> select * from Jadwal;
+-----------+-----------+----------+------+
| Id_Jadwal | Id_Matkul | Id_Ruang | Hari |
+-----------+-----------+----------+------+
| J01       | Senin     | MK       | R1   |
| J02       | Senin     | MK       | R2   |
| J03       | Selas     | MK       | R2   |
| J04       | Selas     | MK       | R3   |
+-----------+-----------+----------+------+
4 rows in set (0.00 sec)


**Salam Super Teknik Informatika Institut Teknologi Padang**

Sintaks Umum HTML

Yang paling penting diingat dalam HTML yaitu :

Sintaks Umum berupa :

<html>
<head>
  <title> ..........</title>
</head>
  <body>
  ..............................
  ..............................
  ..............................
  ..............................
  </body>
</html>


**Salam Super Teknik Informatika Institut Teknologi Padang**