Apply the process of normalization to third normal form in a multi-table entity-relationship - Essay Example

Database Normalization Functional dependence-This is where an attribute in a database relation uniquely determines another attribute in the database. That is, a condition where an attribute A functionally depends on B (ONeil, and ONeil, 2001).2. Primary key-This refers to an attribute or a combination of attributes that are selected to provide a unique identification of an entity instance. 3. Candidate key-An attribute that provides unique identification of each row in a table but it does not contain any subset of attributes.

That is, candidate key is a minimal super key. 4. First normal form-In this form, each attribute domain in a relation has only atomic values that hold only a single value (Unique Identifier) from that domain (ONeil, and ONeil, 2001). 5. Second normal form-A relationship is in second normal form if and only if attribute domain has only atomic values that hold only a single value from that domain (it is in first normal form) and that all non-identifying attributes depend on the entity’s unique identifier.

That is, there are no partial dependencies allowed on keys.6. Problems would you find in tables that are not in second normal formA lot of data redundancy in tables and records (ONeil, and ONeil, 2001).Time wastage7. Third normal form-A relationship is in third normal form if and only if it is in second normal form with no non-identifying attributes that are depending on other non-identifying attributes. That is, in third normal form, a relationship does not allow transitive dependencies (ONeil, and ONeil, 2001). 8. Problems would you find in tables that are not in third normal formInconsistent data dependency in recordsPoor data availability to its users or programs9.

Functional dependencies in the table {PartNum, OnHand} Class Is full Functional dependency since neither PartNum Class nor Onhand Class holds.{PartNum, OnHand} >Description is partial functional dependency since OnHand > Description also holds.{OrderNum, NumOrdered} >QuotedPrice is a partial functional dependency since NumOrdered > QuotedPrice also holds.10. Conversion into third Normal form RepNumFirstNameLastNameReferencesONeil, P.

, & ONeil, E. (2001). Database: Principles, programming, performance. San Francisco, Calif. [u.a.: Morgan Kaufmann Retrieved from http://www.worldcat.org/title/database-principles-programming-performance/oclc/247056966