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
Tài liệu đang bị lỗi
File tài liệu này hiện đang bị hỏng, chúng tôi đang cố gắng khắc phục.
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.