TUGAS SISTEM MANAGEMENT BASIS DATA
“
SISTEM INFORMASI PANTI ASUHAN(SIPAS) “
Oleh :
Alfiandri 121051128
Syafrizal
Ardiansyah 121051125
Enggar
Febriyanti 121051092
Adib
Arwanda Kusuma 121051072
Deny
Ardyrusmarryya 121051106
Jurusan Teknik Informatika
Fakultas
Teknologi Industri
Institut
Sains dan Teknologi AKPRIND Yogyakarta
2013/2014
Rancangan
Struktur Tabel Database yang di gunakan dalam bentuk 3NF
Sub
Master Pendataan :
Tabel
User
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
User_name
|
varchar
|
20
|
no
|
-
|
primary key
|
2
|
password
|
varchar
|
20
|
no
|
-
|
-
|
3
|
Level_user
|
char
|
1
|
no
|
5
|
1 = Admin, 2 = Administrasi keuangan, 3 = Investaris, 4 = Ketua
yayasan
|
Data_pengurus
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_pengurus
|
number
|
10
|
no
|
-
|
primary key
|
2
|
nama_lengkap
|
varchar
|
50
|
no
|
-
|
-
|
3
|
ID_jabatan
|
char
|
1
|
no
|
-
|
foreign key
|
4
|
tanggal_lahir
|
date
|
-
|
no
|
-
|
-
|
5
|
jenis_kelamin
|
char
|
1
|
no
|
2
|
L = laki - laki, P = perempuan
|
6
|
asal
|
varchar
|
20
|
no
|
-
|
-
|
7
|
alamat_sekarang
|
varchar
|
50
|
no
|
-
|
-
|
8
|
golongan_darah
|
char
|
2
|
no
|
4
|
A ,B, AB, O
|
9
|
pendidikan_terakhir
|
char
|
1
|
no
|
7
|
1 = TK, 2 = SD, 3 = SMP, 4 = SMA/SMK, 5 = S1, 6 = S2, 7 = S3
|
10
|
nama_ptn
|
varchar
|
40
|
no
|
-
|
-
|
11
|
jurusan/bidang
|
varchar
|
30
|
no
|
-
|
-
|
12
|
tahun_tamat
|
number
|
4
|
no
|
-
|
-
|
Data_anak_panti
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_anak
|
number
|
10
|
no
|
-
|
primary key
|
2
|
nama_lengkap
|
varchar
|
50
|
no
|
-
|
-
|
3
|
tanggal_lahir
|
date
|
-
|
no
|
-
|
-
|
4
|
jenis_kelamin
|
char
|
1
|
no
|
2
|
L = laki - laki, P = perempuan
|
5
|
asal
|
varchar
|
20
|
no
|
-
|
-
|
6
|
alamat_sekarang
|
varchar
|
50
|
no
|
-
|
-
|
7
|
golongan_darah
|
char
|
2
|
no
|
4
|
A, B, AB, O
|
8
|
anak_ke
|
number
|
2
|
no
|
-
|
-
|
9
|
dari
|
number
|
2
|
no
|
-
|
-
|
10
|
status_tinggal
|
varchar
|
20
|
no
|
-
|
-
|
Data_adobsi
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_pengadobsi
|
number
|
10
|
no
|
-
|
primary key
|
2
|
ID_anak_panti
|
number
|
10
|
no
|
-
|
primary key / foreign key
|
3
|
ID_mengetahui
|
number
|
10
|
no
|
-
|
primary key / foreign key
|
4
|
nama_pengadobsi
|
varchar
|
50
|
no
|
-
|
-
|
5
|
jenis_kelamin
|
char
|
1
|
no
|
2
|
L = laki - laki, P = perempuan
|
6
|
alamat_pengadobsi
|
varchar
|
50
|
no
|
-
|
-
|
7
|
pekerjaan_pengadobsi
|
varchar
|
50
|
no
|
-
|
-
|
8
|
status_pengadobsi
|
char
|
1
|
no
|
3
|
1 = kawin, 2 = belum kawin, 3 = berpisah
|
9
|
no_tlp
|
number
|
12
|
no
|
-
|
-
|
10
|
tanggal_adobsi
|
date
|
-
|
no
|
-
|
-
|
11
|
alasan_adobsi
|
varchar
|
150
|
no
|
-
|
-
|
Data_donatur
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_donatur
|
number
|
10
|
no
|
-
|
primary key
|
2
|
nama_donatur
|
varchar
|
50
|
no
|
-
|
-
|
3
|
alamat_donatur
|
varchar
|
50
|
no
|
-
|
-
|
4
|
jenis_donatur
|
char
|
1
|
no
|
3
|
1 = perseorangan, 2 = kelompok, 3 = perusahaan
|
5
|
no_telfon
|
varchar
|
12
|
no
|
-
|
-
|
6
|
status_donatur
|
char
|
1
|
no
|
2
|
1 = tetap, 2 = tidak tetap
|
Data_pendidikan
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_anak
|
number
|
10
|
no
|
-
|
primary key / foreign key
|
2
|
NISN
|
number
|
10
|
no
|
-
|
primary key
|
3
|
nama_sekolah
|
varchar
|
50
|
no
|
-
|
-
|
4
|
tingkatan
|
char
|
1
|
no
|
7
|
1 = TK, 2 = SD, 3 = SMP, 4 = SMA/SMK, 5 = S1, 6 = S2, 7 = S3
|
5
|
tahun_pendidikan
|
number
|
4
|
no
|
-
|
-
|
6
|
jurusan/bidang
|
varchar
|
30
|
no
|
-
|
-
|
7
|
alamat_sekolah
|
varchar
|
60
|
no
|
-
|
-
|
8
|
no_tkp_sekolah
|
varchar
|
12
|
no
|
-
|
-
|
Prestasi_anak_asuh
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_anak_asuh
|
number
|
10
|
no
|
-
|
primary key
|
2
|
nama_anak
|
varchar
|
40
|
no
|
-
|
-
|
3
|
kategori_lomba
|
varchar
|
30
|
no
|
-
|
-
|
4
|
bidang_lomba
|
varchar
|
30
|
no
|
-
|
-
|
5
|
tingkat_lomba
|
varchar
|
50
|
no
|
-
|
-
|
6
|
tanggal_tahun
|
date
|
-
|
no
|
-
|
-
|
Sub
Administrasi Keuangan :
Bantuan_barang&uang
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_bantuan
|
number
|
10
|
no
|
-
|
primary key
|
2
|
ID_barang
|
number
|
10
|
no
|
-
|
primary key / foreign key
|
3
|
nama_barang
|
varchar
|
40
|
no
|
-
|
-
|
4
|
jenis_barang
|
char
|
1
|
no
|
3
|
1 = sembako, 2 = pakaian, 3 = peralatan
|
5
|
jumlah_barang
|
number
|
6
|
no
|
-
|
-
|
6
|
jumlah_uang
|
number
|
12
|
no
|
-
|
-
|
7
|
tanggal_masuk
|
date
|
no
|
-
|
-
|
|
8
|
ID_donatur
|
number
|
10
|
no
|
-
|
primary key / foreign key
|
9
|
ID_penerima
|
number
|
10
|
no
|
-
|
primary key / foreign key
|
10
|
nama_penerima
|
varchar
|
50
|
no
|
-
|
-
|
Data_barang
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_barang
|
number
|
10
|
no
|
-
|
primary key
|
2
|
nama_barang
|
varchar
|
40
|
no
|
-
|
-
|
3
|
jenis_barang
|
char
|
1
|
no
|
3
|
1 = sembako, 2 = pakaian, 3 = peralatan
|
4
|
jumlah_barang
|
number
|
6
|
no
|
-
|
-
|
5
|
jumlah_uang
|
number
|
12
|
no
|
-
|
-
|
6
|
tanggal_masuk
|
date
|
-
|
no
|
-
|
-
|
Pengeluaran_barang&uang
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
ID_keluar
|
number
|
10
|
no
|
-
|
primary key
|
ID_barang
|
number
|
10
|
no
|
-
|
foreign key
|
nama_barang
|
varchar
|
40
|
no
|
-
|
-
|
jenis_barang
|
char
|
1
|
no
|
3
|
1 = Sembako, 2 = Pakaian, 3 = Peralatan
|
jumlah_barang
|
number
|
6
|
no
|
-
|
-
|
jumlah_uang
|
number
|
12
|
no
|
-
|
-
|
tanggal_keluar
|
date
|
-
|
no
|
-
|
-
|
keperluan
|
varchar
|
100
|
no
|
-
|
-
|
ID_mengetahui
|
number
|
10
|
no
|
-
|
foreign key
|
nama_mengetahui
|
varchar
|
50
|
no
|
-
|
-
|
Data_gaji
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
|
1
|
ID_jabatan
|
char
|
1
|
no
|
8
|
1 = kepala, 2 = wakil kepala, 3 = sekretaris, 4 = bendahara, 5 =
pengasuh, 6 = asisten rumah tangga, 7 = supir, 8 = satpam
|
2
|
jumlah_gaji
|
char
|
1
|
no
|
8
|
1 = Rp. 4.000.000, 2 = Rp. 3.500.000, 3 = Rp. 3.000.000, 4 = Rp.
3.000.000, 5 = Rp. 2.500.000, 6 = Rp. 1.500.000, 7 = 1.000.000, 7 = 1.000.000
|
Sub
Investaris :
Inventaris_barang
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_inventaris
|
number
|
10
|
no
|
-
|
primary key
|
2
|
ID_barang
|
number
|
10
|
no
|
-
|
foreign key
|
3
|
nama_barang
|
varchar
|
40
|
no
|
-
|
-
|
4
|
keadaan_barang
|
char
|
1
|
no
|
2
|
1 = baik, 2 = rusak
|
5
|
kegunaan_barang
|
varchar
|
100
|
no
|
-
|
-
|
6
|
tanggal_penggunaan
|
date
|
-
|
no
|
-
|
-
|
7
|
tanggal_rusak
|
date
|
-
|
no
|
-
|
-
|
Peminjam_inventaris
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_peminjam
|
number
|
10
|
no
|
-
|
primary key
|
2
|
ID_barang
|
number
|
10
|
no
|
-
|
foreign key
|
3
|
ID_mengetahui
|
number
|
10
|
no
|
-
|
foreign key
|
4
|
nama_peminjam
|
varchar
|
30
|
no
|
-
|
-
|
5
|
jenis_kelamin
|
char
|
1
|
no
|
2
|
L = laki - laki, P = perempuan
|
6
|
alamat_peminjam
|
varchar
|
50
|
no
|
-
|
-
|
7
|
no_tlp_peminjam
|
varchar
|
12
|
no
|
-
|
-
|
8
|
tanggal_pinjam
|
date
|
-
|
no
|
-
|
-
|
9
|
keperluan_peminjaman
|
varchar
|
100
|
no
|
-
|
-
|
Pengembalian_inventaris
No
|
Nama Field
|
Tipe
|
Ukuran
|
Null
|
Default
|
Keterangan
|
1
|
ID_peminjam
|
number
|
10
|
no
|
-
|
primary key
|
2
|
ID_barang
|
number
|
10
|
no
|
-
|
foreign key
|
3
|
ID_mengetahui
|
number
|
10
|
no
|
-
|
foreign key
|
4
|
nama_peminjam
|
varchar
|
30
|
no
|
-
|
-
|
5
|
jenis_kelamin
|
varchar
|
1
|
no
|
2
|
L = Laki - laki, P = Perempuan
|
6
|
alamat_peminjam
|
varchar
|
50
|
no
|
-
|
-
|
7
|
no_tlp_peminjam
|
varchar
|
12
|
no
|
-
|
-
|
8
|
tanggal_kembali
|
date
|
-
|
no
|
-
|
-
|
user
|
user_name *
|
password
|
level_user
|
