Your Scenario

Database Normalization

database image

Databases are everywhere! Databases hold content and make it easy to retrieve information. Ever thought about where your Facebook or Twitter Information goes? How do they store the data so it is easily retrievable? This lesson will teach you how database are set up by a process called normalization.

To get started, click on the Tasks and read the problem under the scope. Continue reading and completing items in the Tasks naviation. Be sure to use the resource links to work on this learning content.

You will submit work as identified in the Deliverables section.

Database Normalization - Scope

database image

Be sure to gather all of the needed information in the Scope phase. To do that, you will be stepping through all the steps in the normalization process in this scope section. Once you have all of that completed and you are comfortable with the process, you can go read the Software Inventory problem.

View the Database Normalization Process document.

Read the steps below, then view the Relationships Video.


Complete the Guided Practice below to familiarize yourself with the Database Normalization Process.

Guided Scope

  1. Read the Help Desk Business Problem.

Analysis

  1. Sketch an Object Diagram
  2. Sketch an E-R Diagram
    Guided Design

    Guided Logical Design

    1. Download the Visio template file to create your electronic documents
    2. Create a Visio document of the Object Diagram
    3. Create a Visio document of the E-R Diagram
    4. Create a Word document of the Shorthand Notation

    Guided Physical Design

    1. Create the Database
    2. Establish the relationships
    3. Populate the database tables with adequate data

    Testing

    1. Compare your documents to the completed files
    2. Make the necessary changes

Project Scope

Read the Software Inventory Business Problem.

Continue on with the Analysis Phase

Database Normalization - Analysis

database image

Working on the Software Inventory Problem. Complete the Analysis phase of the project.

Analysis

  1. Sketch an Object Diagram
  2. Sketch an E-R Diagram

Continue on with the Design Phase

Database Normalization - Design

database image

Working on the Software Inventory Problem. Complete the logical design and the physical design phase of the project.

    Guided Design

    Guided Logical Design

    1. Download the Visio template file to create your electronic documents
    2. Create a Visio document of the Object Diagram
    3. Create a Visio document of the E-R Diagram
    4. Create a Word document of the Shorthand Notation

    Guided Physical Design

    1. Create the Database
    2. Establish the relationships
    3. Populate the database tables with adequate data

    Continue on with the Testing Phase

Database Normalization - Testing

database image

Working on the Software Inventory Problem. Complete the logical design and the physical design phase of the project.

Review your output files for accuracy

Review the Deliverable to ensure that you have include all needed deliverables

Continue on with the Evaluation Phase

Database Normalization - Evaluation

database image

Working on the Software Inventory Problem. Complete the logical design and the physical design phase of the project.

Zip all of you deliverables

Submit your work to your instructor for grading

Congrats! You have completed this lesson!

Video from a Database Professional


Introduction To Information Technology © 2014 English (US)