Analyze database entity one­to­one-one­to­many relationship

Question

Assignment:

Assignment Description

Review the following LinkedIn Learning videos to help you with your assignments in this Unit.

Create a 5­ page MS Word document following APA guidelines (first person should not be used). Write this document for a technical audience.

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.

Please submit your assignment.

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

Reading Assignment

Starks:

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

Assignment Objectives

1. Analyze database entity one­to­one and one­to­many relationships.

2. Analyze normalization and the third normal form (3NF).