Course Description
This course aims at teaching students how to deal with functional dependencies and normalization for relational database, concepts and theories of processing operations, concurrency control techniques, in addition to enable students to deal with databases recovery and deal with safe databases. This course includes detailed discussion of functional dependencies, normalization, relational database design, functional dependencies, normal forms, operation processing (introduction to operations processing, operations and systems concepts, characterizing schedules based on serialization , SQL), concurrency control techniques (purpose, two-phase locking, limitation of CCMs, index locking, and lock compatibility matrix).Moreover, Techniques of database recovery including types of failure, operation log, data update, data caching, transaction roll-back (undo) and roll forward, check pointing, and recovery of schemes), in addition to database security and transactions.
Course ID: COMP 315 N
Credit hours | Theory | Practical | Laboratory | Lecture | Studio | Contact hours | Pre-requisite | 3 | 2 | 2 | 4 | Concepts and Database Design 223 N COMP |
---|