COMPUTER 7380 Advanced Database Management Systems – Spring 2018

Instructor:Dr. Qi Yang
Office:Ullrich 213 Phone:(608) 342-1418 Email:

Office Hour:See

Meets:3:00 – 5:50 Wednesday

Textbook:Database Management Systems by R. Ramakrishnan and J. Gehrke, 3rd Edition, McGraw Hill.

Course Description:

Overview of Database Systems, Relational Model, Relational Algebra, Relational Calculus and SQL.Study of Database Applications Development, including modeling and designing database systems, and the implementation of Database-Backed Internet applications. Cover advanced Database topics such as Storage and Indexing, Query Evaluation, Transaction Management, Concurrency Control and Crash Recovery.

Student LearningOutcomes:

Upon completion of this course, students should be able to

  • Design relational databases with ER data model
  • Create SQL queries with constraints and triggers
  • Develop Database-Backed Internet applications
  • Evaluate cost of Database operations
  • Understand Query evaluation and optimization
  • Understand transaction management,concurrency control and crash recovery

Grading:

Components / Point / Percentage
Midterm Exam / 120 / 24%
Final Exam / 100 / 20%
8 Assignments / 100 / 20%
1 Project / 80 / 16%
4 Quizzes / 100 / 20%
Total / 500 / 100%

Grade:

Overall Percentage / Awarded Grade
>= 93% / A
>= 90% and < 93% / A-
>= 87%and <90% / B+
>= 83%and <87% / B
>= 80%and < 83% / B-
>= 77% and < 80% / C+
>= 73%and < 77% / C
>= 70%and <73% / C-
>= 67%and <70% / D+
>= 60%and < 67% / D
< 60% / F

Tentative Schedule:

Week / Topics / Text Chapter
1 / Database Design and ER Model / Chapter 1 - 2
2 / Relational Model, Relational Algebra and Relational Calculus / Chapter 3 - 4
3 - 4 / SQL: Queries, Constraints and Triggers / Chapter 5
5 - 6 / Database Application development / Chapter 6 - 7
7 / Overview of Storage and Indexing / Chapter 8 - 9
8 / Tree-Structured Indexing / Chapter 10
9 / Overview of Query Evaluation / Chapter 12
10 / Evaluating Relational Operators / Chapter 14
11 / Relational Query Optimizer / Chapter 15
12 / Overview of Transaction Management / Chapter 16
13 / Transaction Support in SQL
14 / Concurrency Control / Chapter 17
15 / Parallel and Distributed Databases / Chapter 22

Additional Notes:

  1. You are expected to read the corresponding text chapters and supplemental readings, including research papers.Lecture notes, supplemental readings and announcements will be posted onDesire2Learn at
  2. Programs or assignments must be turned in or demonstrated by the due date. Late submissions are worth 0 points. The ONLY exception to this rule is a Doctor's Excuse for an illness lasting more than 3 days.
  3. Sometimes absence from class is unavoidable because of illness. Such illness should be reported to the Student Health Services. Emergencies other than illness that cause absence from classes should be reported to the Office of Student Affairs. Such students are expected to meet with their instructors as soon as possible after the crisis has passed and arrange to make up any missed work.
  4. An exam missed because of an excused absence such as illness verified by physician or participation in an authorized university activity can be made up, provided the instructor is notified in advance.
  5. Academic misconduct: You are responsible for honestly completing and representing your work, for appropriately citing sources, and for respecting the academic endeavors of others. You will be penalized for violating these standards and may even be expelled from the University. See Student Handbook for details.
  6. Students have the right to miss class for religious observances. Students wishing time off for this reason should let the instructor know within the first two days of class.
  7. If you need an accommodation due to a disability, please make an appointment to see me during my office hours. A VISA from Services for Students with Disabilities authorizing your accommodations will be needed. Contact 608-342-1818 for more information about SSWD.

1 | Page