Membuat database dan tabel pada Visual Foxpro
Langkah – langkah
1. Buat sebuah project dan diberi nama sistem_gaji
2. Klik tanda (+) di folder Data, klik folder Database dan pilih New
3. Klik New Database dan beri nama dbsisgaji
4. Pada database designer dbsisgaji klik kanan dan pilih new table
5. Beri nama absen
6. Masukkan field – field berikut!
7. Pilih tab indexes dan masukkan idxabsen dikolom name, Type pilih primary dan ketik/pilih nokartu untuk expression.
8. Klik tombol OK sehingga table absen muncul pada database designer
9. Buat pula table – table berikut!
a. Table pegawai
Name | Type | Width |
Nip | Character | 9 |
Nama | Character | 35 |
Jenis_kelamin | Character | 12 |
Alamat | Character | 35 |
Status | Character | 12 |
File indexnya
Name : idxpegawai
Type : primary
Expression : nip
b. Table bagian
Name | Type | Width |
Kdbag | Character | 4 |
Namabag | Character | 15 |
Gapok | Numeric | 12 Dec-nya 0 |
Gajiperhari | Numeric | 12 Dec-nya 0 |
File indexnya
Name : idxbagian
Type : primary
Expression : kdbag
c. Table memiliki
Name | Type | Width |
Nokartu | Character | 7 |
Nip | Character | 9 |
Blnthn | Character | 4 |
Tglabsen | Date | 8 |
Ketabsen | Character | 10 |
File indexnya
Name : idxmilik
Type : primary
Expression : nokartu+nip+blnthn+DTOC(tglabsen)
d. Table gaji
Name | Type | Width |
Nokartu | Character | 7 |
Nip | Character | 9 |
Blnthn | Character | 4 |
Tglgaji | Date | 8 |
Potongan | Numeric | 12 Dec-nya 0 |
File indexnya
Name : idxgaji
Type : primary
Expression : nokartu+nip+blnthn
e. Table total_absen
Name | Type | Width |
Nokartu | Character | 7 |
Nip | Character | 9 |
Blnthn | Character | 4 |
Ttlmsk | Numeric | 3 Dec-nya 0 |
Ttltakmsk | Numeric | 3 Dec-nya 0 |
File indexnya
Name : idxtlabsen
Type : primary
Expression : nokartu+nip+blnthn
f. Table terima
Name | Type | Width |
Nokartu | Character | 7 |
Nip | Character | 9 |
Blnthn | Character | 4 |
Tglgaji | Date | 8 |
Potongan | Numeric | 12 Dec-nya 0 |
File indexnya
Name : idxterima
Type : primary
Expression :nokartu+ nip+blnthn
g. Table berada
Name | Type | Width |
Nip | Character | 9 |
Kdbag | Character | 4 |
Tglmulai | Date | 8 |
Sk | Character | 20 |
File indexnya
Name : idxberada
Type : primary
Expression : nip
0 komentar:
Posting Komentar