Tbl data kerja karyawan Query | GOL | GAJI PERBULAN | UANG MAKAN | LEMBUR PERJAM | Total Uanglembur | Total Uangmakan | Total Penerimaan |
| 1 | 300000 | 5000 | 5000 | 15000 | 130000 | 445000 |
| 2 | 600000 | 6000 | 7500 | 0 | 162000 | 762000 |
| 4 | 6000000 | 9000 | 12500 | 50000 | 207000 | 6257000 |
| 2 | 600000 | 6000 | 7500 | 30000 | 150000 | 780000 |
| 1 | 300000 | 5000 | 5000 | 35000 | 105000 | 440000 |
| 3 | 900000 | 7000 | 10000 | 0 | 196000 | 1096000 |
| 3 | 900000 | 7000 | 10000 | 110000 | 133000 | 1143000 |
| 1 | 300000 | 5000 | 5000 | 5000 | 140000 | 445000 |
| 1 | 300000 | 5000 | 5000 | 25000 | 110000 | 435000 |
| 2 | 600000 | 6000 | 7500 | 7500 | 162000 | 769500 |
Tabel Data Kerja Karyawan Query2 | JAM LEMBUR |
| 3 |
| 0 |
| 4 |
| 4 |
| 7 |
| 0 |
| 11 |
| 1 |
| 5 |
| 1 |
Tabel Data Kerja Karyawan Query1 | HARI KERJA |
| 26 |
| 27 |
| 23 |
| 25 |
| 21 |
| 28 |
| 19 |
| 28 |
| 22 |
| 27 |
Tabel Data Kerja Karyawan_XI.AK2 Query | BULAN |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
| MAR 2000 |
TABEL DATA KARYAWAN_ XI AK2 Query5 | JABATAN |
| SEKRETARIS |
| SALESMAN |
| DIREKTUR |
| MANAGER |
| SATPAM |
| SEKRETARIS |
| MANAGER |
| RESEPSIONIS |
| SALESMAN |
| SEKRETARIS |
TABEL DATA KARYAWAN_XI AK2 Query4 | NAMA KARYAWAN |
| GINA |
| TEGUH |
| ERDANA |
| NANA |
| IKHSAN |
| AIRIN |
| FERRY |
| ANANTA |
| ADE |
| WIWIN |
TABEL DATA KARYAWAN_ XI AK2 Query2 | NIP |
| 2001 |
| 2002 |
| 2003 |
| 2004 |
| 2005 |
| 2006 |
| 2007 |
| 2008 |
| 2009 |
| 2010 |
TABEL DATA KARYAWAN_IKMAH XI AK2 Query1 | NIP | NAMA KARYAWAN | TGL LAHIR | JK | TPK | JABATAN | GOL | ALAMAT | KOTA | KP | TLP | FOTO | KET |
| 2001 | GINA | 02/03/1976 | P | D1 | SEKRETARIS | 1 | Jl Tampomas 23 | CIREBON | 45142 | 205981 |
|
|
| 2002 | TEGUH | 25/01/1975 | L | SMA | SALESMAN | 2 | Jl Kelud 48 | KUNINGAN | 32524 | 324015 |
|
|
| 2003 | ERDANA | 08/03/1956 | L | S3 | DIREKTUR | 4 | Jl Ariodinoto 10 | CIREBON | 45111 | 207847 |
|
|
| 2004 | NANA | 11/11/1965 | P | S2 | MANAGER | 2 | Jl Pengampon 10 | SUKABUMI | 52132 | 542015 |
|
|
| 2005 | IKHSAN | 31/08/1972 | L | SMA | SATPAM | 1 | Jl Pekalipan 62 | GARUT | 26678 | 230339 |
|
|
| 2006 | AIRIN | 21/11/1970 | P | D3 | SEKRETARIS | 3 | Jl Titimplik 32 | BANDUNG | 40135 | 357984 |
|
|
| 2007 | FERRY | 27/02/1965 | L | S1 | MANAGER | 3 | Jl Klitiran 27 | BANDUNG | 40133 | 365214 |
|
|
| 2008 | ANANTA | 17/01/1976 | P | D1 | RESEPSIONIS | 1 | Jl Dr Cipto 59 | JAKARTA | 16114 | 654354 |
|
|
| 2009 | ADE | 25/06/1975 | L | SMA | SALESMAN | 1 | Jl Siliwangi 125 | KUNINGAN | 16752 | 642517 |
|
|
| 2010 | WIWIN | 12/02/1973 | P | D1 | SEKRETARIS | 2 | Jl Nanas 90 | JAKARTA | 34567 | 326984 |
|
|
TABEL DATA KARYAWAN_XI AK2 Query Query2 | Total penerimaan |
| 445000 |
| 762000 |
| 6257000 |
| 780000 |
| 440000 |
| 1096000 |
| 1143000 |
| 445000 |
| 435000 |
| 769500 |
TABEL DATA KARYAWAN_XI AK2 Query Query1 | Total uang makan |
| 130000 |
| 162000 |
| 207000 |
| 150000 |
| 105000 |
| 196000 |
| 133000 |
| 140000 |
| 110000 |
| 162000 |
TABEL DATA KARYAWAN_ XI AK2 Query Query | Total uang lembur |
| 15000 |
| 0 |
| 50000 |
| 30000 |
| 35000 |
| 0 |
| 110000 |
| 5000 |
| 25000 |
| 7500 |
TABEL DATA KARYAWAN_IKMAH XI AK2 Query | NIP | NAMA KARYAWAN | TGL LAHIR | JK | TPK | JABATAN | GOL | ALAMAT | KOTA | KP | TLP | FOTO | KET | Total uang lembur | Total uang makan | Total penerimaan |
| 2001 | GINA | 02/03/1976 | P | D1 | SEKRETARIS | 1 | Jl Tampomas 23 | CIREBON | 45142 | 205981 |
|
| 15000 | 130000 | 445000 |
| 2002 | TEGUH | 25/01/1975 | L | SMA | SALESMAN | 2 | Jl Kelud 48 | KUNINGAN | 32524 | 324015 |
|
| 0 | 162000 | 762000 |
| 2003 | ERDANA | 08/03/1956 | L | S3 | DIREKTUR | 4 | Jl Ariodinoto 10 | CIREBON | 45111 | 207847 |
|
| 50000 | 207000 | 6257000 |
| 2004 | NANA | 11/11/1965 | P | S2 | MANAGER | 2 | Jl Pengampon 10 | SUKABUMI | 52132 | 542015 |
|
| 30000 | 150000 | 780000 |
| 2005 | IKHSAN | 31/08/1972 | L | SMA | SATPAM | 1 | Jl Pekalipan 62 | GARUT | 26678 | 230339 |
|
| 35000 | 105000 | 440000 |
| 2006 | AIRIN | 21/11/1970 | P | D3 | SEKRETARIS | 3 | Jl Titimplik 32 | BANDUNG | 40135 | 357984 |
|
| 0 | 196000 | 1096000 |
| 2007 | FERRY | 27/02/1965 | L | S1 | MANAGER | 3 | Jl Klitiran 27 | BANDUNG | 40133 | 365214 |
|
| 110000 | 133000 | 1143000 |
| 2008 | ANANTA | 17/01/1976 | P | D1 | RESEPSIONIS | 1 | Jl Dr Cipto 59 | JAKARTA | 16114 | 654354 |
|
| 5000 | 140000 | 445000 |
| 2009 | ADE | 25/06/1975 | L | SMA | SALESMAN | 1 | Jl Siliwangi 125 | KUNINGAN | 16752 | 642517 |
|
| 25000 | 110000 | 435000 |
| 2010 | WIWIN | 12/02/1973 | P | D1 | SEKRETARIS | 2 | Jl Nanas 90 | JAKARTA | 34567 | 326984 |
|
| 7500 | 162000 |
|
TABEL DAFTAR UPAH KARYAWAN_XIAK2 Query4 | LEMBUR PERJAM |
| 5000 |
| 7500 |
| 10000 |
| 12500 |
TABEL DAFTAR UPAH KARYAWAN XIAK2 Query3 | UANG MAKAN |
| 5000 |
| 6000 |
| 7000 |
| 9000 |
TABEL DAFTAR UPAH KARYAWAN_ XIAK2 Query2 | GAJI PERBULAN |
| 300000 |
| 600000 |
| 900000 |
| 6000000 |
TABEL DAFTAR UPAH KARYAWAN_ XIAK2 Query1 | GOL |
| 1 |
| 2 |
| 3 |
| 4 |
