Perancangan Database

Tabel Tempat :

FIELD	TYPE	SIZE	KETERANGAN
Id_tempat	Int	5	Primary key
Id_agama	Int	1	Foreign key
Nama_tempat	Varchar	100	-
Alamat	Varchar	200	-
No_hp	Varchar	12	-
Gambar1	Varchar	200	-
Gambar2	Varchar	200	-
Gambar3	Varchar	200	-
Username	Varchar	50

Table kegiatan :

FIELD	TYPE	SIZE	KETERANGAN
Id_kegiatan	Int	5	Primary key
Id_tempat	Int	5	Foreign key
Nama_kegiatan	Varchar	100	-
Hari	Varchar	20	-
Jam	Date/time		-
Keterangan	Text		-
Username	Varchar	50

Table admin :

FIELD	TYPE	SIZE	KETERANGAN
Id_admin	Int	3	Primary key
Username	Varchar	50	Primary key
Password	Varchar	100	-
Active	Enum	1	-

Table agama :

FIELD	TYPE	SIZE	KETERANGAN
Id_agama	Int	1	Primary key
Nama_agama	Varchar	10	-
Img_agama	Varchar	50	-

Relasi Tabel :