Syllabus

CS 420: Database Management Systems

Spring 2014

Meeting Times: Lectures: M,T,Th HB 116, Labs: W HB 204
2:00 pm - 2:50 pm
Apr. 2 - Jun. 5
Instructor: Jim Schwing
Office: HB 219-C
Phone: 963 - 1432
E-mail: schwing@cwu.edu
Web Page: http://www.cwu.edu/~schwing
Office hours: 3:00 am - 4:00 noon, Wed. - Fri. and by appointment. Other available hours.
Text: Ullman & Widom, A First Course in Database Systems, 3rd Edition, Prentice Hall, 2008

Grading
Exams (25 & 25% each) 50%
Projects (3 - 10% each) 30%
Term Project 20%

Grading Scale
95 - 100 A
90 - 94 A -
87 - 89 B +
83 - 86 B
80 - 82 B -
77 - 79 C +
73 - 76 C
70 - 72 C -
60 - 69 D

Grading Note: The programming projects are an important part of the course. Students MUST PASS the project portion of the class to PASS the class.

Learning Outcomes and Course Objectives: This course looks at the theoretical and practical aspects of relational database systems including the design implementation of databases and the efficient storage of data.

The basic learning outcomes of the course are:

Honor Code: All work turned in for credit, including exams and all components of the project, are to be the work of the student whose name is on the exam or project. For all project components, the student can receive assistance from individuals other than the instructor only to ascertain the cause of errors. Thus you can get help if you need it to figure out why something doesn't work. You just can't get help from anyone, other than the instructor or TA, to figure out how to make something work. All solutions turned in for credit are to be your individual work and should demonstrate your problem solving skills, not someone else's.

The following text should appear on all assignments:
I pledge that I have neither given nor received help from anyone other than the instructor for all program components included here.

The student should sign his or her name under the pledge. Any deviation from this policy is an honor code violation and will be treated as such if detected. It should be included as a comment in your source code and part of your written report.

Class Attendance: Class attendance is expected.

ADA Statement: Students who have special needs or disabilities that may affect their ability to access information and/or material presented in this course are encouraged to contact me or the Director of Disability Support Services, on campus at 963-2171.

Caveat: The schedule and procedures for this course are subject to change. It is the student's responsibility to learn of and adjust to changes.

Course Schedule

Day Date Topic Readings - Item Due
L0 Apr 2 No Lab  
1 Apr 3 Introduction Reading: Ch. 1
2 Apr 7 Data Models and Relational Models Reading: Ch. 2.1, 2.2
3 Apr 8 Query Language, SQL basics Reading: Ch. 2.4, 6.1, 6.2
L1 Apr 9 Start Lab1  

4

Apr 10

SQL

Reading: Ch. 6.3.1 - 6.3.5

5 Apr 14 SQL Previous
6 Apr 15 Transactions Reading: Ch. 2.3, 2.5, 6.5, 7.1-7.3
L2 Apr 16 Continue Lab 1  
7 Apr 17 Constraints and Triggers Previous
8 Apr 21 Constraints and Triggers Previous
9 Apr 22 Relational Algebras and Queries

Reading: Ch. 5.1-5.2,6.3.6-6.3.8, 6.4

L3 Apr 23 Start Lab 2 Lab 1 due
10 Apr 24 Relational Algebras and Queries Previous
11 Apr 28 Views and Indexes Reading: Ch. 8.1-8.2, 8.5
12 Apr 29 Views and Indexes Previous
L4 Apr 30 Continue Lab 2  
13 May 1 Q & A
14 May 5 Exam 1  
15 May 6 The E/R Model Reading: Ch. 4.1
L5 May 7 Continue Lab 2  
16 May 8 The E/R Model Previous
17 May 12 Design Principles Reading: Ch. 4.2-4.4
18 May 13 Design Principles Previous
L6 May 14 Start Lab 3 Lab 2 Due
-- May 15 SOURCE Day - No Class  
19 May 19 From E/R to Relational Designs Reading: Ch. 4.5-4.6
20 May 20 From E/R to Relational Designs Previous
L7 May 21 Continue Lab3  
21 May 22 Functional Dependencies Reading: Ch. 3.1-3.2
-- May 26 Memorial Day - No Classes  
22 May 27 Design of Relational DB Schemas Reading: Ch. 3.3
L8 May 28 Continue Lab 3  
23 May 29 Decomposition Reading: Ch. 3.4
24 Jun 2 Third Normal Form Reading: Ch. 3.5
25 Jun 3 Multivalued Dependencies Reading: Ch. 3.6-3.7
L9 Jun 4 Finish Labs Lab 3 Due
26 Jun 2 Q & A  
-- Jun 10 Final Exam 4 - 6 pm -- subject to change - check Registrar's schedule when posted

Bar

Last updated: Mar. 26, 2014

JL Schwing schwing@cwu.edu
Department of Computer Science

All images and text are ©2014 Central Washington University
This material is subject to copyright and unauthorized use or copying is prohibited.