[ Homeworks | Labs | Links | News | Slides | Models | Databases | Grades ]

• Time and Place:
  • Monday, Wednesday, Friday 11:00-11:50am in 105 Fenton
  • Lab sessions are held in room 26B Klamath
    • 10:00-10:50am Wednesday
    • 1:00-1:50pm Friday

• Instructor: Craig Thornley, 162 Deschutes, 346-0488, thornley@cs.uoregon.edu.

• Teaching Assistant: Ghulam Memon, 341 Deschutes, 346-4425, gmemon@cs.uoregon.edu

• Office hours: Students can drop in anytime, make an appointment, or find us in our offices. (If you can't see us, email will be the preferred method of communication for both of us.)
  • Craig: Monday, Wednesday, and, Friday 12:00-1:00, or by appointment
  • Ghulam: Monday 1:15-2:45pm, Friday 2:30-4:00pm, or by appointment

• Course Objectives: There are two primary goals for this course
  • To learn how to do logical database design for relational databases.
  • To learn how to extract meaningful data from a relational database management system (RDBMS) using SQL, the standard language for extracting information from a RDBMS.

• Evaluation: Course grades will be based on the following criteria

  Homework Assignments	30%
  Labs	5%
  Test 1 (Oct 30)	20%
  Test 2 (Nov 29)	20%
  Final Project	25%

• Textbook: Learning SQL a Step-by-Step Guide Using Access, Sikha Bagui and Richard Earp (optional)

• Software: There are two main applications we will use in this course. Both are provided on the lab machines (PCs running Windows XP)
  • ER Studio from Embarcadero
  • Microsoft Access 2000

• Labs: Lab attendence is required. There will be lab exercises that must be completed during the labs. They should be fun.

  26B Klamath lab hours this term:

  • 8:00 am - 11:00 pm Monday - Thursday
  • 8:00 am - 6:00 pm Friday
  • 2:00 pm - 7:00 pm Saturday
  • 1:00 pm - 9:00pm Sunday

• Homeworks: There will be 4 homework assignments. They will not be handed out in class. You will find them on the web here. Please do your own work and follow the class naming conventions. If you don't turn your homeworks in during class there is a drop box labeled CIT 381 on the first floor of Deschutes Hall.

• Midterms: The two midterms will be a combination of multiple choice, true false, design problems, etc and will cover all material from readings, lectures, and labs. I will give more details about each test after I make them.

• Final Project: This will involve designing and implementing a small relational database, then populating the database with some data and writing several SQL queries to extract data. Work in teams of two. Again, please follow the class naming conventions.

• Tentative Syllabus

  Date	Lecture Topic	Reading	Supplemental	Due
  Sep 25	introduction
  Sep 27	database concepts, www and databases	database terms	Paragon Article on Databases, Data Warehousing
  Sep 29	data modeling (ER)	U of Texas
  Oct 2	ER Modeling
  Oct 4	Relational Modeling	U of Texas
  Oct 6	Relational Keys	Edmondson	Keys In-Class Problem
  Oct 9	IDEF1X	IDEF1X (overview)	IDEF1X (standard)	Homework #1
  Oct 11	ER Studio & Logical Modeling
  Oct 13	ER Studio & Logical Modeling
  Oct 16	Normalization and ER Studio
  Oct 18	Normalization	U of Texas ITS
  Oct 20	Physical to MS Access databases	Logical to Physical to Database
  Oct 23	MS Access Database			Homework #2
  Oct 25	Review homework #2, modeling wrap-up
  Oct 27	test review
  Oct 30	midterm 1	Review
  Nov 1	Relational Algebra
  Nov 3	Simple SQL	SQL 2 & 3
  Nov 6	SQL joins	SQL 4
  Nov 8	SQL functions	SQL 5	JET SQL	Final project preliminary design
  Nov 10	SQL views	SQL 6
  Nov 13	SQL set operations	SQL 7		Homework #3
  Nov 15	Aggregates (Group By)	SQL 9
  Nov 17	SQL subqueries	SQL 8 & 10
  Nov 20	Database Applications - Mike Stafford
  Nov 22	More Hard SQL, Updates			Homework #4
  Nov 24	no class
  Nov 27	hw4 return, midterm review, course evaluations
  Nov 29	midterm 2	Review
  Dec 1	no class
  Dec 7	final project due by 4:30

• Late policy: All assignments are due by 4:30pm of the stated due date, though it is much safer to turn them in at class time. Late assignments are subject to a 10% per day penalty. Late assignments will not be accepted once the graded assignments are returned or once sample solutions are handed out. It is your responsibility to turn in the assignments on time.