Phase 3: Database Schema and Normalization.

In this phase of the project you need to analyze your existing database schema in the light of the knowledge you acquired about Extended ER Model and Schema Normalization.

Requirements

  1. Give the ER diagram of your existing schema.
  2. Give itemized description of ALL the violations of the normal forms you can identify in your existing relational schema.
  3. Give a new and improved ER diagram.
  4. Clearly indicate the choices you make from the old to the new ER diagram.
  5. Give the new normalized schema of your database.
  6. Clearly indicate the steps you took to improve the old schema into the new schema.
  7. Unfortunately, as result of these changes in the database schema, I anticipate that several parts of your source code need to be changed. Go ahead and fix those problems. Indicate in the report the changes that you needed to make in your source code.

    8. Deliverables

  8. Update your report. Address all the above items.
  9. Do not draw your schema by hand. There are many tools out there that allow you to draw the ER diagram and relational schema.
Start early!