RU CS 445 - Normalization of Database Tables (27 pages)

Previewing pages 1, 2, 3, 25, 26, 27 of 27 page document View the full content.
View Full Document

Normalization of Database Tables



Previewing pages 1, 2, 3, 25, 26, 27 of actual document.

View the full content.
View Full Document
View Full Document

Normalization of Database Tables

28 views

Lecture Notes


Pages:
27
School:
Regis University
Course:
Cs 445 - DATABASE MANAGEMENT

Unformatted text preview:

4 Chapter 4 Normalization of Database Tables Database Systems Design Implementation and Management Fifth Edition Rob and Coronel 4 In this chapter you will learn What normalization is and what role it plays in database design About the normal forms 1NF 2NF 3NF BCNF and 4NF How normal forms can be transformed from lower normal forms to higher normal forms That normalization and E R modeling are used concurrently to produce a good database design That some situations require denormalization to generate information efficiently Database Systems Design Implementation Management 5th Edition Rob Coronel 2 4 Database Tables and Normalization Table is basic building block in database design Normalization is process for assigning attributes to entities Reduces data redundancies Helps eliminate data anomalies Produces controlled redundancies to link tables Normalization stages 1NF First normal form 2NF Second normal form 3NF Third normal form 4NF Fourth normal form Database Systems Design Implementation Management 5th Edition Rob Coronel 3 4 Need for Normalization Figure 4 1 Database Systems Design Implementation Management 5th Edition Rob Coronel 4 4 Figure 4 1 Observations PRO NUM intended to be primary key Table entries invite data inconsistencies Table displays data anomalies Update Modifying JOB CLASS Insertion New employee must be assigned project Deletion If employee deleted other vital data lost Database Systems Design Implementation Management 5th Edition Rob Coronel 5 4 Conversion to 1NF Repeating groups must be eliminated Proper primary key developed Uniquely identifies attribute values rows Combination of PROJ NUM and EMP NUM Dependencies can be identified Desirable dependencies based on primary key Less desirable dependencies Partial based on part of composite primary key Transitive one nonprime attribute depends on another nonprime attribute Database Systems Design Implementation Management 5th Edition Rob Coronel 6 4 Dependency Diagram 1NF Figure 4 4 Database



View Full Document

Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Normalization of Database Tables and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Normalization of Database Tables and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?