ESSE 3600 Chapter Notes -Second Normal Form, Print Screen, Unique Key

85 views7 pages

Document Summary

The objective of this exercise is to learn how to prepare data tables of a relational database and then create queries and get results from a relational database using microsoft. In order to prepare a relational database, the tables need to be normalized so that redundant data is eliminated. To create consistent data, repeatability must be minimized. After the normalization process, which creates single entries in attribute fields and minimizes repeatability, the data tables are related using keys to index and link the tables. Tables are normalized following the guidelines of the first, second, and third normal forms, known as 1nf, 2nf and 3nf. In 1nf, all attributes need a single value and duplicate columns must be eliminated. In 2nf, the requirements of the primary key need to be met and in 3nf, the requirements of 2nf need to be met. In 3nf, all non-key departments do not have a transitive dependence.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents