CIT 381, Fall 2011

Database Systems

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

• Time and Place:
  • MWF 11:00-11:50am in 112 Esslinger
  • Lab sessions
    • 1:00-1:50am Wednesday, room B26 Klamath
    • 1:00-1:50pm Friday, room B26 Klamath

• Instructor: Chris Wilson, 326 Deschutes, 346-3412, cwilson@cs.uoregon.edu.

• Teaching Assistant: Jason Gustafson, 360 Deschutes, 346-0199 jtg@cs.uoregon.edu.

• Office hours: Students can drop in anytime, make an appointment, or find us in our offices.
  • Chris: MWF 1:00-1:50 and (usually) 3:00-4:00
  • Jason: WF 2:00pm - 3: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	35%
  Test 1 (Nov 2)	17.5%
  Test 2 (Nov 30)	17.5%
  Final Project	30%

• Textbooks: We will try to go without text, though the text from 281 might have some use for the PHP section.

• Software: There are two main applications we will use in this course. Both will be provided on the lab machines:
  • ER Studio from Embarcadero
  • MySQL

• Labs: Lab attendence is required (up through Nov. 18, but not after that). You are responsible for knowing the material introduced in the lab. See here for lab hours.

• Homeworks: There will be 5(6?) 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.

• 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.

• Final Project: This will involve designing and implementing a small relational database, populating the database with some data, and building a few web pages using PHP that use SQL to extract data. We exect that you will work in teams of two. Part 1 of this project, an ER diagram, is due on Nov. 16.

• Tentative Syllabus [UNDER CONSTRUCTION]

  Date	Lecture Topic	Notes	Supplemental	Due
  Sep 26	introduction
  Sep 28	database concepts	relations	terms
  Sep 30	data modeling		requirements analysis
  Oct 3	ER Models	ER Basics
  Oct 5	Relational Keys		key exercise
  Oct 7	More ER Modeling	More ER Basics	ER example 2	Assignment 1
  Oct 10	Modeling with ER Studio		relationship types, relationship examples
  Oct 12	Modeling with ER Studio		relational key terminology
  Oct 14	More ER Studio Modeling	ER Modeling Difficulties
  Oct 17	More ER Studio modeling	Data Types		Assignment 2
  Oct 19	Normalization	Normalization	wikiNormalization
  Oct 21	Starting SQL	SQL intro	sql
  Oct 24	Simple Joins in SQL	SQL joins		Assignment 3
  Oct 26	Joins Again		join, union
  Oct 28	History of SQL, MySQL		relational algebra
  Oct 31	test review			Assignment 4
  Nov 2	Test 1
  Nov 4	PHP Review	PHP Arrays and Loops	php's foreach, more php
  Nov 7	More PHP
  Nov 9	SQL Outer Joins and Functions	common SQL functions
  Nov 11	SQL Functions and Views			Assignment 5
  Nov 14	SQL Set Operations	DML and subqueries	select at wikibooks
  Nov 16	SQL Aggregates	execution order		part 1 final project due
  Nov 18	SQL Group By	hard sql
  Nov 21	SQL Transactions and Concurrency	transactions
  Nov 23	tbd			Assignment 6
  Nov 24	no class: Thanksgiving
  Nov 28	test review
  Nov 30	test 2
  Dec 2	open class to discuss project
  Dec 6	final project due			Final project

• 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.