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.

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

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

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

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

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

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

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

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

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

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

Download (848kB)
[thumbnail of Publication Agreement] 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:
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

Actions (login required)

View Item
View Item