Assignments

Database I: Introduction to Database
INLS 523_002, Spring 2009

Individual Exercises
Start-up Instructions. Assign Tuesday, 1/13/09, complete before Thursday, 1/22/09.
Entity-relationship model. Assign Thursday, 1/29/09, due Tuesday, 2/17/09. Note change in dates. 9% of final grade.
Relational database schema. Assign Tuesday, 2/24/09, due Thursday 3/5/09. 9% of final grade.
SQL and relational algebra. Assign Thursday, 3/5/09, due Thursday, 4/9/09. 9% of final grade.
Normalization. Assign Thursday, 4/14/09, due Thursday, 4/23/09. 9% of final grade.

Tutorials
ER-Visio Tutorials. Assign Thursday, 1/15/09, complete before Thursday, 1/22/09. Ungraded.
Access Tutorials. Assign Tuesday, 1/20/09, complete before Thursday, 1/29/09. Ungraded.

Workshops
DB1 ER: ACME. Start in class Thursday, 1/22/09, due Thursday, 1/29/09. In pairs, 2% of final grade.
DB1 database: ACME. Start in class Thursday, 1/29/09, due Thursday, 2/12/09. In pairs, 2% of final grade.

Databases
Database 2.
Assign Part 1 Thursday, 2/12/09, due Tuesday 3/3/09. (Note new due date.) 10% of final grade.
Assign Part 2 Thursday, 2/26/09, due Thursday 3/26/09. 10% of final grade.

Capstone project. Assign Thursday, 2/19/09.
Part 1 is due Thursday, 3/19/09. 10% of final grade.
Part 2 must be done sometime between Monday 3/23/09 and Friday, 4/3/09.
Part 3 is due Friday, 5/1/09, 5:00 p.m. 20% of final grade.

Participation
Attendence and in-class exercises, 10% of final grade.

Notice that you will usually be working on both a database and an assignment. Plan ahead, and start working on each one promptly!

Important information about submitting assignments

  1. All assignments should be submitted in electronic form as an email attachment.
  2. I must receive the email containing your assignment no later than 12:00 noon on the day it is due.
  3. Proofread your assignment before you send it to me! I do not want to receive multiple submissions of the same assignment because you thought of something you want to change.
  4. Each file should be named using the following conventions.
    For individual assignments: YourLastName_Assignment.format, for example, Haas_db2.accdb or Haas_ermodel.vsd
    For DB1 workshops (done in pairs): LastName1_LastName_2_Assignment.format, for example, Haas_Blake_ertutorial.vsd
  5. You may submit homework in the following formats:
    .doc .docx .txt .rtf .pdf .ppt .pptx .vsd .accdb
  6. If you are submitting several models for a single assignment using PowerPoint, or Visio, please put them on separate pages (tabs) in the same file, rather than submitting one model per file.
  7. If you are submitting more than one file for a single assignment, you may put them into a single WinZip (.zip) archive. Name the archive using the file naming convention.
  8. You will receive comments and grades in one of two ways, depending on the assignment.
    I will either send you email with comments and your grade, or I will send you email with your assignment attached. I will have added comments and grades as annotations to the document.

This page was last modified on January 9, 2009, by Stephanie W. Haas. Address questions and comments about this page to Stephanie W. Haas at shaas at email dot unc dot edu
© Stephanie W. Haas. All rights reserved.