Sonoma State University
Department of Computer Science
CS-370: Software Design and Development
Exercise 11: Database Schema evaluations

OBJECTIVE

To evaluate and provide feedback on Database Schemas as a team for other teams.

DEFINITIONS:

First Normal Form (1NF):

A table is in First Normal Form (1NF) if it satisfies the following conditions:

  • "Each column must have a unique name."
  • "The order of the rows and columns doesn’t matter."
  • "Each column must have a single data type."
  • "No two rows can contain identical values."
  • "Each column must contain a single value."
  • "Columns cannot contain repeating groups."
Second Normal Form (2NF):

A table is in Second Normal Form (2NF) if it satisfies the following conditions:

  • "It is in 1NF."
  • "All non-key fields depend on all key fields."
Third Normal Form (3NF):

A table is in Third Normal Form (3NF) if it satisfies the following conditions:

  • "It is in 2NF."
  • "It contains no transitive dependencies."

THE EXERCISE:

  • Each team will pair-up with another team and share your Database Schemas with each other.
  • Each team will evaluate and write feedback for the other teams Database Schema.
  • Once both teams in the pair-up have provided feedback, those pair-ups will split and the process will repeat with different team pairings.
  • The goal is to maximize the amount of teams that can provide feedback to other teams and to maximize the amount of feedback each team gets.

EVALUATION:

The evaluations are collaborative, meaning you and your team will evaluate each database schema together as a group, not as individuals. Please include the following in your evaluation:

  • List the name of the team or the name of the individual (if applicable) whose database schema you are evaluating.
  • Is the table in first normal form (1NF)? Explain and justify your assessment.
  • Is the table in second normal form (2NF)? Explain and justify your assessment.
  • Is the table in third normal form (3NF)? Explain and justify your assessment.

UPLOADING YOUR SOLUTION:

  • In your evaluation document, please write the names of everyone who worked on this evaluation today. Note: only the names listed on your document submission will receive credit for this assignment.
  • Please upload your answer in either Word (Microsoft), PDF (Acrobat), an image file (i.e. digital scan of a paper document), or as a text file.
  • Minimally, one person on a team should submit the document; however, two or more team members may submit the assignment as well. There is no harm in redundancy.