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.
Text (Title)
08220060045_Title.pdf Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (497kB) |
|
Text (Abstract)
08220060045_Abstract.pdf Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (87kB) |
|
Text (ToC)
08220060045_ToC.pdf Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (94kB) |
|
Text (Chapter1)
08220060045_Chapter1.pdf Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (134kB) |
|
Text (Chapter2)
08220060045_Chapter2.pdf Restricted to Registered users only Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (268kB) |
|
Text (Chapter3)
08220060045_Chapter3.pdf Restricted to Registered users only Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (372kB) |
|
Text (Chapter4)
08220060045_Chapter4.pdf Restricted to Registered users only Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (206kB) |
|
Text (Chapter5)
08220060045_Chapter5.pdf Restricted to Registered users only Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (118kB) |
|
Text (Bibliography)
08220060045_Bibliography.pdf Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (118kB) |
|
Text (Appendices)
08220060045_Appendices.pdf Restricted to Repository staff only Available under License Creative Commons Attribution Non-commercial No Derivatives. Download (848kB) |
|
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: |
|
||||||||||||
Contributors: |
|
||||||||||||
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 |