| .BZU. | 13-06-2011 01:03 PM |
Chapter13- Normalization Transparencies by Carolyn E. Begg, Thomas Connolly
1 Attachment(s) Chapter13- Normalization Transparencies by Carolyn E. Begg, Thomas Connolly http://bzupages.com/attachment.php?a...1&d=1307948445
The purpose of normalization. - How normalization can be used when designing a relational database.
- The potential problems associated with redundant data in base relations.
- The concept of functional dependency, which describes the relationship between attributes.
- The characteristics of functional dependencies used in normalization.
- How to identify functional dependencies for a given relation.
- How functional dependencies identify the primary key for a relation.
- How to undertake the process of normalization.
- How normalization uses functional dependencies to group attributes into relations that are in a known normal form.
- How to identify the most commonly used normal forms, namely First Normal Form (1NF), Second Normal Form (2NF), and Third Normal Form (3NF).
- The problems associated with relations that break the rules of 1NF, 2NF, or 3NF.
- How to represent attributes shown on a form as 3NF relations using normalization.
| 