Week 4-Books

For this week's assignment we had to choose a raw data set that contained at least 10 records, and normalize it through the three forms of normalization, making sure that the design changed with each step. Our design must consist of several tables. I decided to use the books that I have at at home and organize them according to author's name, publication, ISBN number and the total pages of each book

First Normal Form-
In order for a set of data to be in first normal form, the following must be true... Each field in a table must contain only a single item of data Each type of data must be stored in only one place The first condition relates to what variable type we choose for a specific field. Each field must contain only a single item of data. The second condition says that if you have similar types of data in different columns, move them to one single column, or create a new table for them if you have to.

Second Normal Form

In order for a set of data to be in second normal form, the following must be true: All data must be in first normal form Each field in a table must contain data about one and only one entity.

Third Normal Form

Third normal form is all about removing dependencies in our table design. In order for a set of data to be in third normal form, the following must be true: * All data must be in second normal form All non-key data dependent on other non-key data should either be eliminated (if possible) or moved to its own table. In this case, none of my information seems redundant. so i decided to put some of the information in their categories.