{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

chapter05 - Concepts of Database Management Fifth Edition...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Concepts of Database  Concepts of Database  Management, Fifth Edition Management, Fifth Edition Chapter 5:  Chapter 5:  Database Design 1: Database Design 1: Normalization Normalization
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 5 Objectives Discuss functional dependence Discuss primary keys Define first normal form, second normal form, and third normal form Describe the problems associated with tables (relations) that are not in first normal form, second normal form, or third normal form along with the mechanism for converting to all three
Image of page 2
3 5 Objectives Discuss the problems associated with incorrect conversions to third normal form Define fourth normal form Describe the problems associated with tables (relations) that are not in fourth normal form and describe the mechanism for converting to fourth normal form Understand how normalization is used in the database design process
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4 5 Normalization Normalization process – enables you to identify the existence of potential problems, called updating anomalies, in the design of a relational database Normal form – possesses a certain desirable collection of properties
Image of page 4
5 5 Figure 5.1: Premiere Products Data
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
6 5 Functional Dependence
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}