Prasetyo, Firgitanto (2012) Identifikasi primary key pada kasus normalisasi 4 dan normalisasi 5 menggunakan tools primary key identifier = Primary key identification for 4th dan 5th normalization cases using primary key identifier. Bachelor thesis, Universitas Pelita Harapan.
![Title [thumbnail of Title]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Title.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (497kB)
![Abstract [thumbnail of Abstract]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Abstract.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (87kB)
![ToC [thumbnail of ToC]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_ToC.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (94kB)
![Chapter1 [thumbnail of Chapter1]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Chapter1.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (134kB)
![Chapter2 [thumbnail of Chapter2]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Chapter2.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (268kB)
![Chapter3 [thumbnail of Chapter3]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Chapter3.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (372kB)
![Chapter4 [thumbnail of Chapter4]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Chapter4.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (206kB)
![Chapter5 [thumbnail of Chapter5]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Chapter5.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (118kB)
![Bibliography [thumbnail of Bibliography]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Bibliography.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (118kB)
![Appendices [thumbnail of Appendices]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Appendices.pdf
Restricted to Repository staff only
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (848kB)
![Publication Agreement [thumbnail of Publication Agreement]](http://repository.uph.edu/style/images/fileicons/text.png)
08220060045_Publication Agreement.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.
Download (575kB)
Abstract
The criteria of a good table are if the data is consistent and there's no data loss or redundancy. One way of preventing redundancy is by using primary key. When the criteria are not fulfilled, it should undergo normalization phase. Normalization is a technique to achieve one set of table which normalized so that the rule of relational model database can be achieved. Stages of normalization are:
1NF, 2NF, 3NF, BCNF, 4NF, 5NF. Each stage is required for their function. 4NF and 5NF are required in multivalued dependency case. Multivalued dependency is a dependence of each attributes in the table. The step of solving normalization problems 4 and 5 is decomposition,
breaking a table to smaller part so there's no duplication anymore in that table. Primary key identification can be done by comparing each record and noted any duplication existed. This is a scheme of how primary key identifier tools work. The result is primary key identifier can indicate primary key candidates in normalization case 4 and 5, so that tools can be an option in primary key identification. The conclusion is primary key identifier can be used in all phases of normalization, 1NF, 2NF, 3NF, BCNF, 4NF, 5NF.
Item Type: | Thesis (Bachelor) |
---|---|
Creators: | Creators NIM Email ORCID Prasetyo, Firgitanto UNSPECIFIED UNSPECIFIED UNSPECIFIED |
Contributors: | Contribution Contributors NIDN/NIDK Email Thesis advisor Sutrisno, Sutrisno UNSPECIFIED UNSPECIFIED Thesis advisor Murwantara, I Made UNSPECIFIED UNSPECIFIED |
Additional Information: | SK 82-06 FIR i |
Subjects: | Q Science > QA Mathematics > QA75 Electronic computers. Computer science |
Divisions: | University Subject > Current > Faculty/School - UPH Karawaci > School of Information Science and Technology > Informatics Current > Faculty/School - UPH Karawaci > School of Information Science and Technology > Informatics |
Depositing User: | Mr Samuel Noya |
Date Deposited: | 04 Oct 2018 04:17 |
Last Modified: | 04 Oct 2021 07:47 |
URI: | http://repository.uph.edu/id/eprint/446 |