Saindra Santyadiputra

Case:
Click here to see a NORMALIZATION CASE

Completion:

Create table SUPPLY

mysql> create table supply (
-> kode_supply varchar(3) not null primary key,
-> nama_supply varchar(50));
Query OK, 0 rows affected (0.03 sec)


Create table BARANG

mysql> create table barang (
-> kode_brg varchar(3) not null primary key,
-> nama_brg varchar(100));
Query OK, 0 rows affected (0.03 sec)


Create table PRIMARY FAKTUR

mysql> create table primary_faktur
-> (no_fak int(3) not null primary key,
-> tanggal date,
-> jatuh_tempo date,
-> kode_supply varchar(3),
-> foreign key (kode_supply) references
-> supply(kode_supply) on update cascade);
Query OK, 0 rows affected (0.03 sec)


Create table DETIL FAKTUR

mysql> create table detil_faktur (
-> no_fak int(3),
-> kode_brg varchar(3),
-> kuantitas int(3),
-> foreign key (no_fak) references primary_faktur(no_fak) on update cascade,
-> foreign key (kode_brg) references barang(kode_brg) on update cascade);
Query OK, 0 rows affected (0.05 sec)


TO BE CONTINUED..