CIS119DO Trollen Class Assignments

Note: Items appearing with yellow shading are subject to change.

Date	Class	Assignments Due
25-Jan Wed	2	Assignment 1 (Syllabus) Assignment 2 (Off-campus access to SQL Developer) Assignment 3 (Chapter 1, Labs 1&2) Assignment 4 (Chapter 1, Lab 3) Assignment 5 (Chapter 2, Labs 1&2)
01-Feb Wed	3	Assignment 6 (Database Design and Data Redundancy) Assignment 7 (Chapter 3, Labs 1&2) Assignment 8 (Chapter 4, Labs 1&2)
08-Feb Wed	4	Applying SQL #1 Assignment 9 (Chapter 4, Lab 3) Assignment 10 (Chapter 5, Labs 1&2)
15-Feb Wed	5	Applying SQL #2 Assignment 11 (Chapter 5, Lab 5) Assignment 12 (Chapter 6, Labs 1&2)
22-Feb Wed	6	Assignment 13 (Chapter 7, Labs 1&2) Assignment 14 (Database design in-class handouts) Assignment 15 (Chapter 1, specified pages only)
29-Feb Wed	7	Applying SQL #3 Read the Restaurant Inspector Design Problem, then write out an ER diagram showing the entities and relationships between the entities.
07-Mar Wed	8	Do the Fundraiser Design Problem Do the Tower of Power Design Problem
14-Mar Wed		Spring Break
21-Mar Wed	9	Midterm Exam The midterm exam is worth 100 points. It will consist of approximately 45 multiple choice questions, 10 written SQL statements, and 1 relational design problem.
28-Mar Wed	10	Assignment 16 (Chapter 9) Assignment 17 (Chapter 8, Labs 1 & 2) Assignment 18 (Chapter 8, Labs 3 & 4)
04-Apr Wed	11	Assignment 19 (Chapter 10) Assignment 20 (Chapter 11, Labs 1 & 2)
11-Apr Wed	12	Applying SQL #4 Assignment 21 (Chapter 12, Lab 1) Assignment 22 (Chapter 12, Lab 2)
18-Apr Wed	13	Applying SQL #5 Assignment 23 (Chapter 13, Labs 1-3)
25-Apr Wed	14	Applying SQL #6 Assignment 24 (Chapter 14, Lab 1)
02-May Wed	15	Assignment 25 (Chapter 14, Lab 2) Assignment 26 (Chapter 15)
09-May Wed		Applying SQL #7 Comprehensive Final Exam  (6:30-8:30) The final exam is comprehensive and is worth 150 points. It will consist of approximately 45 multiple choice questions, 10 written SQL statements, 3 short answer questions, and 1 relational design enhancement (i.e., a modification to an ER diagram). Approximately 75% of its points are allocated to the material we've studied after the midterm exam. If you would like to continue using our cis119do database after the semester ends, use the link below to send an email to tom.trollen@sccmail.maricopa.edu. At some point I may need to rebuild our Oracle server. If so, I will try to send you an email a week or so in advance to give you an opportunity to request an account in the new database.

Page maintained by Tom Trollen. Feedback welcome.

Last updated: 05/04/2011 Disclaimer