CEN 416: Distributed Database Systems

Offered Under: B.Sc. in Computer Engineering (CEN)
Description

A detailed study of advanced topics on relational database theory, query processing and optimization, recovery techniques, concurrency control, data fragmentation, replication, security and integrity of distributed database systems. Discussion on heterogeneous databases and paradigms (deductive, object oriented) used in distributed systems.



Course Type Major
Credit Hour 3
Lecture Hour 45
Expected Outcome(s):
  • Analyze real-word data management scenarios and design appropriate data schemas.
  • Formulate SQL queries to access a relational database system.
  • Design and develop data management applications using relational database systems.
  • Analyze and apply query optimization techniques for optimizing query.
  • Analyze and apply data indexing techniques for speeding up query processing.
  • Analyze and apply transaction processing techniques for executing transactions in relational database systems


Grading Policy:

Biweekly Quiz, One Midterm Exam, One Final Exam, Project


Letter Grade Marks Grade Point
A 90 - 100 4.00
A- 85 - 89 3.70
B+ 80 - 84 3.30
B 75 - 79 3.00
B- 70 - 74 2.70
C+ 65 - 69 2.30
C 60 - 64 2.00
C- 55 - 59 1.70
D+ 50 - 54 1.30
D 45 - 49 1.00
F 00 - 44 0.00