B05Normal - Normalization A technique for identifying table...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Normalization A technique for identifying table structures that have potential maintenance problems
Background image of page 1

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

View Full DocumentRight Arrow Icon
Normalization Normalization is a set of formal conditions  that assure that a database is  maintainable. The results of a well executed  normalization process are the same as  those of a well planned E-R model
Background image of page 2
PROCESS OF DATA NORMALIZATION ELIMINATE REPEATING GROUPS Make a separate table for each set of related attributes  and give each table a primary key. ELIMINATE REDUNDANT DATA If an attribute depends on only part of a multivalued key,  remove it to a separate table. ELIMINATE COLUMNS NOT DEPENDENT ON KEY If attributes do not contribute to a description of the key,  remove them to a separate table. Database Programming and Design
Background image of page 3

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

View Full DocumentRight Arrow Icon
PROCESS OF DATA NORMALIZATION ISOLATE INDEPENDENT MULTIPLE RELATIONSHIPS No table may contain two or more 1:n or n:m  relationships that are not directly related. ISOLATE SEMANTICALLY RELATED MULTIPLE  RELATIONSHIPS There may be practical constraints on information that  justify separating logically related many-to-many  relationships . Database Programming and Design
Background image of page 4
A table anomaly is a structure for which a  normal database operation cannot be  executed without information loss or full 
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 33

B05Normal - Normalization A technique for identifying table...

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

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