data base koperasi

CREATE table anggota (idanggota text (5) primary key,nmanggota text(20),alamat text (20),notlp text (15));
INSERT into anggota
values("101","karisma","semarang","081223355671")
INSERT into anggota
values("102","indra","ungaran","081223355672")
INSERT into anggota
values("103","riska","pekalongan","081223355673")
INSERT into anggota
values("104","shasa","semarang","081223355674")
INSERT into anggota
values("105","guntur","pemalang","081223355675")

anggota

idanggota	nmanggota	alamat	notlp
101	karisma	semarang	081223355671
102	indra	ungaran	081223355672
103	riska	pekalongan	081223355673
104	shasa	semarang	081223355674
105	guntur	pemalang	081223355675

2.table petugas
CREATE table petugas(nippetugas text (5)primary key,nmpetugas text (20),jabatan text (20));
INSERT into petugas
values("201","ranti","ketua")
 INSERT into petugas
values("202","rima","wakil ketua")
INSERT into petugas
values("203","bagus","sekertaris")
INSERT into petugas
values("204","indah","bendahara")
INSERT into petugas
values("205","vino","seksi keamanan")

petugas

nippetugas	nmpetugas	jabatan
201	ranti	ketua
202	rima	wakil ketua
203	bagus	sekertaris
204	indah	bendahara
205	vino	seksi keamanan

3.table transaksi
CREATE table transaksi(notransaksi text (5) primary key,nmanggota text (20),tglpinjam date,jmlhpnjm currency,jmlhansuran currency)
INSERT into transaksi
values("001","karisma","02/20/2011","13000000","1300000")
INSERT into transaksi
values("002","indra","06/27/2011","20000000","2000000")
INSERT into transaksi
values("003","riska","03/05/2011","25000000","2500000")
INSERT into transaksi
values("004","shasa","10/10/2011","1500000","150000")
INSERT into transaksi
values("005","guntur","09/10/2011","30000000","3000000")

transaksi

notransaksi	nmanggota	tglpinjam	jmlhpnjm	jmlhansuran
001	karisma	20/02/2011	Rp13,000,000.00	Rp1,300,000.00
002	indra	27/06/2011	Rp20,000,000.00	Rp2,000,000.00
003	riska	05/03/2011	Rp25,000,000.00	Rp2,500,000.00
004	shasa	10/10/2011	Rp1,500,000.00	Rp150,000.00
005	guntur	10/09/2011	Rp30,000,000.00	Rp3,000,000.00