PERANCANGAN TABEL

Þ    ERD (Entity Relatinship Diagram)

Þ    Tabel Database

§  Tabel Pengolahan

Nama File            : Pengolahan

Primary Key       : Nopengolahan

                               Notbs

                               Kd_jad

No.	Field	Tipe Data	Lenght	PrimaryKey	AutoIncrement
1.	Nopengolahan	Integer	30	*	*
2.	No_tbs	Integer	30	*	*
3.	Kd_unit	Integer	30
4.	Nm_unit	Varchar	30
5.	Tgl	Date	30
6.	Jml_sed	Integer	30
7.	Kd_jad	Integer	30	*	*
8.	Waktu	Date	30
9.	Diolah	Varchar	30
10.	Kdbb	Varchar	30	*	*
11.	Bb	Varchar	30
12.	Jmlmis	Integer	30
13.	Total	Integer	30

·         Tabel Detail Kirim

Nama File             : Detail Kirim

Primary Key        : Nopengiriman

                                Nopengolahan

No.	Field	Tipe Data	Lenght	PrimaryKey	AutoIncrement
1.	Nopengiriman	Integer	30	*	*
2.	Nopengolahan	Integer	30	*	*
3.	Tgl	Date	30
4.	Jmlmis	Integer	30

·         Tabel Pengiriman

Nama File             : Pengiriman

Primary Key        : Nopengiriman

No.	Field	Tipe Data	Lenght	PrimaryKey	AutoIncrement
1.	Nopengiriman	Integer	30	*	*
2.	Tgl	Date	30
3.	Tujuan	Varchar	30
4.	Total	Integer	30

·         Tabel Data TBS

Nama File             : Data TBS

Primary Key        : Notbs

                                Kd_unit

No.	Field	Tipe Data	Lenght	PrimaryKey	AutoIncrement
1.	Notbs	Integer	30	*	*
2.	Kd_unit	Integer	30	*	*
3.	Nm_unit	Varchar	30
4.	Tgl	Date	30
5.	Jml_terima	Integer	30
6.	Sisa_kirim	Integer	30

·         Tabel Unit Usaha

Nama File             : Unit Usaha

Primary Key        : Kd_unit

No.	Field	Tipe Data	Lenght	PrimaryKey	AutoIncrement
1.	Kd_unit	Integer	30	*	*
2.	Nm_unit	Varchar	30
3.	Alamat	Text	30
4.	Telp	Integer	30

·         Tabel Jip

Nama File             : Jip

Primary Key        : Kdjad

No.	Field	Tipe Data	Lenght	PrimaryKey	AutoIncrement
1.	Kdjad	Integer	30	*	*
2.	Waktu	Date	30
3.	Diolah	Varchar	30

·         Tabel Bb

Nama File             : Bb

Primary Key        : Kdbb

No.	Field	Tipe Data	Lenght	PrimaryKey	AutoIncrement
1.	Kdbb	Varchar	30	*	*
2.	Bb	Varchar	30

Þ    Relasi Antar Tabel