Normalize this relation below. Take it through the 1NF, 2NF, and 3NF progression. Use MS Word to draw the tables and show the entire set of tables at each step. Express your thought process in a few sentences at each step. (Don't just repeat the rules!) NOTE: You will need to create primary key and foreign key columns. Indicate the Primary Key columns by making them bold/underline. 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 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 relation’s unique identifier (primary key). --All the nonkey columns are dependent on the table’s 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)

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Normalize this relation below. Take it through the 1NF, 2NF, and 3NF progression.

Use MS Word to draw the tables and show the entire set of tables at each step.
Express your thought process in a few sentences at each step. (Don't just repeat the rules!)

NOTE:

You will need to create primary key and foreign key columns. Indicate the Primary Key columns by making them bold/underline.

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

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 relation’s unique identifier (primary key). --All the nonkey columns are dependent on the table’s 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)

Expert Solution