BIT320 Syllabus — Normalization

September 13, 2005

Normalization 1/3

Intro to normalization

Topics:

Before Class

  1. Normalization (Chapter 1)

In Class

  1. Overheads for Normalization 1/3
  2. Normalization exercise #1
  3. Answer to Normalization exercise #1
  4. Normalization exercise #2
  5. Answer to Normalization exercise #2
  6. Alternative Answer to Normalization exercise #2

After Class

  1. Normalization process
  2. Normalization (Chapter 2)
  3. Read Concepts of Database Management, pp. 139–162 in the coursepack.
  4. Normalization problems #1 (for practice if you want them)
  5. Normalization problems #1 answer (for practice if you want them)

Other Resources

  1. Database normalization & design techniques (PHP Builder)

Bud last edited this September 9, 2005 | Permalink | Comments (0) | TrackBack (0)

September 15, 2005

Normalization 2/3

More normalization

Topics:

In Class

  1. Overheads for normalization 2/3
  2. Normalization exercise #3
  3. Normalization exercise #3 answer
  4. Normalization exercise #4
  5. Normalization exercise #4 answer

After Class

  1. Have a peek at start.com and Google IG. What do you think about these services?
  2. Read Concepts of Database Management, pp. 162–172.
  3. Normalization problems #2 (if you want practice)
  4. Normalization problems #2 answer (if you want practice)

Bud last edited this September 9, 2005 | Permalink | Comments (0) | TrackBack (0)

September 20, 2005

Normalization 3/3

Even more normalization

Topics:

Before Class

Answer the following questions for yourselves so we can discuss them:

  1. What part of the normalizaton process actually gets implemented in the computer?
  2. Normalization is a key component of the relational model. How do we relate data in a set of tables that have been put in 3NF?

In Class

  1. Overheads for normalization 3/3

After Class

  1. Based on what you have seen so far, how is the relational model adequate or inadequate for storing information about business processes?
  2. Normalization (Chapter 3).

Other Resources

  1. Normalization (Chapter 4). This chapter presents an alternative method of normalization and is entirely optional.
  2. Normalization process using graphs

Bud last edited this September 18, 2005 | Permalink | Comments (0) | TrackBack (0)

October 25, 2005

Quiz on first part of semester

Quiz covering ER modeling, normalization, and sql

Topics:

Bud last edited this October 10, 2005 | Permalink | Comments (0) | TrackBack (0)