Hernawan, Achmad (2018) OPTIMALISASI RELASI TABEL UNTUK INVENTARIS BUKU PERPUSTAKAAN MENGGUNAKAN NORMALISASI. Other thesis, Skripsi, Universitas Muhammadiyah Magelang.
|
PDF (Skripsi)
13.0504.0080_BAB I_BAB II_BAB III_BAB VI_DAFFTAR PUSTAKA_Achmad Hernawan.pdf - Published Version Download (1MB) | Preview |
|
![[img]](http://eprintslib.ummgl.ac.id/style/images/fileicons/application_pdf.png) |
PDF (Skripsi)
13.0504.0080_BAB IV_BAB V_Achmad Hernawan.pdf - Published Version Restricted to Registered users only Download (927kB) | Request a copy |
|
|
PDF (Skripsi)
13.0504.0080_LAMPIRAN_Achmad Hernawan.pdf - Published Version Restricted to Registered users only Download (661kB) | Request a copy |
|
|
PDF (Skripsi)
13.0504.0080_FULLTEXT_Achmad Hernawan.pdf - Published Version Restricted to Registered users only Download (5MB) | Request a copy |
Abstract
Every year, books recording inventory in UMMgl library always increase. The process of data inventory that already exists and has been collected for 18 years is too much and it only uses a few tables, namely book tables, faculty tables, table of types of books that have not been normal in the process so that data anomalies and data repetition can occur. This study aims to minimize data anomalies of book inventory by compiling table of relations by using normalization to facilitate data manipulation and data search. This optimization uses normalization, which is by arranging tables in a database so that there is no redundancy (double) or duplicate data, which can cause data to become anomalies (deviations) when data manipulation operations occur such as adding, changing and deleting. The technique of grouping attributes from a relation form a good relation structure without redundancy. Organizing data into tables according to the needs of the user to eliminate data capture and reduce complexity facilitates data modification. Data is described in table form, then analyzed based on certain requirements to several levels namely unnormal, 1NF, 2NF, 3NF. In tables that have not been normal, redundancies occur that causes data anomalies include insertion anomalies, update anomalies, deletion anomalies. By using Normalization, the results obtained are data anomaly both update anomalies, insertion anomalies, and deletion anomalies can be minimized as it is expected.
| Item Type: | Karya Ilmiah (Other) |
|---|---|
| Pembimbing: | Muhtar Hanafi, S.T., MCs dan Agus Setiawan, M.Eng |
| Uncontrolled Keywords: | Optimization, Data Anomaly, Normalization |
| Subjects: | T Technology > T Technology (General) T Technology > TS Manufactures |
| Depositing User: | Rizki Shofak Isnaini |
| Date Deposited: | 21 Jan 2022 02:34 |
| Last Modified: | 21 Jan 2022 02:34 |
| URI: | http://eprintslib.ummgl.ac.id/id/eprint/3162 |
Actions (login required)
 |
View Item |
