|
|
Baris 767: |
Baris 767: |
| | | |
| =<div style="font-family: 'times new roman'; text-align: center">'''BAB III'''</div>= | | =<div style="font-family: 'times new roman'; text-align: center">'''BAB III'''</div>= |
− | <h2 align="center"><span style="font-family: times new roman, times;"><strong>PEMBAHASAN</strong></span></h2> | + | <h2 align="center"><span style="font-family: times new roman, times;"><strong>TUJUAN DAN MANFAAT PENELITIAN</strong></span></h2> |
− | <h2><span style="font-family: times new roman, times;"><strong>Gambaran Umum Organisasi</strong></span></h2>
| + | ====Tujuan Penelitian==== |
− | <h3><span style="font-family: times new roman, times;"><strong>Sejarah Singkat</strong></span></h3>
| + | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Tujuan Penelitian ini adalah agar dapat Mempermudah Pribadi Raharja serta Calon Mahasiswa baru dalam menggunakan serta memanfaatkan pelayanan iDuHelp!. Maka dari itu penelitian yang dilakukan sangatlah berkaitan. Tujuan dari sebuah penelitian merupakan suatu hal yang perlu diperhatikan karena dapat menciptakan penelitian yang sangat bermanfaat untuk semua orang. Berikut penulis sudah membentuk 3 (tiga) tujuan penelitian, diantaranya yaitu : |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Desa Kemiri terbentuk soejak 1944 yang pada masa waktu itu Desa Kemiri merupakan bagian dari wilayah Kecamatan Kemiri, adapun pada waktu itu Desa Kemiri pertama kali dipimpin oleh seorang pahlawan dan sebagai Panutan masyarakat yang bernama Bapak Mbah Enjong (Penjol) beliau memimpin kepemerintahan Desa Kemiri dari tahun 1943 –1947. Kemudian digantikan oleh H. Ajid dari tahun 1947-1955 Pada Tahun 1967 pergantian kepemimpinan terjadi dengan menggunakan sistem Demokrasi, , dan yang terpilih menjadi Kepala Desa adalah Bapak Nawawi (1967 – 1977). Pada Tahun berikutnya Pergantian kepemimpinan terjadi dengan menggunakan sistem Demokrasi, dan yang terpilih menjadi Kepala Desa adalah Bapak H.M. Rasbih (1979 – 1989 ).Pada tahun 1989 masa jabatan Kepala Desa telah habis dan diganti oleh H. M. Suhardi untuk Periode 1989-1998, namun waktu terus berlalu dan tiba kembali untuk pemilihan kepala desa dan pada waktu pemilihan terdapatlah kepala desa baru lagi yaitu H.M. Rasbih untuk masa bakti 1999-2007 terpilih kembali menjadi kades Kemiri, Pada tahun 2007 H.M Suhardi kembali terpilih untuk menjadi Kepala Desa Kemiri sampai jabatan kades berakhir, pemilihan kepala desa kemiri kembali dilaksanakan kembali pada tahun 2010 dan yang terpilih untuk memimpin desa kemiri masa bakti 2010 – 2016 adalah Bapak Nanang Rusmana. Setelah masa jabatan Bapak Nanang Rusmana berakhir, untuk sementara Desa Kemiri dipimpin oleh Penjabat Kepala Desa dari pihak Kecamatan yaitu Bapak Makmun, SP. M.Si. Pada Tahun 2017 saudara Jamaludin terpilih sebagai kepala Desa baru periode 2017-2023</span></p>
| + | |
− | <h3><span style="font-family: times new roman, times;"><strong>Struktur Organisasi</strong></span></h3>
| + | |
− | <p align="center"> </p>
| + | |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.postimg.cc/QxdShYSj/struktur-organisasi.png" alt="Struktur Organisasi" width="540" height="208" /></p>
| + | |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.1 Struktur Organisasi</strong></span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Struktur organisasi pada gambar 3.1 merupakan hal yang sangat penting yang dimiliki suatu organisasi karena memiliki fungsi-fungsi manajemen sehingga suatu organisasi dapat dijalankan dengan baik dan lancar.</span></p> | + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Organisasi merupakan kesatuan aktivitas di mana para pimpinan mempunyai wewenang untuk mengkoordinasi kegiatan dengan maksud untuk mancapai tujuan suatu organisasi. Dengan organisasi yang efektif, maka setiap bagian organisasi mengetahui wewenang dan tugas yang menjadi tanggung jawabnya masing-masing. Dengan demikian hubungan kerja dalam organisasi pemerintahan akan dapat dikoordinasikan dengan baik.</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Struktur organisasi tercermin dalam satu bagian organisasi yang menunjukan adanya pembagian tugas dan wewenang serta aturan dan prosedur yang ada termasuk komunikasi arus kerja.</span></p>
| + | |
− | <h3><span style="font-family: times new roman, times;"><strong>Tugas dan Tanggung Jawab</strong></span></h3>
| + | |
− | <p><span style="font-family: times new roman, times;">Adapun kedudukan, tugas pokok dan fungsi dari masing-masing bagian sebagai berikut:</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">1. Kepala Desa</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala Desa berkedudukan sebagai Kepala Pemerintah Desa yang memimpin penyelenggaraan Pemerintahan Desa.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala Desa bertugas menyelenggarakan Pemerintahan Desa, melaksanakan pembangunan, pembinaan kemasyarakatan, dan pemberdayaan masyarakat.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Menyelenggarakan Pemerintahan Desa, seperti tata praja Pemerintahan, penetapan peraturan di desa, pembinaan masalah pertanahan, pembinaan ketentraman dan ketertiban, melakukan upaya perlindungan masyarakat, administrasi kependudukan, dan penataan dan pengelolaan wilayah.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Melaksanakan pembangunan, seperti pembangunan sarana prasarana perdesaan, dan pembangunan bidang pendidikan, kesehatan.</span></li>
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Pembinaan kemasyarakatan, seperti pelaksanaan hak dan kewajiban masyarakat, partisipasi masyarakat, sosial budaya masyarakat, keagamaan, dan ketenagakerjaan.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Pemberdayaan masyarakat, seperti tugas sosialisasi dan motivasi masyarakat di bidang budaya, ekonomi, politik, lingkungan hidup, pemberdayaan keluarga, pemuda, olahraga, dan karang taruna.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Menjaga hubungan kemitraan dengan lembaga masyarakat dan lembaga lainnya</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">2. Sekretaris Desa</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Sekretaris Desa berkedudukan sebagai unsur pimpinan Sekretariat Desa.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Sekretaris Desa bertugas membantu Kepala Desa dalam bidang administrasi pemerintahan.</span></li>
| + | |
− | </ol>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Melaksanakan urusan ketatausahaan seperti tata naskah, administrasi surat menyurat, arsip, dan ekspedisi.</span></li>
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Melaksanakan urusan umum seperti penataan administrasi perangkat desa, penyediaan prasarana perangkat desa dan kantor, penyiapan rapat, pengadministrasian aset, inventarisasi, perjalanan dinas, dan pelayanan umum.</span></li>
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Melaksanakan urusan keuangan seperti pengurusan administrasi keuangan, administrasi sumber-sumber pendapatan dan pengeluaran, verifikasi administrasi keuangan, dan admnistrasi penghasilan Kepala Desa, Perangkat Desa, BPD, dan lembaga pemerintahan desa lainnya.</span></li>
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Melaksanakan urusan perencanaan seperti menyusun rencana anggaran pendapatan dan belanja desa, menginventarisir data-data dalam rangka pembangunan, melakukan monitoring dan evaluasi program, serta penyusunan laporan.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">3. Kepala Urusan Tata Usaha dan Umum</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala urusan bertugas membantu Sekretaris Desa dalam urusan pelayanan administrasi pendukung pelaksanaan tugas-tugas pemerintahan.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Kepala urusan tata usaha dan umum memiliki fungsi seperti melaksanakan urusan ketatausahaan seperti tata naskah, administrasi surat menyurat, arsip, dan ekspedisi, dan penataan administrasi perangkat desa, penyediaan prasarana perangkat desa dan kantor, penyiapan rapat, pengadministrasian aset, inventarisasi, perjalanan dinas, dan pelayanan umum.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">4. Kepala urusan keuangan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala urusan bertugas membantu Sekretaris Desa dalam urusan pelayanan administrasi pendukung pelaksanaan tugas-tugas pemerintahan.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Kepala urusan keuangan memiliki fungsi seperti melaksanakan urusan keuangan seperti pengurusan administrasi keuangan, administrasi sumber-sumber pendapatan dan pengeluaran, verifikasi administrasi keuangan, dan admnistrasi penghasilan Kepala Desa, Perangkat Desa, BPD, dan lembaga pemerintahan desa lainnya.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">5. Kepala Urusan Perencanaan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala urusan bertugas membantu Sekretaris Desa dalam urusan pelayanan administrasi pendukung pelaksanaan tugas-tugas pemerintahan</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Kepala urusan perencanaan memiliki fungsi mengoordinasikan urusan perencanaan seperti menyusun rencana anggaran pendapatan dan belanja desa, menginventarisir data-data dalam rangka pembangunan, melakukan monitoring dan evaluasi program, serta penyusunan laporan.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">6. Kepala Seksi Pemerintahan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala seksi bertugas membantu Kepala Desa sebagai pelaksana tugas operasional.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Kepala seksi pemerintahan mempunyai fungsi melaksanakan manajemen tata praja Pemerintahan, menyusun rancangan regulasi desa, pembinaan masalah pertanahan, pembinaan ketentraman dan ketertiban, pelaksanaan upaya perlindungan masyarakat, kependudukan, penataan dan pengelolaan wilayah, serta pendataan dan pengelolaan Profil Desa.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">7. Kepala Seksi Kesejahteraan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala seksi bertugas membantu Kepala Desa sebagai pelaksana tugas operasional.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Kepala seksi kesejahteraan mempunyai fungsi melaksanakan pembangunan sarana prasarana perdesaan, pembangunan bidang pendidikan, kesehatan, dan tugas sosialisasi serta motivasi masyarakat di bidang budaya, ekonomi, politik, lingkungan hidup, pemberdayaan keluarga, pemuda, olahraga, dan karang taruna.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">8. Kepala Seksi Pelayanan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Kepala seksi bertugas membantu Kepala Desa sebagai pelaksana tugas operasional.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Kepala seksi pelayanan memiliki fungsi melaksanakan penyuluhan dan motivasi terhadap pelaksanaan hak dan kewajiban masyarakat, meningkatkan upaya partisipasi masyarakat, pelestarian nilai sosial budaya masyarakat, keagamaan, dan ketenagakerjaan.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">9. Kepala Wilayah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"> Tugas :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Kepala Kewilayahan atau sebutan lainnya berkedudukan sebagai unsur satuan tugas kewilayahan yang bertugas membantu Kepala Desa dalam pelaksanaan tugasnya di wilayahnya.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"> Fungsi :</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Pembinaan ketentraman dan ketertiban, pelaksanaan upaya perlindungan masyarakat, mobilitas kependudukan, dan penataan dan pengelolaan wilayah.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Mengawasi pelaksanaan pembangunan di wilayahnya.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Melaksanakan pembinaan kemasyarakatan dalam meningkatkan kemampuan dan kesadaran masyarakat dalam menjaga lingkungannya.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Melakukan upaya-upaya pemberdayaan masyarakat dalam menunjang kelancaran penyelenggaraan pemerintahan dan pembangunan</span></li>
| + | |
− | </ol>
| + | |
− | <p> </p>
| + | |
− | ===Visi dan Misi Desa Kemiri Kecamatan Kemiri===
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;"> Visi adalah suatu gambaran yang menantang tentang keadaan masa depan yang diinginkan dengan melihat potensi dan kebutuhhan desa. Penyusunan Visi Desa Kemiri ini dilakukan dengan pendekatan partisipatif, melalui penelusuran wilayah ( Transek ) analisis potensi,peluang, dan hambatan yang ada atau mungkin timbul melibatkan pihak-pihak yang berkepentingan di Desa Kemiri seperti pemerintah Desa, LPM, Tokoh Masyarakat, Tokoh Agama, lembaga masyarakat desa dan masyarakat desa pada umumnya. Dan melalui hasil musyawarah di tingkat desa berdasarkan pertimbangan di atas sepakat menetapkan Visi Desa Kemiri adalah :</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;"><strong> </strong>“ Mewujudkan Desa Kemiri sebagai Desa yang maju, Mandiri dan sejahtera, yang mengedepankan pelayanan Publik yang prima dan Transparan, serta lingkungan Masyarakat yang aman dan beriman.”</span></p>
| + | |
− | | + | |
− | <span style="font-family: times new roman, times;"><strong>Misi </strong></span>
| + | |
− | | + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;"> Selain penyusunan Visi juga telah ditetapkan misi-misi yang memuat sesuatu pernyataan yang harus dilaksanakan oleh Desa/Kelurahan agar tercapainya visi desa tersebut. Visi berada di atas Misi. Pernyataan Visi kemudian dijabarkan kedalam misi agar dapat dioperasionalkan / dikerjakan. Sebagaimana penyusunan Visi, misipun dalam penyusunan menggunakan pendekatan partisipatif dan pertimbangan potensi dan kebutuhan Desa Kemiri, sebagaimana proses yang dilakukan maka misi Desa Kemiri adalah:</span></p>
| + | |
| <ol> | | <ol> |
− | <li><span style="font-family: times new roman, times;">Mewujudkan kualitas pelayanan kepada masyarakat yang prima,cepat,tepat,teliti dan transparan.</span></li> | + | <li>Untuk meneliti apakah pelayanan iDuHelp! masih terdapat kekurangan.</li> |
− | <li><span style="font-family: times new roman, times;">Meningkatkan kinerja tata pemerintahan kelurahan menuju Good Governance.</span></li> | + | <li>Untuk meneliti apakah Pribadi Raharja Mengalami Kesulitan menggunakan serta memanfaatkan Pelayanan iDuHelp! yang disediakan oleh Universitas Raharja.</li> |
− | <li><span style="font-family: times new roman, times;">Meningkatkan peran aktif masyarakat dalam pelaksanaan pemerintahan, pembangunan, kesejahteraan di kelurahan.</span></li>
| + | <li>Untuk membantu meningkatkan kualitas pelayanan iDuHelp!.</li> |
− | <li><span style="font-family: times new roman, times;">Meningkatkan pengelolaan sarana prasarana di kelurahan</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Mewujudkan SDM yang terampil, mandiri, beriman, dan bertaqwa.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Mewujudkan pelayanan informasi kepada masyarakat.</span></li> | + | |
| </ol> | | </ol> |
− | <h2><span style="font-family: times new roman, times;"><strong>Tata Laksana Sistem Yang Berjalan </strong></span></h2>
| + | </span></p> |
− | <h3><span style="font-family: times new roman, times;"><strong>Prosedur Sistem Yang Berjalan</strong></span></h3>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Berdasarkan analisa yang dilakukan pada Kantor Kepala Desa Kemiri, sistem informasi administrasi pelayanan penduduk yang sedang berjalan saat ini dalam proses pengolahan data masih belum optimal, karena belum terintegrasi dan terkomputerisasi, sehingga pengolahan data belum diperoleh secara cepat, tepat dan akurat serta belum berjalan secara efektif dan efisien.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Adapun mekanisme sistem yang berjalan di Kantor Kepala Desa Kemiri sebagai berikut:</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">1. Prosedur Registrasi</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Masyarakat datang langsung ke Kantor Kepala Desa dan menyerahkan form surat pengantar dari RT kepada staff pelayanan untuk diproses sesuai permintaan yang diminta pada form surat yang diberikan masyarakat.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">2. Prosedur pembuatan surat</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Pembuatan surat dilakukan oleh staff pelayanan yang bertugas dalam proses pembuatan surat yang diminta masyarakat. Dengan menggunakan Microsoft office word dan Microsoft office excel.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">3. Prosedur Pencetakan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Surat yang sudah selesai dibuat kemudian dicetak, dan selanjutnya akan diserahkan kepada Lurah untuk diperiksa dan dilegitimasi.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">4. Prosedur Legitimasi</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Proses legitimasi masih dilakukan oleh staff pelayanan dengan menyerahkan surat yang sudah jadi kepada Lurah untuk di tandatangani dan di stampel, sebelum diserahkan kepada masyarakat.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">5. Prosedur Laporan</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Laporan dilakukan oleh Sekretariat dengan menyimpan berkas asli surat pengantar RT yang diserahkan masyarakat, kemudian di catat dalam buku register sesuai dengan jenis dan tanggal surat masuk dan keluar</span></p>
| + | |
− | <h3><span style="font-family: times new roman, times;"><strong>Analisa Prosedur Sistem Yang Berjalan</strong></span></h3>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Penelitian ini mengguankan program Unified Modelling Language (UML) dalam menggambarkan proses yang sedang berjalan, dan beberapa diagram yang digunakan diantaranya use case diagram, sequence diagram, dan activity diagram.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;"><strong>1. Analisa Sistem Yang Berjalan Pada Use Case Diagram</strong></span></p>
| + | |
− | <p align="center"> </p>
| + | |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/mDTCVh5T/use-case-berjalan.png" alt="use case berjalan" width="360" height="319" /></p>
| + | |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.2 Use Case Diagram</strong></span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar 3.2. Use Case Diagram sistem yang berjalan saat ini terdapat:</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Terdapat 3 (empat) Actor yang dapat melakukan kegiatan didalam sistem, diantaranya yaitu Warga, Staff pelayanan, dan Lurah/Sekdes.</span></li>
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">6 (enam) Use Case yang dapat dilakukan oleh Actor tersebut, diantaranya Membawa berkas, Memeriksa Kelengkapan berkas, Membuat Surat yang dibutuhkan, Cetak Surat , Meminta Legalisir dan TTD Surat, Surat Pengantar Selesai.</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"><strong>2. Analisa Sistem Yang Berjalan Pada Activity Diagram</strong></span></p>
| + | |
− | <p align="center"> </p>
| + | |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/JhxGrxpW/activity-berjalan.png" alt="use case berjalan" width="360" height="319" /></p>
| + | |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.3 Activity Diagram</strong></span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar 3.3. Activity Diagram yang berjalan saat ini terdapat:</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">1 (satu) Initial Node, model yang diawali.</span></li>
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">8 (delapan) Action State yang dimulai dari Membawa berkas, menyerahkan berkas, Memeriksa Kelengkapan berkas, Membuat Surat yang dibutuhkan, Cetak Surat, Meminta Legalisir dan TTD Surat, Legalisir dan TTD Surat, Surat Pengantar Selesai.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">1 (satu) Final State, objek yang diakhiri dengan pemohon menerima surat</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;"><strong>3. Analisa Sistem Yang Berjalan Pada Sequence Diagram</strong></span></p>
| + | |
− | <p> </p>
| + | |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/k5JQ54P6/sequence-berjalan.png" alt="sequence berjalan" width="529" height="373" /></p>
| + | |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.4 Sequence Diagram Sistem yang berjalan</strong></span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar 3.4. Sequence Diagram yang berjalan saat ini terdapat:</span></p>
| + | |
− | <ol style="list-style-type: lower-alpha;">
| + | |
− | <li><span style="font-family: times new roman, times;">Terdapat 3 (tiga) Actor yang melakukan kegiatan, diantaranya Warga, Staff pelayanan, Lurah</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">2 (dua) Lifeline antarmuka yang saling berinteraksi, diantaranya berkas, dan Surat.</span></li>
| + | |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">9 (sembilan) Message dari komunikasi antar objek yang memuat informasi-informasi yang dilakukan oleh actor, diantaranya Membawa berkas, Memeriksa berkas, Menyerahkan berkas, Membuat Surat, Cetak Surat, Meminta Legalisir dan TTD Surat, Memberikan Surat, Surat Selesai.</span></li>
| + | |
− | </ol>
| + | |
− | <h2><span style="font-family: times new roman, times;"><strong>Analisa Sistem Yang Berjalan</strong></span></h2>
| + | |
− | <h3><span style="font-family: times new roman, times;"><strong>Metode Analisa PIECES</strong></span></h3>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Pada metode analisa sistem, disajikan tabel untuk mengidentifikasi sistem yang berjalan saat ini, untuk melihat secara keseluruhan sistem sehingga dapat diusulkan perbaikannya.Berikut ini tabel perbandingan dari sistem yang berjalan dengan sistem yang diusulkan untuk Kantor Kepala Desa Kemiri.</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Disajikan tabel untuk mengidentifikasi sistem yang berjalan saat ini, untuk melihat secara keseluruhan sistem sehingga dapat diusulkan perbaikannya ke dalam tabel seperti di bawah ini:</span></p>
| + | |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Tabel 3.1 Analisa Pieces</strong></span></p>
| + | |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/jqHV7xWq/tabel-pieces1.png" alt="tabel pieces" width="306" height="567" /></p>
| + | |
− | <p style="text-align: center;"> <img src="https://i.postimg.cc/nLjgcpbJ/tabel-pieces2.png" alt="tabel pieces" width="320" height="574" /></p>
| + | |
− | ===Metode Analisa Masukan, Analisa Proses, Analisa Keluaran===
| + | |
− | <ol>
| + | |
− | <li><span style="font-family: times new roman, times;">Analisa Masukan</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">a. Nama masukan : Surat Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Mengetahui informasi data penduduk</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Sumber : RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Frekuensi : Setiap ada yang mengajukan surat pengantar</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keterangan : Surat Pengantar RT didapat dari RT pada saat akan pengajuan surat ke Kantor Desa.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">b. Nama masukan : Keterangan Acara</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Mengetahui informasi acara yang akan dilaksanakan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Sumber : Pemohon</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Frekuensi : Setiap ada yang mengajukan surat izin keramaian</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keterangan : Keterangan acara didapat dari pemohon yang akan mengajukan surat ke Kantor Desa.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">c. Nama masukan : Kartu Keluarga</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Mengetahui informasi data penduduk</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Sumber : Pemohon</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Frekuensi : Setiap ada yang mengajukan Pengantar KTP, dan Resi Ktp</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keterangan : Kartu Keluarga didapat dari pemohon yang akan mengajukan surat ke Kantor Desa.</span></p>
| + | |
− | <ol start="2">
| + | |
− | <li><span style="font-family: times new roman, times;">Analisa Proses</span></li>
| + | |
− | </ol>
| + | |
− | <p><span style="font-family: times new roman, times;">a. Nama Modul : KTP Sementara</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Surat Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : Resi KTP</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Ringkasan Proses: Proses ini menghasilkan Resi KTP yang digunakan sebagai Informasi Identitas Penduduk yang berisi informasi nama, Nomor Kartu Keluarga, Nomor Induk Keluarga dan alamat .</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">b. Nama modul : Keterangan Tinggal Penduduk</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Domisili Tinggal</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Domisili Tinggal yang digunakan untuk informasi tinggal penduduk berdasarkan Keterangan Pengantar RT yang telah dinyatakan oleh RT.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">c. Nama Modul : Keterangan Domisili Usaha</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Domisili Usaha</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Domisili Usaha yang digunakan sebagai informasi domisili tempat usaha bahwa penduduk tersebut benar memiliki usaha ditempat yang dimaksud.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">d. Nama Modul : Keterangan Izin Keramaian</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT, Keterangan Acara</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Izin Keramaian</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Izin Keramaian yang digunakan sebagai informasi izin melakukan kegiatan keramaian dan sebagai pengantar pada pihak yang berwajib.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">e. Nama Modul : Keterangan kelahiran</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Keluaran : SK Kelahiran</span></p>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Kelahiran yang digunakan sebagai informasi Kelahiran dan sebagai pengantar pembuat akta kelahiran pada dinas kependudukan dan catatan sipil.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">f. Nama Modul : Keterangan Kematian</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Kematian</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Kematian yang digunakan sebagai Pengantar pada Dinas Kependudukan dan catatan sipil.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">g. Nama Modul : Keterangan Memiliki Rumah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Memiliki Rumah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK memiliki Rumah yang digunakan sebagai pengantar untuk melakukan kredit rumah dll.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">h. Nama Modul : Master KTP</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Pengantar KTP</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Pengantar KTP yang digunakan sebagai pengantar untuk membuat E-Ktp</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">i. Nama Modul : Pengantar Nikah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Pengantar Nikah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Pengantar Nikah yang digunakan sebagai pengantar untuk daftar nikah pada KUA</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">j. Nama Modul : Pengantar Pindah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Pengantar Pindah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Pengantar Pindah yang digunakan sebagai pengantar pada kecamatan</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">k. Nama Modul : Pengantar SKCK</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Pengantar SKCK</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Pengantar SKCK yang digunakan sebagai pengantar untuk membuat SKCK pada Polsek.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">l. Nama Modul : Keterangan Tidak Mampu</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Tidak Mampu</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK Tidak Mampu yang digunakan sebagai syarat pengajuan beasiswa, bantuan pemerintah dll.</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">m. Nama Modul : Keterangan Usaha</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Masukan : Pengantar RT</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Keluaran : SK Usaha</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Ringkasan Proses : Proses ini menghasilkan SK usahayang digunakan sebagai pengantar untuk menerbitkan keterangan usaha pada kecamatan.</span></p>
| + | |
| | | |
− | <p><span style="font-family: times new roman, times;"> 3. Analisa Keluaran</span></p>
| + | ====Manfaat Penelitian==== |
− | <p><span style="font-family: times new roman, times;">a. Nama Keluaran : Resi KTP</span></p>
| + | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Setiap penelitian yang dilakukan tentunya diharapkan dapat memberikan manfaat untuk semua orang. Manfaat |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai KTP sementara</span></p>
| + | penelitian merupakan sebuah sasaran akhir dari tujuan yang diinginkan dengan menjawab rumusan masalah dengan tepat dan akurat. Berikut 3 (tiga) manfaat yang diharapkan dari penelitian ini, antara lain: |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap: 3</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi : Pemohon, Kecamatan, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">b. Nama Keluaran : SK Domisili Tinggal</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai Keterangan tempat tinggal pemohon</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p> | + | |
− | <p><span style="font-family: times new roman, times;">Rangkap : 2</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi : Pemohon, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">c. Nama Keluaran : SK Domisili Usaha</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai Pengantar untuk mengajukan Keterangan Tempat Usaha pada kecamatan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap: 2</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi: Pemohon , Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">d. Nama Keluaran : SK Izin Keramaian</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai Keterangan izin mengadakan acara</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap : 4</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi : Pemohon,Polsek,Kecamatan, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">e. Nama Keluaran : SK Memiliki Rumah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : sebagai pengantar untuk melakukan kredit rumah.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap : 2</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi : Pemohon, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">f. Nama Keluaran : SK Kelahiran</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai Pengantar untuk mengajukan Akta Kelahiran</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap: 2</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi: Pemohon , Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">g. Nama Keluaran : SK Kematian</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai pengantar untuk melapor pada kecamatan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap : 2</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi : Pemohon, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">h. Nama Keluaran : SK Pengantar KTP</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai Pengantar untuk mengajukan E-Ktp pada kecamatan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap: 3</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi: Pemohon ,Kecamatan, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">i. Nama Keluaran : SK Pengantar Nikah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai pengantar Syarat Pendaftaran Nikah pada KUA</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap : 3</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi : Pemohon, KUA, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">j. Nama Keluaran : SK Pengantar Pindah</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai Pengantar untuk mengajukan Pindah pada kecamatan</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap: 3</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi: Pemohon ,Kecamatan, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">k. Nama Keluaran : SK Pengantar SKCK</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : Sebagai Pengantar Syarat untuk membuat keterangan perilaku baik pada polsek</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap : 3</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi : Pemohon, Polsek, Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">l. Nama Keluaran : SK Tidak Mampu</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : sebagai syarat pengajuan beasiswa, bantuan pemerintah dll.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap: 2</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi: Pemohon , Arsip</span></p>
| + | |
− | <p> </p>
| + | |
− | <p><span style="font-family: times new roman, times;">m. Nama Keluaran : SK Usaha</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Fungsi : sebagai pengantar untuk menerbitkan keterangan usaha pada kecamatan.</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Media : Kertas</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Rangkap: 3</span></p>
| + | |
− | <p><span style="font-family: times new roman, times;">Distribusi: Pemohon ,Kecamatan, Arsip</span></p>
| + | |
− | <h2><span style="font-family: times new roman, times;"><strong>Konfigurasi Sistem Berjalan</strong></span></h2>
| + | |
− | <h4><span style="font-family: times new roman, times;"><strong>Spesifikasi Hardware</strong></span></h4>
| + | |
− | <p><span style="font-family: times new roman, times;">Sistem tersebut menggunakan 2 unit komputer PC dengan spesifikasi sebagai berikut:</span></p>
| + | |
| <ol> | | <ol> |
− | <li><span style="font-family: times new roman, times;">Processor : Intel(R) Core(TM) i3-2120</span></li> | + | <li>Dengan adanya Mobile Apps iDuHelp! ini diharapkan Pribadi Raharja dapat terbantu seputar permasalahan yang dialami serta memberikan informasi kepada Pribadi Raharja seputar kampus.</li> |
− | <li><span style="font-family: times new roman, times;">Monitor : LED</span></li> | + | <li>Customer iDuHelp! juga dapat menggunakan gadget Smartphone ketika mendapat suatu problem yang harus ditanyakan kepada iDuHelp!, sehingga Customer juga tidak perlu lagi Menggunakan PC/Laptop ketika ingin bertanya.</li> |
− | <li><span style="font-family: times new roman, times;">Ram : 2048 MB</span></li> | + | <li>Diharapkan Pribadi Raharja serta Calon Mahasiswa Baru, mengetahui layanan ini dan dapat memanfaatkan pelayanan yang telah diberikan oleh kampus.</li> |
− | <li><span style="font-family: times new roman, times;">Keyboard : Qwerty</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Mouse : Optical</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Printer : Inkjet</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Windows 7</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Microsoft Office 2007</span></li>
| + | |
| </ol> | | </ol> |
− | <h4><span style="font-family: times new roman, times;"><strong>Spesifikasi Software</strong></span></h4>
| + | </span></p> |
− | <h2><span style="font-family: times new roman, times;">P<strong>ermasalahan yang dihadapi dan Alternatif Pemecahan Masalah</strong></span></h2>
| + | |
− | <h3><span style="font-family: times new roman, times;"><strong>Permasalahan yang dihadapi</strong></span></h3>
| + | |
− | <p><span style="font-family: times new roman, times;">Berdasarkan observasi yang dilakukan dapat disimpulkan permasalahan yang ada sebagai berikut:</span></p>
| + | |
− | <ol>
| + | |
− | <li><span style="font-family: times new roman, times;">Pembuatan Surat-surat masih menggunakan <i>microsoft word</i>.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Sulitnya menemukan file surat yang akan dibuat karena kesalahan dalam penyimapanan nama file dan data isi surat tidak akurat.</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Tidak dapat diketahui informasi jumlah warga yang mengajukan surat-surat karena dalam registrasi masih dicatat secara manual menggunakan buku.</span></li>
| + | |
− | </ol>
| + | |
− | <h3><span style="font-family: times new roman, times;"><strong>Alternatif Pemecahan Masalah</strong></span></h3>
| + | |
− | <p><span style="font-family: times new roman, times;">Berdasarkan analisa permasalahan yang telah dijabarkan maka ditemukan alternatif pemecahan masalah sebagai berikut :</span></p>
| + | |
− | <ol>
| + | |
− | <li><span style="font-family: times new roman, times;">Pembuatan Surat-surat dapat diedit dan disimpan dengan menggunakan sistem berbasis web</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Sistem berbasis web dapat dijadikan media penyimpanan Surat-surat yang dibutuhkan</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Sistem berbasis web dapat memberi informasi mengenai jumlah yang mengajukan surat-surat</span></li>
| + | |
− | <li><span style="font-family: times new roman, times;">Sistem berbasis web dapat diakses oleh Staff Pelayanan, Sekretariat, dan Kepala Desa</span></li>
| + | |
− | </ol>
| + | |
− | <h2><span style="font-family: times new roman, times;"><strong>User Requirement</strong></span></h2>
| + | |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Elisitasi <i>(Elicitation)</i> adalah berisi usulan rancangan sistem baru yang diinginkan oleh pihak manajemen terkait dan disanggupi oleh penulis. Elistasi didapat melalui metode wawancara dan dilakukan melalui tiga tahap, yaitu sebagai berikut :</span></p>
| + | |
− | <h3><span style="font-family: times new roman, times;"><strong>Elisitasi Tahap I</strong></span></h3>
| + | |
− | <p><span style="font-family: times new roman, times;">Elisitasi tahap I, berisi seluruh rancangan sistem baru yang diusulkan oleh pihak manajemen terkait melalui proses wawancara.</span></p>
| + | |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Tabel 3.2 Elisitasi tahap I</strong></span></p>
| + | |
− | <p> </p>
| + | |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/YCyKxqHJ/elis0.jpg." alt="elisitasi 1" width="307" height="574" /></p>
| + | |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/5ymDQfgK/elis01.jpg" alt="elisitasi 1" width="307" height="574" /></p>
| + | |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/J73f2Q83/elis02.jpg" alt="elisitasi 1" width="307" height="280" /></p>
| + | |
| | | |
− |
| |
− | <h3><span style="font-family: times new roman, times;"><strong></strong><strong>Elisitasi Tahap II</strong></span></h3>
| |
− | <p><span style="font-family: times new roman, times;">Elisitasi tahap II merupakan hasil pengklasifikasian dari elisitasi tahap I berdasarkan metode MDI. Berikut lampiran elisitasi tahap II yang telah dibuat.<strong></strong></span></p>
| |
− | <p style="text-align: center;"><span style="font-family: times new roman, times;"><strong>Tabel 3.3 Elisitasi Tahap II</strong></span></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/fWvPKT7B/elis20.jpg" alt="elisitasi2" width="315" height="568" /></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/vBsPrpcJ/elis211.jpg" alt="elisitasi2" width="316" height="574" /></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/Wz9XPzXV/elis212.jpg" alt="elisitasi2" width="316" height="361" /></p>
| |
− |
| |
− | <ul>
| |
− | <li><span style="font-family: times new roman, times;">Keterangan:</span></li>
| |
− | </ul>
| |
− | <p><span style="font-family: times new roman, times;">M (<em>Mandatory</em>) : Penting atau dibutuhkan</span></p>
| |
− | <p><span style="font-family: times new roman, times;">D (<em>Desirable</em>) : Diinginkan tapi tidak terlalu penting</span></p>
| |
− | <p><span style="font-family: times new roman, times;">I (<em>Inessential</em>) : Bukanlah bagian dari sistem dan dieliminasi</span></p>
| |
− | <h3><span style="font-family: times new roman, times;"><strong>Elisitasi Tahap III</strong></span></h3>
| |
− | <p><span style="font-family: times new roman, times;">Merupakan hasil penyusutan dari elisitasi tahap II dengan cara mengeliminasi semua requirement yang optionnya I pada metode MDI. Selanjutnya semua requirement yang tersisa diklasifikasikan kembali melalui metode TOE (<em>Technical, Operational, Economy</em>). Metode TOE tersebut dibagi kembali menjadi beberapa <em>option High. Middle, Low</em>.</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Tabel 3.4 Elisitasi Tahap III</strong></span></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/FRCLrS5T/elis311.jpg" alt="elisitasi3" width="403" height="588" /></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/Bn5P8kfL/elis312.jpg" alt="elisitasi3" width="404" height="587" /></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/tC3mTRJh/Screenshot-1.jpg" alt="elisitasi3" width="404" height="405" /></p>
| |
− |
| |
− | <p style="text-align: left;"><span style="font-family: times new roman, times;"><strong></strong>Keterangan :</span></p>
| |
− | <ul>
| |
− | <li><span style="font-family: times new roman, times;">T :<em>Technical</em> (Bagaimana tata cara / teknik pembuatan <em>requirement</em> tersebut dalam sistem yang diusulkan?)</span></li>
| |
− | <li><span style="font-family: times new roman, times;">O :<em>Operational</em> (Bagaimana tata cara penggunaan <em>requirement</em> tersebut dalam sistem yang akan dikembangkan?)</span></li>
| |
− | <li><span style="font-family: times new roman, times;">E :<em>Economy</em> (Berapakah biaya yang diperlukan guna membangun requirement tersebut didalam sistem?)</span></li>
| |
− | </ul>
| |
− | <h3><span style="font-family: times new roman, times;"><strong>Final Draft Elisitasi</strong><strong></strong></span></h3>
| |
− | <p><span style="font-family: times new roman, times;">Final draft merupakan hasil akhir yang dicapai dari suatu proses elisitasi yang dapat digunakan sebagai dasar pembuatan suatu sistem yang akan dikembangkan, maka menghasilkan requirement final draft elisitasi yang dapat ditunjukan pada tabel berikut :</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Tabel 3.5 Final Draft Elisitasi</strong></span></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/zvRS47bC/elisfinal.jpg" alt="final" width="340" height="623" /></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/7PCFxySV/elisfinal1.jpg" alt="final" width="340" height="583" /></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/fW66ygKh/elisfinal2.jpg" alt="final" width="341" height="348" /></p>
| |
− |
| |
− | <h2><span style="font-family: times new roman, times;"><strong>Rancangan Sistem Yang Diusulkan</strong></span></h2>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Setelah melakukan analisis dan penelitian dari sistem yang sedang berjalan pada Kelurahan Sukasari, selanjutnya akan membahas tentang rancangan sistem yang diusulkan yang dapat dijelaskan pada use case diagram, activity diagram, sequence diagram dan class diagram dengan menggunakan Visual Paradigm for UML 8.0 Enterprise Edition.</span></p>
| |
− | <h3><span style="font-family: times new roman, times;"><strong>Prosedur Sistem Usulan</strong><strong></strong></span></h3>
| |
− | <p><span style="font-family: times new roman, times;">Berikut beberapa prosedur yang harus dilakukan dalam menjalankan sistem pembuatan surat pengantar pada Kelurahan Sukasari yaitu :</span></p>
| |
− | <p><span style="font-family: times new roman, times;">1. Prosedur Login</span></p>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Untuk mengakses sistem, setiap pengguna diwajibkan melakukan proses login dengan mengisi username dan password sesuai dengan username dan password pengguna.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">2. Prosedur Input Data Pejabat</span></p>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Staff Pelayanan melakukan penginputan data pada form Master Pejabat sebagai pegawai yang memiliki kewenangan untuk melegalisir surat pengantar.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">3. Prosedur Input Data Penduduk</span></p>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Staff Pelayanan melakukan penginputan data pada form Master Penduduk sebagai sumber informasi penduduk yang mengajukan surat sesuai kebutuhan.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">4. Prosedur Transaksi</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Staff Pelayanan melakukan pembuatan surat sesuai kebutuhan penduduk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">5. Prosedur Cetak Surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Setelah proses penginputan data selesai dan disimpan, maka Staff Pelayanan dapat melakukan pencetakan surat tersebut.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">6. Prosedur Laporan</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Bagian Staff Pelayanan, Sekretariat, Kepala Desa dapat melihat dan mencetak laporan jika diperlukan.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">7. Prosedur Logout</span></p>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Bagian Staff Pelayanan, Sekretariat, Kepala Desa dapat melakukan proses logout atau keluar dari sistem setelah selesai melakukan proses pembuatan surat yang dibutuhkan atau aktivitas lainnya didalam sistem.<strong></strong></span></p>
| |
− | <h3><span style="font-family: times new roman, times;"><strong>Use Case Diagram yang diusulkan</strong><strong></strong></span></h3>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Diagram Use Case adalah sebuah diagram yang digunakan untuk menunjukkan tampilan grafis dari fungsionalitas yang diberikan oleh sistem dilihat dari sisi aktor, tujuan aktor, dan hal yang berkaitan dengan use case yang ada.</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.postimg.cc/QdngNvQQ/use-case-usulan.png" alt="use case usulan" width="529" height="415" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.5 Use Case sistem yang diusulkan</strong></span></p>
| |
− | <p> </p>
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar diatas, usecase diagram sistem Administrasi Pelayanan yang diusulkan terdapat :</span></p>
| |
− | <p><span style="font-family: times new roman, times;">a. 1 sistem yang mencakup seluruh kegiatan dalam proses penginputan.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">b. 3 actor yang melakukan kegiatan yaitu bagian Staff Pelayanan, Sekretariat, Desa, dan Kepala Desa.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">c. 7 usecase yang akan dilakukan oleh aktor tersebut, seperti login, Dashboard, Master, Transaksi, Utility, Logout.</span></p>
| |
− | <h3><span style="font-family: times new roman, times;"><strong></strong><strong>Activity Diagram yang diusulkan</strong><strong></strong></span></h3>
| |
− | <p><span style="font-family: times new roman, times;"><em>1. Activity</em> Diagram Staff Pelayanan</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.postimg.cc/0jcMWJZY/activity-usulan.png" alt="use Activity usulan" width="529" height="540" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.6 Activity Diagram sistem yang diusulkan untuk Staff pelayanan</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar Activity Diagram diatas, terdapat :</span></p>
| |
− | <ol style="list-style-type: lower-alpha;">
| |
− | <li><span style="font-family: times new roman, times;">1 initial node sebagai tanda yang mengawali objek</span></li>
| |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">41 action yang menggambarkan eksekusi pada saat login yaitu login, dashboard, View Dashboard, Transaksi, Master, Utility,Add, Edit, Delete, View, Print,logout, Master Pejabat, Master penduduk, Resi KTP, SK Domisili Tinggal, SK Domisili Usaha, SK Izin Keramaian, SK Kelahiran, SK Kematian, SK Memiliki Rumah, SK Pengantar KTP, SK Pengantar Nikah, SK Pengantar Pindah, SK Pengantar SKCK, SK Tidak Mampu, SK Usaha, Laporan Resi KTP, Laporan SK Domisili Tinggal, Laporan SK Domisili Usaha, SK Izin Keramaian, Laporan SK Kelahiran, Laporan SK Kematian, Laporan SK Memiliki Rumah, Laporan SK Pengantar KTP, Laporan SK Pengantar Nikah, Laporan SK Pengantar Pindah, Laporan SK Pengantar SKCK, Laporan SK Tidak Mampu, Laporan SK Usaha,</span></li>
| |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Decision Node menggambarkan pada saat melakukan login ada 2 kemungkinan yang pertama apabila login salah maka akan kembali ke login dan cek kembali username dan password dan apabila login benar maka akan tampil ke menu utama</span></li>
| |
− | <li><span style="font-family: times new roman, times;">6 Fork Node menggambarkan pembagian aktifitas tersebut.</span></li>
| |
− | <li><span style="font-family: times new roman, times;">1 Activity Final Node menjelaskan bahwa objek dibentuk</span></li>
| |
− | </ol>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><em>2. Activity</em> Diagram Sekretariat</span></p>
| |
− |
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.postimg.cc/tTbs9zMd/activity-usulan-sekre.png" alt="use Activity usulan" width="529" height="540" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.7 Activity Diagram sistem yang diusulkan untuk Sekretariat</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar Activity Diagram diatas, terdapat :</span></p>
| |
− | <ol style="list-style-type: lower-alpha;">
| |
− | <li><span style="font-family: times new roman, times;">1 initial node sebagai tanda yang mengawali objek</span></li>
| |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">26 action yang menggambarkan eksekusi pada saat login yaitu login, dashboard, View Dashboard, Master, Utility,Add, Edit, Delete, View, Print,logout, Master Pejabat, Master penduduk, Laporan Resi KTP, Laporan SK Domisili Tinggal, Laporan SK Domisili Usaha, SK Izin Keramaian, Laporan SK Kelahiran, Laporan SK Kematian, Laporan SK Memiliki Rumah, Laporan SK Pengantar KTP, Laporan SK Pengantar Nikah, Laporan SK Pengantar Pindah, Laporan SK Pengantar SKCK, Laporan SK Tidak Mampu, Laporan SK Usaha,</span></li>
| |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Decision Node menggambarkan pada saat melakukan login ada 2 kemungkinan yang pertama apabila login salah maka akan kembali ke login dan cek kembali username dan password dan apabila login benar maka akan tampil ke menu utama</span></li>
| |
− | <li><span style="font-family: times new roman, times;">5 Fork Node menggambarkan pembagian aktifitas tersebut.</span></li>
| |
− | <li><span style="font-family: times new roman, times;"> 1 Activity Final Node menjelaskan bahwa objek dibentuk</span></li>
| |
− | </ol>
| |
− | <p> </p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"> <em>3. Activity</em> Diagram Kepala Desa</span></p>
| |
− | <p> </p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.postimg.cc/RhVqHZ9N/activity-usulan-kades.png" alt="use Activity usulan" width="529" height="540" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.8 Activity Diagram sistem yang diusulkan untuk Kepala Desa</strong></span></p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar Activity Diagram diatas, terdapat :</span></p>
| |
− | <ol style="list-style-type: lower-alpha;">
| |
− | <li><span style="font-family: times new roman, times;">1 initial node sebagai tanda yang mengawali objek</span></li>
| |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">24 action yang menggambarkan eksekusi pada saat login yaitu login, dashboard, View Dashboard, Master, Utility,Add, Edit, Delete, View, Print,logout, Laporan Resi KTP, Laporan SK Domisili Tinggal, Laporan SK Domisili Usaha, SK Izin Keramaian, Laporan SK Kelahiran, Laporan SK Kematian, Laporan SK Memiliki Rumah, Laporan SK Pengantar KTP, Laporan SK Pengantar Nikah, Laporan SK Pengantar Pindah, Laporan SK Pengantar SKCK, Laporan SK Tidak Mampu, Laporan SK Usaha,</span></li>
| |
− | <li style="text-align: justify;"><span style="font-family: times new roman, times;">Decision Node menggambarkan pada saat melakukan login ada 2 kemungkinan yang pertama apabila login salah maka akan kembali ke login dan cek kembali username dan password dan apabila login benar maka akan tampil ke menu utama</span></li>
| |
− | <li><span style="font-family: times new roman, times;">4 Fork Node menggambarkan pembagian aktifitas tersebut.</span></li>
| |
− | <li><span style="font-family: times new roman, times;">1 Activity Final Node menjelaskan bahwa objek dibentuk<strong></strong></span></li>
| |
− | </ol>
| |
− |
| |
− | <h3><span style="font-family: times new roman, times;"><strong></strong><strong>Sequence Diagram yang diusulkan</strong></span></h3>
| |
− | <p><span style="font-family: times new roman, times;"><strong> 1. </strong><strong>Squence Diagram Staff Pelayanan</strong></span></p>
| |
− |
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/MKLXnwLp/sequence.png" alt="perbedaan" width="450" height="500" /></p>
| |
− |
| |
− |
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.9 Sequence Diagram sistem yang diusulkan untuk Staff Pelayanan</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar sequence diagram yang diusulkan terdapat :</span></p>
| |
− | <p><span style="font-family: times new roman, times;">a. 7 Lifeline antarmuka yang saling berinteraksi.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">b. 1 actor yang melakukan kegiatan yaitu Staff pelayanan</span></p>
| |
− | <p><span style="font-family: times new roman, times;">c. 38 message yang berawal dari tampilan Login yang terdiri dari Input Username dan Password, Verifikasi login, Dashboard, Menu Master view Master Pejabat,View Master Penduduk, Menu Transaksi, Validasi Surat Pengantar RT, Buat Surat dan Simpan, View Surat dan Cetak Surat, View Laporan, Update Profile, Change Password, Logout.</span></p>
| |
− | <p> </p>
| |
− | <p> </p>
| |
− | <p><span style="font-family: times new roman, times;"> <strong> 2. Sequence Diagram Sekretariat</strong></span></p>
| |
− |
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/9QTTVzfh/sequence-sekre.png" alt="sequence " width="450" height="500" /></p>
| |
− |
| |
− |
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.10 Sequence Diagram sistem yang diusulkan untuk Sekretariat </strong><strong></strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar sequence diagram yang diusulkan terdapat :</span></p>
| |
− | <p><span style="font-family: times new roman, times;">a. 7 Lifeline antarmuka yang saling berinteraksi.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">b. 1 actor yang melakukan kegiatan yaitu Staff pelayanan</span></p>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">c. 22 message yang berawal dari tampilan Login yang terdiri dari Input Username dan Password, Verifikasi login, Dashboard, Menu Master view Master Pejabat,View Master Penduduk,View Laporan, Update Profile, Change Password, Logout.</span></p>
| |
− | <p> </p>
| |
− | <p> </p>
| |
− |
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><strong> 3. Sequence Diagram Kepala Desa</strong></span></p>
| |
− |
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/76LfCLqb/sequence-kades.png" alt="sequence " width="450" height="500" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.11 Sequence Diagram sistem yang diusulkan untuk Kepala Desa</strong><strong></strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan gambar sequence diagram yang diusulkan terdapat :</span></p>
| |
− | <p><span style="font-family: times new roman, times;">a. 7 Lifeline antarmuka yang saling berinteraksi.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">b. 1 actor yang melakukan kegiatan yaitu Staff pelayanan</span></p>
| |
− | <p><span style="font-family: times new roman, times;">c. 20 message yang berawal dari tampilan Login yang terdiri dari Input Username dan Password, Verifikasi login, Dashboard, View Laporan, Update Profile, Change Password, Logout.</span></p>
| |
− | <p> </p>
| |
− | <h2><span style="font-family: times new roman, times;"><strong>Perbedaan Sistem yang berjalan dan Sistem yang diusulkan</strong></span></h2>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/50BSgNFb/perbedaan.png" alt="perbedaan" width="424" height="237" /></p>
| |
− |
| |
− |
| |
− | ==Rancangan Basis Data==
| |
− | <p><span style="font-family: times new roman, times;"><strong><em>Class</em></strong><strong> Diagram</strong></span></p>
| |
− | <p style="text-align: center;"><img src="https://i.postimg.cc/bwHJ3nJs/class-diagram.png" alt="class diagram" width="550" height="500" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.12 Class Diagram</strong><strong></strong></span></p>
| |
− | Berdasarkan Gambar 3.12 Class Diagram diatas terdapat :<br>
| |
− | 1. Terdapat tiga belas Tabel Transaksi yang terhubung dengan dua tabel master
| |
− |
| |
− | ===Spesifikasi Basis Data===
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Rancangan database dipakai untuk mempermudah dalam proses penyeleksian data, serta membantu pemprograman dalam mengambil dan menampilkan data. Pada database digunakan tabel-tabel, dan pada tabel-tabel ini akan dijelaskan nama field, type dan size mengenai data tersebut.</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Tabel Master</strong><strong></strong></span></p>
| |
− | <p>1. Nama File : tbl_user</p>
| |
− | <p>Media : Hard Disk</p>
| |
− | <p>Isi : { no_user, user_login, nama, password, akses, profile }</p>
| |
− | <p>Primary Key : no_user</p>
| |
− | <p>Panjang Record : 500</p>
| |
− | <p align="center">Tabel 3.6 Tabel user</p>
| |
− | <div align="center">
| |
− | <table style="width: 491px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"> </p>
| |
− | <p align="center">No</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center">Nama Field</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">Type Data</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">Field Size</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center">Keterangan</p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">1</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>no_user</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">int</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Primary Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">2</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>user_login</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">150</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">3</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>nama</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">4</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>password</p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">5</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>akses</p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">150</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">6</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>profile</p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | </table>
| |
− | </div>
| |
− |
| |
− | <p>2. Nama File : tbl_form</p>
| |
− | <p>Media: Hard Disk</p>
| |
− | <p>Isi: id_form + views + nama_form + jns_form + ket_form</p>
| |
− | <p>Primary Key : id_form</p>
| |
− | <p>Panjang Record : 208</p>
| |
− | <p align="center">Tabel 3.7 Tabel form</p>
| |
− | <div align="center">
| |
− | <table style="width: 491px;" border="1" cellspacing="0" cellpadding="0">
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">No</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center">Nama Field</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">Type Data</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">Field Size</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center">Keterangan</p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">1</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>id_form</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">int</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">3</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Primary Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">2</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>views</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">3</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>nama_form</p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">150</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">4</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>jns_form</p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">5</p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center">5</p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p>ket_form</p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center">text</p>
| |
− | </td>
| |
− | <td width="83"> </td>
| |
− | <td width="131">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p><strong> </strong></p>
| |
− | <p> </p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;">3. Nama File : tbl_pejabat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nip + nama + alamat + rt + rw + no_telp+jabatan+status</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key : nip</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 209</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.8 Tabel Pejabat</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 491px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nama</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">alamat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">rt</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">rw</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">no_telp</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">13</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">jabatan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">status</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="131">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p style="text-align: left;" align="center"> </p>
| |
− | <p style="text-align: left;" align="center"><span style="font-family: times new roman, times;">4. Nama File: tbl_penduduk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nik + nama_lengkap + jenis_kelamin+tempat_lahir+tanggal_lahir + kp + rt + rw + desa + kec + kab + pekerjaan + agama +kewarganegaraan + goldar</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nik</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record: 332</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.9 Tabel Penduduk</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 500px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nama_lengkap</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">jenis_kelamin</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tempat_lahir</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_lahir</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">pekerjaan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">kp</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">rt</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">rw</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">desa</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">kec</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">12</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">kab</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">13</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">agama</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">14</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">kewarganegaraan</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">15</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">goldar</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="140">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p> </p>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Tabel transaksi</strong><strong></strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">1. Nama File: tbl_resi_ktp</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + nik + nomor_kk +tanggal_surat + berlaku_sampai + nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 192</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.10 Tabel Resi KTP</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 481px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;"> 10</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_kk</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">berlaku_sampai</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p><span style="font-family: times new roman, times;"> <em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p align="center"> </p>
| |
− | <p style="text-align: left;" align="center"><span style="font-family: times new roman, times;">2. Nama File: tbl_sk_domisili_tinggal</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + nomor_kk + berlaku_sampai + keperluan + nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record :202</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.11 Tabel SK Domisili Tinggal</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 481px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_kk</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">berlaku_sampai</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="121">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p><span style="font-family: times new roman, times;"> 3. Nama File: tbl_sk_domisili_usaha</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + nama + nomor_bapl + nama_perusahaan + jenis_perusahaan + notaris + no_akte + tgl_akte + alamat_perusahaan + stat_bangunan + luas_tanah + luas_bangunan + jml_kar + nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 912</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.12 Tabel SK Domisili Usaha</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 472px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_bapl</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nama_perusahaan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">jenis_perusahaan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">notaris</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">100</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">no_akte</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tgl_akte</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">alamat_perusahaan</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">500</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">luas_tanah</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">12</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">luas_bangunan</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">13</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">stat_bangunan</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">14</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">jml_kar</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">15</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">17</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">18</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">19</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <br>
| |
− | <p>4. Nama File: tbl_sk_izin_keramaian</p>
| |
− | <p>Media: Hard Disk</p>
| |
− | <p>Isi: nomor_surat + tanggal_surat + nik + tanggal_mulai + tanggal_selesai + kegiatan_keramaian + hiburan + nip + user_create + create_date + user_update + update_date</p>
| |
− | <p>Primary Key: nomor_surat</p>
| |
− | <p>Panjang Record : 196</p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.13 Tabel SK Izin Keramaian</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 481px;" border="1" cellspacing="0" cellpadding="0">
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">No</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p align="center">Nama Field</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Type Data</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">Field Size</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center">Keterangan</p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">1</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nomor_surat</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">30</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Primary Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">2</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>tanggal_surat</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Date</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">3</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nik</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Int</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">16</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Foreign Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">4</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nama_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">5</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>jk_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">6</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>tanggal_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">date</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">7</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>tempat_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">30</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">8</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>no_kk</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">16</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">9</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nama_ibu</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nip</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">20</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Foreign key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">11</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>user_create</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">12</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>create_update</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Datetime</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">13</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>user_update</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">1</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>update_date</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Datetime</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | </table>
| |
− | </div>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;">5. Nama File: tbl_sk_kematian</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + tanggal_kematian + nama_pelapor + hubungan + +sebab_kematian + keterangan + nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 436</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.14 Tabel SK Kematian</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 472px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_kematian</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nama_pelapor</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">hubungan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">100</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">sebab_kematian</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">100</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keterangan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">12</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">13</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p><span style="font-family: times new roman, times;">6. Nama File: tbl_sk_lahir_baru</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + nama_lahir + jk_lahir + tanggal_lahir + tempat_lahir + no_kk + nama_ibu + nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 332</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.15 Tabel SK Kelahiran</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 481px;" border="1" cellspacing="0" cellpadding="0">
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">No</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p align="center">Nama Field</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Type Data</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">Field Size</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center">Keterangan</p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">1</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nomor_surat</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">30</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Primary Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">2</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>tanggal_surat</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Date</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">3</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nik</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Int</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">16</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Foreign Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">4</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nama_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td style="text-align: center;" valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">5</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>jk_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td style="text-align: center;" valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">6</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>tanggal_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">date</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td style="text-align: center;" valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">7</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>tempat_lahir</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">30</p>
| |
− | </td>
| |
− | <td style="text-align: center;" valign="top" width="120">
| |
− | <p><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">8</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>no_kk</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">16</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">9</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nama_ibu</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>nip</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">20</p>
| |
− | </td>
| |
− | <td width="120">
| |
− | <p align="center"><em>Foreign key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">11</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>user_create</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">12</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>create_update</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Datetime</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">13</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>user_update</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="46">
| |
− | <p align="center">14</p>
| |
− | </td>
| |
− | <td width="147">
| |
− | <p>update_date</p>
| |
− | </td>
| |
− | <td width="90">
| |
− | <p align="center">Datetime</p>
| |
− | </td>
| |
− | <td width="80">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="120">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | </table>
| |
− | </div>
| |
− | <br>
| |
− | <p><span style="font-family: times new roman, times;">7. Nama File: tbl_sk_memiliki_rumah</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + berlaku_sampai + keperluan_surat + keterangan+ nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 386</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.16 Tabel SK Memiliki Rumah</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 472px;" border="1" cellspacing="0" cellpadding="0">
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">berlaku_sampai</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keperluan_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">200</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keterangan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p><span style="font-family: times new roman, times;">8. Nama File: tbl_pengantar_ktp</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + permohonan_ktp + keterangan+ nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 226</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.17 Tabel SK Pengantar KTP</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 472px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">Nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">permohonan_ktp</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keterangan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p><span style="font-family: times new roman, times;">9. Nama File: tbl_sk_pengantar_nikah</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + binti_bin + istri_suami_dahulu + berlaku_sampai + keterangan+ nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 366</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.18 tabel SK Pengantar Nikah</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 472px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">binti_bin</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">binti_bin</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">istri_suami_dahulu</span></p>
| |
− | </td>
| |
− | <td valign="top" width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">100</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">berlaku_sampai</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keterangan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">12</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">13</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p><span style="font-family: times new roman, times;">10. Nama File: tbl_sk_pengantar_pindah</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + nama_kepala_keluarga + nomor_kk + alamat_tujuan_pindah + jml_keluarga + alasan + keterangan+ nip+ user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 245</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.19 Tabel SK Pengantar Pindah</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 481px;" border="1" cellspacing="0" cellpadding="0">
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">No</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p align="center">Nama Field</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Type Data</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">Field Size</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center">Keterangan</p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">1</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>nomor_surat</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">30</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Primary Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">2</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>tanggal_surat</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Date</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">3</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>nik</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">16</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Foreign Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">4</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>nama_kepala_keluarga</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">5</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>nomor_kk</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">16</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">6</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>alamat_tujuan_pindah</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Text</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">7</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>jml_keluarga</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">3</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">8</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>alasan</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Text</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">9</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>nip</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">20</p>
| |
− | </td>
| |
− | <td width="117">
| |
− | <p align="center"><em>Foreign key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">10</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>user_create</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">11</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>create_date</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Datetime</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">12</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>user_update</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Varchar</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center">50</p>
| |
− | </td>
| |
− | <td valign="top" width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="43">
| |
− | <p align="center">13</p>
| |
− | </td>
| |
− | <td width="162">
| |
− | <p>update_date</p>
| |
− | </td>
| |
− | <td width="85">
| |
− | <p align="center">Datetime</p>
| |
− | </td>
| |
− | <td width="74">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="117">
| |
− | <p align="center"><em>Candidate Key</em></p>
| |
− | </td>
| |
− | </tr>
| |
− | </table>
| |
− | </div>
| |
− | <br>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;">11. Nama File: tbl_sk_pengantar_skck</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + berlaku_sampai + keperluan_skck + keterangan+ nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 186</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.20 Tabel SK Pengantar SKCK</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 472px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">berlaku_sampai</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keperluan_skck</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="83"> </td>
| |
− | <td valign="top" width="112">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keterangan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p> </p>
| |
− | <p><span style="font-family: times new roman, times;">12. Nama File: tbl_sk_tidak_mampu</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + berlaku_sampai + keperluan_sktm + keterangan + nip + user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 186</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.21 Tabel SK Tidak Mampu</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 472px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">berlaku_sampai</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keperluan_sktm</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">keterangan</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center">100</p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="47">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="139">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="92">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="83">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="112">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <p> </p>
| |
− | <p><span style="font-family: times new roman, times;">13. Nama File: tbl_sk_usaha</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Media: Hard Disk</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Isi: nomor_surat + tanggal_surat + nik + jenis_usaha + penghasilan_perbulan + alamat_tempat_usaha + keterangan+ user_create + create_date + user_update + update_date</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Primary Key: nomor_surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Panjang Record : 286</span></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Tabel 3.22 Tabel SK Usaha</span></p>
| |
− | <div align="center">
| |
− | <table style="width: 481px;" border="1" cellspacing="0" cellpadding="0">
| |
− |
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">No</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Nama Field</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Type Data</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Field Size</span></p>
| |
− | </td>
| |
− | <td width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Keterangan</span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">1</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">nomor_surat</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">30</span></p>
| |
− | </td>
| |
− | <td width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Primary Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">2</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">tanggal_surat</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Date</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">3</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">nik</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">16</span></p>
| |
− | </td>
| |
− | <td width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">4</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">jenis_usaha</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">100</span></p>
| |
− | </td>
| |
− | <td width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">5</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">penghasilan_perbulan</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td valign="top" width="118">
| |
− | <p><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">6</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">alamat_tempat_usaha</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">7</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">keterangan</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Text</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">8</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">nip</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">20</span></p>
| |
− | </td>
| |
− | <td width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Foreign key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">9</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">user_create</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">10</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">create_date</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">11</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">user_update</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Varchar</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"><span style="font-family: times new roman, times;">50</span></p>
| |
− | </td>
| |
− | <td valign="top" width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− | <tr>
| |
− | <td width="44">
| |
− | <p align="center"><span style="font-family: times new roman, times;">12</span></p>
| |
− | </td>
| |
− | <td width="155">
| |
− | <p><span style="font-family: times new roman, times;">update_date</span></p>
| |
− | </td>
| |
− | <td width="87">
| |
− | <p align="center"><span style="font-family: times new roman, times;">Datetime</span></p>
| |
− | </td>
| |
− | <td width="77">
| |
− | <p align="center"> </p>
| |
− | </td>
| |
− | <td valign="top" width="118">
| |
− | <p align="center"><span style="font-family: times new roman, times;"><em>Candidate Key</em></span></p>
| |
− | </td>
| |
− | </tr>
| |
− |
| |
− | </table>
| |
− | </div>
| |
− | <h2><span style="font-family: times new roman, times;"><strong></strong><strong>Rancangan Prototype</strong></span></h2>
| |
− | <p><span style="font-family: times new roman, times;">Rancangan prototype sistem pengolahan administrasi pelayanan penduduk diantaranya yaitu :</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Login</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada saat program pertama kali dijalankan pada tampilan yang muncul yaitu login. Tampilan login berfungsi sebagai awal dalam menggunakan sistem informasi pengolahan administrasi pelayanan penduduk pada kantor Kepala Desa Kemiri, yang berhak melakukan login yaitu: Staff Pelayanan, Sekretariat, dan Kepala Desa.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada login yang ditunjukkan pada gambar 3.13 :</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/Xk31KgR/masuk.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.13 Prototype Login</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong><br clear="all" /> </strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong> </strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Utama/Home</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Rancangan menu utama / Dashboard untuk menampilkan halaman awal pada sistem infromasi administrasi pelayanan penduduk pada Kantor Kepala Desa Kemiri.</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu utama / Dashboard yang ditunjukkan pada gambar 3.14:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/7YhsqYM/Dashboard.png" width="500" height="270" /></p>
| |
− |
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.14 prototype Dashboard</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Validasi Transaksi</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu Validasi Pengantar yang ditunjukkan pada gambar 3.15:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/FWcm1Hz/Print-preview-copy-3.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.15 prototype Menu Validasi pengantar</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong><br clear="all" /> </strong></span></p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Transaksi</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu Transaksi yang menampilkan pilihan surat yang dibutuhkan ditunjukkan pada gambar 3.16:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/Pt8TPw4/transaksi.png" width="500" height="270" /></p>
| |
− |
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.16 prototype Menu Transaksi</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Transaksi Buat Surat</strong><strong></strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu Transaksi yang menampilkan pilihan surat yang dibutuhkan ditunjukkan pada gambar 3.17:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/rvzPp9Q/Print-preview-copy-4.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.17 Prtototype Menu Data Transaksi Surat</span></p>
| |
− | <p> </p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Tampilan Surat</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu Tampilan Surat yang ditunjukkan pada gambar 3.18:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/JKLkGdd/surat.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.18 Prototype Menu Tampilan Surat</span></p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Master</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu Master yang ditunjukkan pada gambar 3.19:</span></p>
| |
− | <p> </p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/Lp3vFkS/Input-Master-Penduduk.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.19 Prototype Menu Master</span></p>
| |
− | <p> </p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Laporan</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu laporan yang ditunjukkan pada gambar 3.20:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/BPXzvjn/report.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.20 Prototype menu laporan</span></p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Tampilan Laporan sesuai tanggal yang dibutuhkan</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu Tampilan laporan yang ditunjukkan pada gambar 3.21:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/RyqSWBn/laporan.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.21 Prototype Menu Tampilan Laporan</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><em><br clear="all" /> </em></span></p>
| |
− | <p> </p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;"><strong>Prototype Menu Tampilan Laporan Surat</strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Berikut ini merupakan tampilan rancangan prototype pada menu Tampilan laporan yang ditunjukkan pada gambar 3.22:</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/8Xw9knx/Laporan1.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.22 Prototype Tampilan laporan</span></p>
| |
− |
| |
− |
| |
− | ==Rancangan Program==
| |
− | <p><span style="font-family: times new roman, times;">Berdasarkan requirements yang terdapat pada Final Draft Elisitasi di atas, kemudian dibangun beberapa sistem, yaitu:</span></p>
| |
− | <p><span style="font-family: times new roman, times;">1. Tampilan Login</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Untuk mengakses sistem ini sumua user akan menuju halaman login dan hanya yang memiliki akun username</span></p>
| |
− | <p align="center"> </p>
| |
− | <p align="center"><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/dfHV00N/login.jpg" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.23 Tampilan Login</span></p>
| |
− | <p><span style="font-family: times new roman, times;"><em><br clear="all" /> </em></span></p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;">2. Tampilan Dashboard</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Setelah berhasil melakukan login, maka user akan masuk ke halaman utama yang terdapat informasi mengenai jumlah penduduk, jumlah pemohon surat berdasarkan RW, dan jumlah surat-surat yang telah dibuat. Terdapat juga beberapa pilihan menu seperti Transaksi, Master, Laporan, Utility dan Logout yang memudahkan user dalam memilih sesuai kebutuhan user. Berikut adalah tampilan Dashboard.</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/6b9LtBN/image.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.24 Tampilan dashboard</span></p>
| |
− |
| |
− |
| |
− | <p style="text-align: left;"><span style="font-family: times new roman, times;">3. Tampilan Validasi Surat Pengantar</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Tampilan ini adalah tampilan untuk user melakukan validasi surat pengantar RT. Agar user dapat mengakses transaksi maka melakukan validasi pengantar RT terlebih dahulu.</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/7CpyyFt/Screenshot-2019-08-15-Si-Pa-Te-N-Validasi-Surat-Pengantar.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.25 Tampilan Validasi Pengantar RT pada Menu Transaksi</span></p>
| |
− |
| |
− |
| |
− | <p style="text-align: left;" align="center"><span style="font-family: times new roman, times;">4. Tampilan Transaksi</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada Tampilan ini adalah tampilan untuk user memilih surat yang dibutuhkan.</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/q5vf2xf/Screenshot-2019-08-27-Si-Pa-Te-N-Menu-Transaksi.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.26 Tampilan Menu Transaksi</span></p>
| |
− |
| |
− |
| |
− | <p style="text-align: left;" align="center"><span style="font-family: times new roman, times;">5. Tampilan Data Surat Yang Sudah Diinput Pada Menu Transaksi</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada tampilan ini dapat menampilkan data – data surat yang telah diinput dan dapat dilakukan print,edit,delete data surat.</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/Ltm546G/Screenshot-2019-08-27-Si-Pa-Te-N-Domisili-Tinggal.png" width="500" height="270" /></p>
| |
− | <p style="text-align: center;" align="center"><span style="font-family: times new roman, times;">Gambar 3.27 Tampilan Menu Data surat yang telah diinput</span></p>
| |
− |
| |
− |
| |
− | <p style="text-align: left;"><span style="font-family: times new roman, times;">6. Tampilan Print Surat</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada tampilan ini menampilkan surat yang sudah dibuat dan akan dilakukan print.</span>
| |
− | </p><p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/KrmGbSx/Screenshot-2019-08-27-Surat-Keterangan-Domisili-Tinggal.png" width="500" height="270" /></p>
| |
− | <p style="text-align: center;" align="center"><span style="font-family: times new roman, times;">Gambar 3.28 Tampilan Print Surat</span></p>
| |
− |
| |
− |
| |
− | <p style="text-align: left;"><span style="font-family: times new roman, times;">7. Tampilan Menu Master</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada tampilan ini user dapat melihat data master Penduduk yang bisa dilihat dapat dilakukan edit, dan delete.</span></p>
| |
− | <p> </p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="https://i.ibb.co/N39pY0Z/image.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.29 Tampilan Menu Master</span></p>
| |
− |
| |
− |
| |
− | <p style="text-align: left;" align="center"><span style="font-family: times new roman, times;">8. Tampilan Menu Laporan</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada tampilan ini user dapat melihat data laporan yang diinginkan.</span></p>
| |
− | <p> </p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/MVn0MD8/Screenshot-2019-08-27-Si-Pa-Te-N-Laporan.png" width="500" height="270" /></p>
| |
− |
| |
− | <p align="center"><span style="font-family: times new roman, times;">Gambar 3.30 Tampilan Menu Laporan</span></p>
| |
− |
| |
− | <p style="text-align: left;"><span style="font-family: times new roman, times;">9. Tampilan Laporan</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada tampilan ini user dapat memasukkan tanggal, bulan, dan tahun surat yang diinginkan.</span></p>
| |
− | <p> </p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/YPynp70/image.png" width="500" height="270" /></p>
| |
− | <p style="text-align: center;"><span style="font-family: times new roman, times;">Gambar 3.31 Tampilan Menu Laporan SK Kematian</span></p>
| |
− |
| |
− | <p><span style="font-family: times new roman, times;">10. Tampilan Laporan</span></p>
| |
− | <p><span style="font-family: times new roman, times;">Pada tampilan ini user dapat melihat data laporan berdasarkan tanggal, bulan, dan tahun yang diinginkan.</span></p>
| |
− | <p align="center"> </p>
| |
− | <p><img style="display: block; margin-left: auto; margin-right: auto;" src="
| |
− | https://i.ibb.co/8XTB1Ks/Screenshot-2019-08-27-Si-Pa-Te-N-Domisili-Tinggal-Detail.png" width="500" height="270" /></p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Gambar 3.32 tampilan Laporan</strong></span></p>
| |
− | <h2><span style="font-family: times new roman, times;"><strong>Konfigurasi Sistem Yang Diusulkan</strong></span></h2>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Spesifikasi Hardware</strong></span></p>
| |
− | <ol>
| |
− | <li><span style="font-family: times new roman, times;">Processor : Pentium 4</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Monitor : 15inch</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Hardisk : 500GB</span></li>
| |
− | <li><span style="font-family: times new roman, times;">RAM : 1GB</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Keyboard : Qwerty</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Printer : Inkjet</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Mouse : Optical</span></li>
| |
− | </ol>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Spesifikasi Software</strong></span></p>
| |
− | <ol>
| |
− | <li><span style="font-family: times new roman, times;">XAMPP</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Notepad++</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Dreamwaver</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Mozila Firefox</span></li>
| |
− | </ol>
| |
− | <p><span style="font-family: times new roman, times;"><strong>Hak Akses</strong><strong></strong></span></p>
| |
− | <p><span style="font-family: times new roman, times;">Untuk mengakses sistem penggajian karyawan terdapat 3 hak akses (brainware) yaitu</span></p>
| |
− | <ol>
| |
− | <li><span style="font-family: times new roman, times;">Seksi Pemerintahan</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Sekretariat</span></li>
| |
− | <li><span style="font-family: times new roman, times;">Kepala Desa</span></li>
| |
− | </ol>
| |
− | <h2><span style="font-family: times new roman, times;"><strong>Testing</strong></span></h2>
| |
− | <h3><span style="font-family: times new roman, times;"><strong>Blackbox Testing</strong><strong></strong></span></h3>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Untuk tahap pengujian penulis menggunakan metode blackbox, untuk dapat memastikan bahwa program atau sistem yang dibuat masih terdapat bug (kesalahan) atau tidak. Dari setiap tes pengujian tidak menutupi kemungkinan masih terdapat bug (kesalahan) dari sistem yang telah dites, tetapi pengujian ini setidaknya dapat meminimalisir bug (kesalahan) yang terdapat di dalam sistem</span></p>
| |
− | <p> </p>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Tabel 3.20 Pengujian <em>Blackbox</em></strong><strong><em></em></strong></span></p>
| |
− | <p style="text-align: justify;"><span style="font-family: times new roman, times;">Berdasarkan analisis blackbox testing yang telah dilakukan maka dapat disimpulkan bahwa program atau sistem yang telah dibuat sudah terminimalisir dari bug (kesalahan) dilihat dari hasil yang sesuai dengan data yang telah diisi.</span></p>
| |
− | <h2><span style="font-family: times new roman, times;"><strong></strong><strong>Implementasi</strong></span></h2>
| |
− | <h3><span style="font-family: times new roman, times;"><strong><em>Time Schedule</em></strong></span></h3>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Tabel 3.21 <em>Time Schedule</em></strong></span></p>
| |
− | <p align="center"> </p>
| |
− | <p align="center"> </p>
| |
− | <h3><span style="font-family: times new roman, times;"><strong></strong><strong>Estimasi Biaya</strong></span></h3>
| |
− | <p align="center"><span style="font-family: times new roman, times;"><strong>Tabel 3.22 Estimasi Biaya</strong></span></p>
| |
− | <p align="center"> </p>
| |
− | <p> </p>
| |
| {{pagebreak}}<hr/> | | {{pagebreak}}<hr/> |
| <!-------------------------------------------------------------------- B A B IV --------------------------------------------------------------------> | | <!-------------------------------------------------------------------- B A B IV --------------------------------------------------------------------> |