Data Base Penjualan Hp

CREATE table penjualan(kdbarang text (5) primary key,nmbarang text (15),tanggalbeli date,harga currency);
INSERT into penjualan
values("901","nokia","10/09/2011","2000000")
INSERT into penjualan
values("902","nexian","10/10/2011","2500000")
INSERT into penjualan
values("903","motorlola","10/11/2011","1500000")
INSERT into penjualan
values("904","samsung","10/12/2011","1300000")
INSERT into penjualan
values("905","imo","10/13/2011","500000")

penjualan

kdbarang	nmbarang	tanggalbeli	harga
901	nokia	10/9/2011	Rp2,000,000.00
902	nexian	10/10/2011	Rp2,500,000.00
903	motorlola	10/11/2011	RP1,500,000.00
904	samsung	10/12/2011	Rp1,300,000.00
905	imo	10/13/2011	Rp500,000.00

2.table barang

CREATE table barang(kdbarang text (5) primary key,nmbarang text (15),jumlahbarang text (5));
INSERT into barang
values("901","nokia","5")
INSERT into barang
values("902","nexian","7")
INSERT into barang
values("902","nexian","7")
INSERT into barang
values("904","samsung","6")
INSERT into barang
values("905","imo","4")

barang

kdbarang	nmbarang	jumlahbarang
901	nokia	5
902	nexian	7
903	motorlola	3
904	samsung	6
905	imo	4

3.table harga
CREATE table harga(nmbarang text (15) primary key,hargahpbaru currency,hargahpsecond currency);
INSERT into harga
values("nokia","2000000","1000000)
INSERT into harga
values("nexian","2500000","1000000")
INSERT into harga
values("motorlola","1500000","750000")
INSERT into harga
values("samsung","1300000","800000")
INSERT into harga
values("imo","500000","200000")

harga

nmbarang	hargahpbaru	hargahpsecond
imo	Rp500,000.00	Rp200,000.00
motorlola	Rp1,500,000.00	Rp750,000.00
nexian	Rp2,500,000.00	Rp1,000,000.00
nokia	RP2,000,000.00	Rp1,000,000.00
samsung	Rp1,300,000.00	Rp800,000.00