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

• School: York University
• Department: Earth, Space Science and Engineering
• Course: ESSE 3600
• Professor: Sohn

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.