NORMALIZATION

Long before the database tables are created and data are moved or inserted into them, the database designer creates the logical and physical models of the database. In this application, you will examine the process of relational database design and modeling and explore using normalization techniques to identify new tables, update business rules for a database, and create an updated entity relationship diagram.

To prepare:

• Review this weeks readings and media in the Learning Resources.
• Access and review the documents in the Learning Resources.

To complete the Week 3 Assignment:

• Normalize the tables in the Sales Data document.

Submit a document of 24 pages in Microsoft Word and APA format in which you do the following tasks:

• Identify the new tables.
• Update the business rules for the database.
• Provide an updated ERD. (Note: The ERD may be hand drawn or updated using MS Visio, any drawing package, or Gliffy (https://www.gliffy.com).

Refer to the Week 3 Assignment Rubric for specific grading elements and criteria. Your Instructor will use this grading rubric to assess your work.

Your document should be 24 pages (not including the list of resources cited), but it is the quality of the work that is important, not the number of pages. Cite and reference all sources using APA format and style guidelines.