chapter05

chapter05 - Concepts of Database Management, Fifth Edition...

Info iconThis 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
Background image of page 1

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

View Full DocumentRight 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
Background 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
Background image of page 3

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

View Full DocumentRight 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
Background image of page 4
5 5 Figure 5.1: Premiere Products Data
Background image of page 5

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

View Full DocumentRight Arrow Icon
6 5 Functional Dependence Column B is functionally dependent on Column
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/17/2008 for the course IS 158 taught by Professor Moffitt during the Spring '08 term at CSU Fresno.

Page1 / 30

chapter05 - Concepts of Database Management, Fifth Edition...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online