CS 420: Database Management Systems
|Meeting Times:||Lectures: M,T,Th HB 116, Labs: W HB 204|
2:00 pm - 2:50 pm
Apr. 2 - Jun. 5
|Phone:||963 - 1432|
|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|
|Exams (25 & 25% each)||50%|
|Projects (3 - 10% each)||30%|
|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.
|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|
Reading: Ch. 6.3.1 - 6.3.5
|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|
Last updated: Mar. 26, 2014
All images and text are ©2014 Central Washington University
This material is subject to copyright and unauthorized use or copying is prohibited.