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
- All assignments should be submitted in electronic form as an email
attachment.
- I must receive the email containing your assignment no later than
12:00 noon on the day it is due.
- 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.
- 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
- You may submit homework in the following formats:
.doc .docx .txt .rtf .pdf .ppt .pptx .vsd .accdb
- 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.
- 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.
- 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.