tugas sebelumnya ada di sini klik
TUGAS 4 Kelompok SMBD
TUGAS 4 KELOMPOK
SISTEM MANAJEMEN BASIS DATA
NAMA KELOMPOK :
Andrianto : 101051005
Nur Arifah Juliyanti : 101051047
Anggreawan : 101051059
Bambang Wahyu S : 101051081
JURUSAN TEKNIK INFORMATIKA
FAKULTAS TEKNOLOGI INDUSTRI
INSTITUT SAINS DAN TEKNOLOGI AKPRIND YOGYAKARTA
2013
Modul 2
mysql> CREATE DATABASE
PRAK2;
mysql>use PRAK2;
mysql>CREATE
TABLE TABLE1(id INT AUTO_INCREMENT primary key,name VARCHAR(30) NOT NULL,salary
FLOAT(10,2) DEFAULT 1000000);
mysql> DESCRIBE TABLE1;
mysql> CREATE
TABLE TABLE2(id INT AUTO_INCREMENT PRIMARY KEY,name VARCHAR(30));
mysql> DESCRIBE
TABLE2;
mysql> CREATE
TABLE TABLE3(id INT AUTO_INCREMENT,name VARCHAR(30),PRIMARY KEY (id));
mysql> DESCRIBE
TABLE3;
mysql> CREATE
TABLE cars(id INT PRIMARY KEY AUTO_INCREMENT,plate VARCHAR (10),brand VARCHAR
(10),UNIQUE (plate));
mysql> DESC cars;
mysql> INSERT
INTO cars VALUES (1, 'AB-1234-CD', 'Toyota');
mysql> SELECT *
FROM cars;
mysql> INSERT
INTO cars VALUES (2, 'AB-1234-CD', 'Suzuki');
mysql> SHOW
TABLES;
mysql> CREATE
TABLE IF NOT EXISTS TABLE12(id INT AUTO_INCREMENT primary key, name VARCHAR(30)
NOT NULL, salary FLOAT(10,2) DEFAULT 1000000);
mysql> CREATE
TABLE IF NOT EXISTS TABLE4(id INT AUTO_INCREMENT primary key,name VARCHAR(30)
NOT NULL,salary FLOAT(10,2) DEFAULT 1000000);
mysql> SHOW
TABLES;
mysql> CREATE
TABLE employee(id INT AUTO_INCREMENT PRIMARY KEY,first_name
VARCHAR(15),last_name VARCHAR(15),start_date DATE,end_date DATE,salary
FLOAT(8,2),city VARCHAR(10),description VARCHAR(15));
mysql> DESCRIBE
employee;
