Scribd
Upload
12 views

Course1Module11Lesson4

Uploaded by

Yanet Cesaire
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
12 views

Course1Module11Lesson4

Uploaded by

Yanet Cesaire
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 7

Information Systems Program

Module 11
Normalization Concepts and Practice

Lesson 4: Practical Concerns


Lesson Objectives
• Reflect on role of normalization
• Reflect on importance of normalization
• Reflect on situations to relax normalization
requirements

Information Systems Program


Competing Roles of Normalization

Refinement
• Use after ERD
• Few FDs

Initial Design
• FDs first
• ERD after FDs

Information Systems Program


Normalization Importance
• Update biased
• Not a major concern for databases without updates (data
warehouses)
• Relax normalization sometimes

Information Systems Program


Denormalization
• Purposeful violation of a normal form
• Some FDs may not cause anomalies in practice
• May improve performance
• Common for data warehouses

Information Systems Program


Denormalization Example
• ZipCode  City, State
• Important for ecommerce business for sales tax
• May be important for ecommerce databases

Information Systems Program


Summary
• Covered practical issues
• Use normalization as a refinement approach
• Do not lose context of normalization when performing
details

Information Systems Program

You might also like