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

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.

[img] Text (Title)
08220060045_Title.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (497kB)
[img] Text (Abstract)
08220060045_Abstract.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (87kB)
[img] Text (ToC)
08220060045_ToC.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (94kB)
[img] Text (Chapter1)
08220060045_Chapter1.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (134kB)
[img] Text (Chapter2)
08220060045_Chapter2.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (268kB)
[img] Text (Chapter3)
08220060045_Chapter3.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (372kB)
[img] Text (Chapter4)
08220060045_Chapter4.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (206kB)
[img] Text (Chapter5)
08220060045_Chapter5.pdf
Restricted to Registered users only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (118kB)
[img] Text (Bibliography)
08220060045_Bibliography.pdf
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (118kB)
[img] Text (Appendices)
08220060045_Appendices.pdf
Restricted to Repository staff only
Available under License Creative Commons Attribution Non-commercial No Derivatives.

Download (848kB)
[img] Text (Publication Agreement)
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:
CreatorsNIMEmail
Prasetyo, FirgitantoUNSPECIFIEDUNSPECIFIED
Contributors:
ContributionContributorsNIDN/NIDKEmail
Thesis advisorSutrisno, SutrisnoUNSPECIFIEDUNSPECIFIED
Thesis advisorMurwantara, I MadeUNSPECIFIEDUNSPECIFIED
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

Actions (login required)

View Item View Item