You will normalize this table (relation) below and take it through the 1NF, 2NF, and 3NF progression.

REMINDER:

1NF: First Normal Form Eliminate repeating data and non-atomic values; add keys The data is stored in a relation (table) and each attribute (column) contains atomic values. There are no repeating groups of attributes.

2NF: Second Normal Form Eliminate partial dependencies. The relation is in first normal form and all the attributes depend on the relations unique identifier (primary key). --All the nonkey columns are dependent on the tables primary key. (All nonkey attributes are functionally dependent on the entire primary key.)

3NF: Third Normal Form Eliminate transitive dependencies. The relation is in second normal form and all of its attributes are not transitively dependent on the unique identifier. ----A table contains only columns that are non-transitively dependent on the primary key (i.e., all nonkey attributes depend only on the primary key)

Effective answers will take into account the following:

• You will need to create primary key and foreign key columns.
• Primary keys can't repeat! If you've created a primary key and you notice either that it repeats NOW or that it's likely to do so in the FUTURE, you need to make a change.
• Atomic values mean that each cell includes just ONE indivisible piece of data.
• Make sure you carry all your data through every single version: from 0NF to 1NF to 2NF, etc. Losing data is a real danger during the normalization process, and you should do your best to make sure that doesnt happen.
• Each piece of data only shows up in one place in the final, normalized version (excepting foreign keys). No repeating!

Here are the instructions:

• Use MS Word to draw the tables and show the entire set of tables at each step.
• Indicate the Primary Key columns by making them bold/underline.
• Express your thought process in a few sentences at each step. (Don't just repeat the rules!)

This step will be 0NF

Imagine an effort by someone who has attempted to make a database of library item circulation. This is a simplified example, of course, but assume we were trying to track patrons and the items they checked out. A table to hold all this data could look like:

FirstName	LastName	PatronType	Township	Item checked out
Maree	Hamid	Adult	Clarke	Jaws: 2021-01-19
Joe	Nelson	Child	Clarke	Hoop Dreams: 2021-02-03
Joe	Nelson	Child	Clarke	Bugs: 2021-02-03
Alain	Jones	Adult	Ripley	Hoop Dreams: 2021-01-10
Alain	Jones	Adult	Ripley	Jaws: 2021-01-10