Thư viện tri thức trực tuyến
Kho tài liệu với 50,000+ tài liệu học thuật
© 2023 Siêu thị PDF - Kho tài liệu học thuật hàng đầu Việt Nam
NORMALIZING AND DENORMALIZING DATA pot
Nội dung xem thử
Mô tả chi tiết
2B.1 Relational Database Design
LESSON: 2B
NORMALIZING AND
DENORMALIZING DATA
Objectives
In this section, you will learn to:
Describe the Top-down and Bottom-up approach
Describe data redundancy
Describe the first, second, and third normal forms
Describe the Boyce-Codd Normal Form (BCNF)
Appreciate the need for denormalization
Relational Database Design 2B.2
2B.3 Relational Database Design
©NIIT Normalizing and Denormalizing Data Lesson 2B / Slide 1 of 18
Normalizing and Denormalizing Data
Objectives
In this section, you will learn to:
• Describe the Top-down and Bottom-up approach
• Describe data redundancy
• Describe the first, second, and third normal forms
• Describe the Boyce-Codd Normal Form (BCNF)
• Appreciate the need for denormalization
INSTRUCTOR NOTES
Lesson Overview
The lesson introduces the top-down and bottom-up approaches of logical database
design. This lesson also explains normalization as a technique to avoid data
redundancy and covers the various normal forms. In addition, this lesson explains
denormalization as a technique for improving query performance.