Rancangan Struktur table dan menuentukan primary key, foreign key
Tabel User
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
User_name
|
Varchar
|
20
|
no
|
-
|
Primary key
|
2
|
Password
|
Varchar
|
20
|
no
|
-
|
Tabel tarif denda
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
Jumlah_hari_maksimal
|
Number
|
10
|
no
|
-
|
Primary key
|
2
|
Jumlah_denda
|
Number
|
10
|
no
|
-
|
