To complete this lab you will need to use Microsoft Excel, OpenOffice Calc or any other compatible program to create your spreadsheet. Your output will be submitted as a PDF file.

If you would like to the use the spreadsheet software on the Computer Science Remote Terminal Server (Athena) to complete the assignment, you can use the instructions located at:
http://icarus.cs.weber.edu/athena.html
to help you get connected.

• In this lab assignment you will normalize a small database_to 3NF
  
  

  Your assignment is as follows.

  1. Create an Excel spreadsheet.
  Analyze the following unnormalized table: (you can click on the table for a larger pdf version)
  
  
  Apply the rules of normalization to normalize the database to Third Normal Form (3NF).

• On the spreadsheet, show the 3NF tables that result from your normalization process.
  Also, write text in the area below the tables describing your normalization process.

• Create a PDF file named CS2550DA1.PDF from the spreadsheet.
  In Excel you can use File | Save As PDF
  In Open Office use Export as PDF
  
  
  Upload the PDF file using the file uploader:

CS2550DA1.PDF

On or before the due date - make certain that your submitted file is correctly named. Files that are incorrectly named will not be graded.

Use the Uploader Web Page to submit your files. You will need your student ID to do this. Your student ID appears on your registration receipt. It is a 8 digit number preceded with a "W" A link to the Uploader is contained on the main web page