Ashford University Week 2 The Normalization Process Converting the ERD Essay

I’m working on a computer science exercise and need guidance to help me study.

The Normalization Process: Converting the ERD

Prior to beginning work on this assignment review Chapter 6 in your textbook, read the Absolute Beginner’s Guide to Database Normalization (Links to an external site.) and Database Normalization (Links to an external site.) online resources, and review any relevant information in this week’s lecture. These sources will be used to support your work in the assignment.

You developed and revised your ERD in Week Two, bringing you one step closer to creating the physical database in the Structured Query Language (SQL) server in your virtual lab environment. However, before doing so, you need to check the conceptual model you created and ensure that it meets the First, Second and Third normal forms.

For this assignment, explain the purpose of the normalization process including a description for each of the five normal forms (1NF, 2NF, 3NF, 4NF, and 5NF) and providing examples for each. Cite the sources for all examples. You will then translate the ERD model you created and revised in Week Two into 3NF.
Within your paper explain how each table in your ERD meets 1NF, 2NF, and 3NF. If the tables do not meet the forms, you need to resolve any issues and normalize the database in order to meet 1NF, 2NF, 3NF. If issues were encountered and had to be resolved, describe the rules that were violated and how you resolved them.

The assignment

• Must be two to three double-spaced pages in length (not including title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center (Links to an external site.).
• Must include a separate title page with the following:
  • Title of paper
  • Student’s name
  • Course name and number
  • Instructor’s name
  • Date submitted
• Must use at least two professional sources in addition to the course text.
• Must document all sources in APA style as outlined in the Ashford Writing Center.
• Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center.

Carefully review the Grading Rubric (Links to an external site.) for the criteria that will be used to evaluate your assignment.