Perancangan Database dan ERD Aplikasi Toko Sepatu Online

ERD

Table Basis Data

1.     TabelPengguna.

Field	Data Type	Value
Id_pengguna	Number	10
Username	Text	50
Email	Text	50
Password	Varchar	15
Alamat	Text	50
No_telp	Text	15
Kd_level	Text	15

2.     Tabel Administrator.

Field	Data Type	Value
Username	Text	50
Password	Varchar	50
Kd_level	Text	15

3.     TabelBarang.

Field	Data Type	Value
Kd_brg	Number	5
Nma_brg	Text	50
Size	Varchar	15
Kate_brg	Text	50
Hrga_brg	Number	50

                     

4.     Tabel Order.

Field	Data Type	Value
Size	Varchar	15
Jmlh_brg	Number	Longer Integer
Kate_brg	Text	50
Hrga_brg	Number	50

                                

5.     TabelTestimoni.

Field	Data Type	Value
Username	Text	50
Email	Text	50
Kota	Text	50
Komentar	Text	Longer Integer