PMAS Arid Agriculture University Rawalpindi

University Institute of Information Technology

CS-601 Database Administration & Management

Credit Hours: 4(3-3) Prerequisites: Database Systems
Teacher:

Course Description:
Introduction to advance data models such as object relational, object oriented. File
organizations concepts, Transactional processing and Concurrency control techniques,
Recovery techniques, Query processing and optimization, Database Programming,
Integrity and security, Database Administration, Physical database design and tuning,
Distributed database systems, Emerging research trends in database systems.
Course Objective:
Student should be able to fully understand the concepts and technical issues of database administration.
Student should be able to develop understanding of internal functionality of DBMS. Student should be
able to perform database administration tasks like backup and recovery and performance tuning of
databases.

Teaching Methodology:
Lectures, Assignments, Presentations, etc. Major component of the course should be
covered using conventional lectures.
Courses Assessment:
Exams, Assignments, Quizzes. Course will be assessed using a combination of written
examinations.
Reference Materials:
 Fundamentals of Database Systems, by Ramez Elmasri and Shamkant
Navathe, Addison Wesley, 5th Edition.
 Database System Concepts by Henry F. Korth and Abraham Silberschatz, 4th
edition, McGraw Hill, 2002, ISBN: 0-07-12268-0

 Oracle Essentials, 5th Edition by Jonathan Stern, Rick Greenwald, Robert Stackowiak, O'Reilly
Media, Inc. ISBN: 9781449343033

Course Learning Outcomes (CLOs):

At the end of the course the students will be able to: Domain BT Level*
1. Define and devise transaction management, concurrency control,
C 2
crash recovery components
2. Design, model and install any database management systems by
C 3
using Oracle database as sample.
3. Plan, design, construct, control and manage database instances,
database network environment, storage structures, user security, C 3
database backup and recovery, database maintenance
4. Examine and perform data base administration roles and operations
C 4
by using Oracle database system as a sample
5. Compare and contrast by examining the database systems and new
C 5
trends in data storage, data retrieval and maintenance techniques.
* BT= Bloom’s Taxonomy, C=Cognitive domain, P=Psychomotor domain, A= Affective
doma

Week/Lecture # Theory
Structure of Relational Databases, Relational Algebra,Tuple
Lect-I Relational Calculus, Domain Relational Calculus
Week
1 Extended Relational-Algebra-Operations, Modification of the
Lect-II Database, Views

Query-by-Example (QBE), Datalog

Lect-I
Week
2 Domain Constraints , Referential Integrity, Assertions, Triggers
Lect-II
Security, Authorization ,Authorization in SQL
Lect-I
Week
First Normal Form, Pitfalls in Relational Database Design,
3
Lect-II Functional Dependencies, Decomposition

Boyce-Codd Normal Form, Third Normal Form, Multivalued

Dependencies and Fourth Normal Form, Overall Database Design
Lect-I
Process
Week
4
Complex Data Types, The Object-Oriented Data Model, Object-
Lect-II Oriented Languages

Nested Relations, Complex Types and Object Orientation,

Lect-I Querying with Complex Types
Week
5 Creation of Complex Values and Objects, Comparison of Object-
Lect-II Oriented and Object-Relational Databases

Measures of Query Cost, Selection Operation ,Sorting, Join

Lect-I Operation
Week
6
Other Operations, Evaluation of Expressions
Lect-II
Week Lect-I Catalog Information for Cost Estimation, Estimation of Statistics
 Transformation of Relational Expressions and Dynamic
7
Lect-II Programming for Choosing Evaluation Plans

Transaction Concept, Transaction State, Implementation of

Atomicity and Durability, Concurrent Executions
Lect-I
Week
8
Recoverability, Implementation of Isolation,Transaction Definition in
Lect-II SQL Testing for Serializability.

Mid Term Exam

Lock-Based Protocols, Timestamp-Based Protocols, Validation-
Lect-I Based Protocols, Multiple Granularity
Week
9 Failure Classification, Storage Structure, Recovery and Atomicity
Lect-II Log-Based Recovery

Shadow Paging, Recovery With Concurrent Transactions, Buffer

Lect-I
Management, and Failure with Loss of Nonvolatile Storage.
Week
Advanced Recovery Techniques, ARIES Recovery Algorithm
10
Lect-II Remote Backup Systems.

Centralized Systems, Client--Server Systems, Parallel Systems

Lect-I
Week
11 Distributed Systems, Network Types
Lect-II
Heterogeneous and Homogeneous Databases, Distributed Data
Lect-I Storage, Distributed Transactions, Commit Protocols
Week
Concurrency Control in Distributed Databases, Availability,
12
Distributed Query Processing, Heterogeneous Distributed
Lect-II
Databases and Directory Systems.

Introduction, I/O Parallelism, Interquery Parallelism, Intraquery

Lect-I Parallelism
Week
13 Intraoperation Parallelism, Interoperation Parallelism and Design of
Lect-II Parallel Systems

Web Interfaces to Databases, Performance Tuning, Performance

Lect-I Benchmarks, Standardization
Week
14
E-Commerce, Legacy Systems
Lect-II
Week Lect-I Decision-Support Systems, Information-Retrieval Systems
 15
Temporal Data, Spatial and Geographic Databases, Multimedia
Lect-II Databases, Mobility and Personal Databases

Week Lect-I Project Presentation

16 Lect-II Project Presentation
Final Term Exam