CS 420: Database Management Systems
|Meeting Times:||Lectures: M,T,Th HB 116, Labs: W HB 204|
2:00 pm - 2:50 pm
Mar. 26 - May 30
|Phone:||963 - 1432|
|Office hours:||11:00 am - 12:00 noon, Mon - Wed. 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|
|1||Mar 26||Introduction||Reading: Ch. 1|
|L0||Mar 27||No Lab|
|2||Mar 28||Data Models and Relational Models||Reading: Ch. 2.1, 2.2|
|3||Apr 1||Query Language, SQL basics||Reading: Ch. 2.4, 6.1, 6.2|
Reading: Ch. 6.3.1 - 6.3.5
|L1||Apr 3||Start Lab1|
|6||Apr 8||Transactions||Reading: Ch. 2.3, 2.5, 6.5, 7.1-7.3|
|7||Apr 9||Constraints and Triggers||Previous|
|L2||Apr 10||Continue Lab 1|
|8||Apr 11||Constraints and Triggers||Previous|
|9||Apr 15||Relational Algebras and Queries||
Reading: Ch. 5.1-5.2,6.3.6-6.3.8, 6.4
|10||Apr 16||Relational Algebras and Queries||Previous|
|L3||Apr 17||Start Lab 2||Lab 1 due|
|11||Apr 18||Views and Indexes||Reading: Ch. 8.1-8.2, 8.5|
|12||Apr 22||Views and Indexes||Previous|
|13||Apr 23||Q & A|
|L4||Apr 24||Continue Lab 2|
|14||Apr 25||Exam 1|
|15||Apr 29||The E/R Model||Reading: Ch. 4.1|
|16||Apr 30||The E/R Model||Previous|
|L5||May 1||catch-up Day|
|17||May 2||Design Principles||Reading: Ch. 4.2-4.4|
|18||May 6||Design Principles||Previous|
|19||May 7||From E/R to Relational Designs||Reading: Ch. 4.5-4.6|
|L6||May 8||Start Lab 3||Lab 2 Due|
|20||May 9||From E/R to Relational Designs||Previous|
|21||May 13||Functional Dependencies||Reading: Ch. 3.1-3.2|
|22||May 14||Design of Relational DB Schemas||Reading: Ch. 3.3|
|L7||May 15||Continue Lab3|
|23||May 16||Design of Relational DB Schemas||Previous|
|24||May 20||Decomposition||Reading: Ch. 3.4|
|25||May 21||Third Normal Form||Reading: Ch. 3.5|
|L8||May 22||Continue Lab 3|
|26||Mar 23||Multivalued Dependencies||Reading: Ch. 3.6-3.7|
|--||Mar 27||Memorial Day - No Classes|
|27||Mar 28||Catch-up Day|
|L9||Mar 29||Finish Labs||Lab 3 Due|
|28||Mar 30||Q & A|
|--||Jun 5||Final Exam 12 noon - 2 pm -- subject to change - check Registrar's schedule when posted|
Last updated: Mar. 21, 2013
All images and text are ©2013 Central Washington University
This material is subject to copyright and unauthorized use or copying is prohibited.