I need to answer this Discussion question: Relational Database Models and Normalization Techniques

Week 3 DiscussionCOLLAPSE

Relational Database Models and Normalization Techniques

Long before the tables are created and data is moved or inserted into them, the database designer created the logical and physical models of the database. In this unit you will examine the process of relational database design and modeling and understand and use normalization techniques to create a UML (Unified Modeling Language) diagram of a database.

These are the resources for this question:

• Web Resource:Ippolite, C. (2011).Relational database design with Filemaker Pro. Retrieved fromhttp://wwwlyndacom.ezp.waldenulibrary.org/FileMaker-Pro-10-tutorials/Relational-Database-Design-with-FileMaker-Pro/83839-2.html
  • Chapter 1, “Reviewing Data Modeling”
  • Chapter 6, “Real-World Data Modeling Examples”This tutorial presents an illustrative overview of data modeling.
• Web Resource:Allardice, S. (2010).SQL server 2008 essential training. Retrieved fromhttp://wwwlyndacom.ezp.waldenulibrary.org/SQL-Server-2008-tutorials/Essential-Training/71929-2.html
  • Chapter 4, “Creating Databases”
    • “Introduction to Relationships and Foreign Keys”
    • “Database Normalization”
    • “Creating Computed Columns”

    This tutorial offers essential training for SQL server.

• Web Resource:Sparx Systems Ltd. (2011).UML tutorial. Retrieved fromhttp://www.sparxsystems.com.au/uml-tutorial.html
  This website presents a comprehensive tutorial for designing UML diagrams.
• Web Resource: Martin, R. C. (n.d.).UML tutorial: Part 1-class diagrams. Retrieved fromhttp://www.objectmentor.com/resources/articles/umlClassDiagrams.pdf
  This website presents a comprehensive tutorial for designing UML diagrams.
• Document: Laureate Education, Inc. (Executive Producer). (2011).Library UML docume