جامعة جرش
كلية تكنولوجيا المعلومات / / JerashUniversity
InformationTechnologyCollege
Dean’s Office

Course Title:Advanced Database

Course prerequisite(s) and/or corequisite(s):1002140 / Course code: 1002342
Credit hours: 3 / Course Level:
Semester/Lecture Time:

Instructor Details

Instructor Name
/
e-mail
/
Office Hours

Course Description

This course covers advanced database management system design principles and techniques. The course materials will be drawn from both classic and recent research literature. Planned topics include modeling, logical design, physical design, query optimization, concuruncy control, database recovery, database security, data warehousing, data mining, distributed databases, and others.

Objectives

This course will help students to achieve the following objectives.

  • Learn new ways to model data.
  • Implement a DBMS.
  • Become familiar with the expanding role of database technology.
  • Learn more of advanced topics that include the following:
  • Logical design
  • Physical data organization
  • Query Optimization
  • Concurrency control
  • Recovery
  • Database security
  • Emerging technologies

Course Contents:

Week / Topics / Topic Details / Reference (chapter) / Date
1 / Review / DBMS
Data modeling
SQL / Chp. 1-4 / Oct: 3-9
2,3 / Models / Relational Model - DRC and TRC
Historical Models - Appendix C, D
  • Network Model
  • Hierarchical Model
Logic/Deductive
OODBMS
XML and semistructured / Chp.5-7 / Oct: 10-30
4, 5 / Logical Design / Properties of a good design
Functional dependencies and keys
Normal forms: 3NF, BCNF, 4NF
Decomposition algorithms / Chp. 10-11 / Oct: 31– Nov:13
First Exam/ Projects Discussion
6, 7 / Physical Data Organization / Relational structures: heap, sorted, compressed
Indexes: primary and secondary, B-trees / Chp.14, Chp.16 / Nov:14 – 27
8, 9 / Query Optimization / Heuristic (logical) optimization
Cost-based (physical) optimization / Chp.15 / Nov: 28- Dec: 11
10 / Concurrency Control / ACID
Serializability
Two-phase locking / Chp.18 / Dec: 12– 18
Second Exam
11,12 / Recovery / System log
Undoing and redoing / Chp.19 / Dec: 19–Jan: 1
13 / Security / Roles
Properties / Chp.23 / Jan: 2–8
14 / Future Topics / XML
Data warehousing
Data mining
Distributed databases
Next-generation database technologies / Chp.27-29 / Jan: 9 - 15
Project Submission
Final Exam / Jan: 16 – 20

Assessment and Grade Distribution

Assessment / Requirements / Points / Total
Assignment and Projects / 20%
Project / 15%
Presentation & Discussion / 5%
Individual Work / 80%
Attendance, Participation, Home works and short report / Chapter Homework’s, Discussions, Short Presentations / 10%
Quizzes / Unannounced Short quizzes
First Exam / Multiple Choice Questions worth 25% and Essay Questions worth 75% of exam grade. / 15%
Second Exam / Multiple Choice Questions worth 25% of and Essay Questions worth 75% of exam grade. / 15%
A Comprehensive Final examination / Multiple Choice Questions worth 25% and Essay Questions worth 75% of exam grade. / 40%
TOTAL / 100%

Teaching and Learning Methods:

  1. Interactive lectures

Interactive lectures using PowerPoint slides and available audio/visual tools in order to facilitate the teaching process and develop students understanding. Students will be invited to share their views and experience their knowledge. In addition, students will be asked to provide their feedback in regular bases.

  1. Group Projects and Presentation

A list of suggested research projects will be available at the beginning of the semester. Each student will submit a short proposal of the selected project, starting from the second week of classes. The proposal should identify the main idea, contents, time and plan, tools and applications that will be employed in the project. Once the project is approved by the instructor, the students can continue their work and will submit their project along with a 15 minutes presentation at the end of semester.

  1. Outside-classroom activities

Experts from academic and industrial institution will be invited to provide lectures on selected subjects covered within this course.

Text Book and References:

Text Book
/
Elmasri, R. and Navathe, S., Fundamentals of Database Systems, 5th Edition, 2005, Addison Wesley Longman.
[R1]
/
Lecture Notes
[R2]
/
Rob, P. and Coronel, C., Database Systems: Deign, implementation and management, 5th Edition, 2001, Course Technology.

------