Sumbangan

Nama : Hambry
NPM
: 13.511.006
1. Create database sumbangan;
2. Buat Tabel Donatur
CREATE TABLE t_donatur ( id_donatur varchar (10) NOT NULL,
nama varchar (50) NOT NULL, alamat varchar (50) NOT NULL,
no_telp varchar (15) NOT NULL, PRIMARY KEY (id_donatur));
3. Buat Table Petugas
CREATE TABLE t_petugas (
id_petugas varchar (15) NOT NULL,
nama varchar (50) NOT NULL,
PRIMARY KEY (id_petugas));
4. Buat table T_Faktur
CREATE TABLE t_transaksi (
id_transaksi varchar (15) NOT NULL,
id_petugas varchar (15) NOT NULL,
id_donatur varchar (15) NOT NULL,
tanggal_transaksi date,
nominal_transaksi decimal (25.0) NOT NULL,
PRIMARY KEY (id_transaksi));
5. Buat Tabel T_Faktur
CREATE TABLE t_faktur (
id_faktur varchar(15) NOT NULL,
id_petugas varchar(15) NOT NULL,
id_transaksi varchar(15) NOT NULL,
id_donatur varchar (15),
nama_petugas varchar (50)NOT NULL,
tanggal date,
PRIMARY KEY (id_faktur),
KEY id_petugas (id_petugas),
constraint t_faktur foreign key (id_petugas)
references t_transaksi (id_transaksi))
engine=innodb auto_increment=4 default charset=latin1;
6. Record table t_donatur
INSERT INTO t_donatur VALUES ('D001','Bambang','Jl.Kerakyatan no.50','0541202564');
INSERT INTO t_donatur VALUES ('D002','Joko','Jl.Kemakmuran no.65','0541202333');
INSERT INTO t_donatur VALUES ('D003','Sri Wahyuni','Jl.Kehewanan
no.150','0541-202777');
INSERT INTO t_donatur VALUES ('D004','Michael','Jl.Kebaktian no.502','0541202678');
INSERT INTO t_donatur VALUES ('D005','Ana','Jl.Merdeka no.31','0541-202121');
7. Record table t-petugas
INSERT INTO t_petugas Values ('P001','Gatot S.');
INSERT INTO t_petugas Values ('P002','Ika S.');
INSERT INTO t_petugas Values ('P003','Ina');
INSERT INTO t_petugas Values ('P001','Wawan');
INSERT INTO t_petugas Values ('P001','Mira');
8. Record table