Database Design

Research and answer the following components:

1. Normalization Steps . Create a table and apply the below listed steps to the table. Explain each step and provide an updated table following each step.

First normal form Second normal form Third normal form Fourth normal form Fifth normal form

Note: the title and reference pages do not count toward the page length requirement.

Save your document with the course, assignment, and your name (e.g., ITCO­630_Unit3_IP_Neo_Anderson.docx). Submit your document for grading.

Refer to the Grading Rubric for this assignment.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Reading Assignment Starks: Ch. 5­6

School of Information Technology Library Guide (LibGuide). Navigate to MSIT / ITCO­630

Read the following from the AIU Library:

Database Design and Relational theory: Normal Forms and All That Jazz Chapters 3­5

Assignment Objectives Analyze database entity one­to­one and one­to­many relationships. Analyze normalization and the third normal form (3NF).

Other Information There is no additional information to display at this time.

Assignment Overview

Unit: Database Design Due Date: Tue,12/21/21 Grading Type: Numeric Points Possible: 140 Points Earned: Deliverable Length: 5­Page MS Word Document

Type: Individual Project

Go To:

Looking for tutoring? Go to Smarthinking