Data Normalization

Assignment Instructions

Refer to the file IT163_Example2 for a demonstration.

1. For this first step take the data provided previously, IT163_Data1, and put it into a tabular format. See the example document for an idea of how you might organize the data into a table.

Note: Organizing all of the data into a single table does not represent a database nor a normalized design. This data store helps to visualize the data in one place. This is just where you’ll begin the process.

2. Put the data into first normal form. Use a simple table in Word or an Excel spreadsheet to show your attributes in first normal form with a partial data example.

For extra help see Optional Resources for Assignment under the Academic Tools, Library link:

Reference: Relational Database Design and Implementation (4th ed.).

Chapter 7: “Normalization / First Normal Form”

Generic Design and Modeling Databases: First Normal Form

https://libauth.purdueglobal.edu/sso/skillport?con…

3. Looking at your first normal form and the data examples, identify problems that need to be addressed to put this data into second normal form. Use a simple table in Word or an Excel spreadsheet to show this data in second normal form.

For extra help see Optional Resources for Assignment under the Academic Tools, Library link:

Reference: Relational Database Design and Implementation (4th ed.).

Chapter 7: “Normalization / Second Normal Form”

Generic Design and Modeling Databases: Second Normal Form

https://libauth.purdueglobal.edu/sso/skillport?con…

4. Taking your second normal form of the data, analyze the issues that prevent it from being in third normal form. Use a simple table in Word or an Excel spreadsheet to show this data in third normal form.

For extra help see Optional Resources for Assignment under the Academic Tools, Library link:

Reference: Relational Database Design and Implementation (4th ed.).

Chapter 7: “Normalization / Third Normal Form”

Generic Design and Modeling Databases: Third Normal Form

https://libauth.purdueglobal.edu/sso/skillport?con…

5. Now that you’ve worked through the normalization of the data, use Microsoft Visio to create your logical diagram to show the normalized design. The diagram should represent relationships using crow’s foot notation. The diagram should include the entity names, attributes and notation of primary and foreign keys for each entity.

Create an ERD in MS Visio

Assignment Requirements

Your work will consist of two parts:

Part 1: the visualization of your normalization process (steps 1, 2 and 3) (use tables in Word or a spreadsheet). See example file provided (IT163_Example2).

Part 2: the Visio diagram file (*.vsd or *vsdx).

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.