winda11051046.blogspot.com
matkul smbd: TUGAS MODUL 5
http://winda11051046.blogspot.com/2013/01/tugas-modul-5.html
Kamis, 17 Januari 2013. Mysql select * from employee join;. Id first name last name start date end date. 1996-07-25 2006-07-25 1235.56 Toronto. 1976-03-21 1986-02-21 6662.78 Vancouver. 1978-12-12 1990-03-15 6545.78 Vancouver. 1982-10-24 1999-04-21 2345.78 Vancouver. 1984-01-15 1998-08-08 2335.78 Vancouver. 1987-07-30 1996-01-04 4323.78 New York. 1990-12-31 1998-02-12 7898.78 New York. 1996-09-17 2002-04-15 1223.78 Vancouver. 1973-05-23 2001-08-09 4313.98 Brussels. 10 rows in set (0.01 sec). TUGAS KELOMPO...
winda11051046.blogspot.com
matkul smbd: TUGAS MODUL 1
http://winda11051046.blogspot.com/2013/01/tugas-modul-1.html
Kamis, 17 Januari 2013. Mysql create database pethouse;. Query OK, 1 row affected (0.05 sec). Mysql use pethouse;. Mysql create table event(name varchar(20), date date, type varchar(15), remark varchar(225) ;. Query OK, 0 rows affected (0.22 sec). Mysql desc event;. Null Key Default Extra. 4 rows in set (0.05 sec). Query OK, 4 rows affected (0.04 sec). Mysql select * from event;. Fluffy 1995-05-15 litter 4 kittens, 3 female, 1 male. 1993-06-23 litter 5 puppies, 2 female, 3 male. Mysql select * from event;.
winda11051046.blogspot.com
matkul smbd: November 2012
http://winda11051046.blogspot.com/2012_11_01_archive.html
Sabtu, 10 November 2012. Microsoft Virtual Basic 6.0. Setelah muncul tulisan seperti di bawah. Setelah itu akan muncul tampilan berikut :. Setelah itu tambahkan komponen untuk konek Acces dengan cara klik pada bagian menu project. Components. Dan akan muncul tampilan seperti berikut :. Microsoft ADO Data Control 6.0. Setelah menekan tombol Ok, maka pada toolbox akan ditambahkan elemen-elemen tambahan yang bisa konek ke database Acces, sebagai berikut:. Pada bagian Caption, isi dengan Barang. Pada command...
winda11051046.blogspot.com
matkul smbd: Januari 2013
http://winda11051046.blogspot.com/2013_01_01_archive.html
Kamis, 17 Januari 2013. Mysql select * from employee join;. Id first name last name start date end date. 1996-07-25 2006-07-25 1235.56 Toronto. 1976-03-21 1986-02-21 6662.78 Vancouver. 1978-12-12 1990-03-15 6545.78 Vancouver. 1982-10-24 1999-04-21 2345.78 Vancouver. 1984-01-15 1998-08-08 2335.78 Vancouver. 1987-07-30 1996-01-04 4323.78 New York. 1990-12-31 1998-02-12 7898.78 New York. 1996-09-17 2002-04-15 1223.78 Vancouver. 1973-05-23 2001-08-09 4313.98 Brussels. 10 rows in set (0.01 sec). Mysql create ...
winda11051046.blogspot.com
matkul smbd: TUGAS MODUL 4
http://winda11051046.blogspot.com/2013/01/tugas-modul-4.html
Kamis, 17 Januari 2013. Mysql create database employee;. Query OK, 1 row affected (0.01 sec). Mysql use employee;. Mysql create table employee(id int(11) 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) ;. Query OK, 0 rows affected (1.03 sec). Mysql desc employee;. Null Key Default Extra. 8 rows in set (0.25 sec). Query OK, 11 rows affected (0.16 sec). Mysql select* from employee;. Mysql inser...
winda11051046.blogspot.com
matkul smbd: TUGAS REVIEW SMBD
http://winda11051046.blogspot.com/2013/01/tugas-review-smbd.html
Kamis, 17 Januari 2013. RANCANGAN STRUKTUR TABEL DATABASE YG DIGUNAKAN (DLM BENTUK 3NF). PRIMARY KEY and FOREIGN KEY. Admin; 2 =. Kepala sekolah; 3 =. Anggota; 5 = pengunjung. 2 Tabel: tanggal libur. 3 Tabel: tarif denda. 4 Tabel: tarif hilang. 5 Tabel: tarif rusak. Guru/ karyawan; 2 =. 1 = aktif; 2 = tidak aktif. Catatan: kode pinjam boleh tidak digunakan. Primary Key / Foreign Key. Primary Key / Foreign Key. Primary Key / Foreign Key. Kode kembaliboleh tidak digunakan. Primary Key / Foreign Key. Mysql ...