PMAS Arid Agriculture University Rawalpindi

Gujrat Institute of Management Sciences

Department of Computer Science
Syllabus Fall/Spring 2024

I. Course code and Title

CSC-303 Advance database management systems

II. Course Prerequisites

Course Code Title
CSC-103 Database Management systems

III. Instructor’s Information

Full Name: Muhammad Ashar Javed

Email: [email protected]

Contact Number 03324994221

Office Hours & Location -

Teaching Assistant (if any) -

IV. Course Composition

Credit
Weekly Duration (hrs) Contact Hours
Hours
Lectures 3 2 1.5 3.0
Laboratories 1 2 1.5 3.0

V. Course Description
The course covers 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 (PL/SQL, T-SQL or similar technology), Integrity and security, Database
Administration (Role management, managing database access, views), Physical database
design and tuning, Distributed database systems, Emerging research trends in database
systems, MONGO DB, NO SQL (or similar technologies)

1
VI. Text book
1. Database Systems: A Practical Approach to Design, Implementation, and Management, 6th Edition
by Thomas Connolly and Carolyn Begg
2. Database Management Systems, 3rd Edition by Raghu Ramakrishnan, Johannes Gehrke

VII. Reference books & Material

1. Database System Concepts, 6th Edition by Avi Silberschatz, Henry F. Korth and S.
Sudarshan.
2. Database Systems: The Complete Book, 2nd Edition by Hector Garcia-Molina, Jeffrey D.
Ullman, Jennifer Widom
3. https://www.tutorialspoint.com
4. https://www.javatpoint.com/
5. https://www.mongodb.com/

VIII. Course Assessment

Theory Total Marks= 60 Grading Criteria:
Mid Exam Marks: 18 >=64 Grade A
QA (Including Labs): 12 >=52 Grade B
Final Exam Marks: 30 >=40 Grade C
Practical Total Marks= 20 >=32 Grade D
Project Marks: 06 <32 Grade F
Final Practical Marks: 14 Min. 24 marks required in theory and Min. 08 marks required in
Total Course Marks: 80 practical to pass the course.

IX. Course Outline and Contents

Lectur
Topics Covered Textbook Section
e

Introduction to Advanced Data Models

1 Thomas Connolly
Overview of advanced data models
Week 1
Object-Relational Models
2 Object-Oriented Models Thomas Connolly
Comparison with traditional relational models
Week 2 File Organization Concepts
3 Thomas Connolly
Introduction to file organization

Types of file organizations (heap, sequential, hashing, etc.)

4 Indexing and its types Thomas Connolly
B-trees and B+ trees
3
Week 3 Transactional Processing
5 Introduction to transactions Thomas Connolly
ACID properties

Transaction states
6 Thomas Connolly
Concurrent executions and serializability

Concurrency Control Techniques

7 Lock-based protocols Thomas Connolly
Week 4 Timestamp-based protocols

Optimistic concurrency control

8 Thomas Connolly
Deadlock handling

Recovery Techniques
9 Failure types Thomas Connolly
Week 5 Recovery algorithms (undo/redo logging)

Checkpointing
10 Thomas Connolly
ARIES algorithm

Query Processing and Optimization

11 Thomas Connolly
Steps in query processing
Week 6
Query optimization techniques
12 Cost-based optimization Thomas Connolly
Heuristic optimization
Database Programming - PL/SQL
13 tutorialspoint.com
Introduction to PL/SQL
Week 7 PL/SQL blocks, procedures, functions, triggers
14 Error handling tutorialspoint.com
Cursors
Database Programming - T-SQL
Week 8 15 Introduction to T-SQL tutorialspoint.com
T-SQL scripts and stored procedures
Triggers and views
16 tutorialspoint.com
Error handling
Integrity and Security
Week 9 17 Data integrity constraints tutorialspoint.com
User authentication and authorization
Role-based access control
18 tutorialspoint.com
SQL injection and prevention techniques
4
Database Administration
Week 10 19 Role management Oracle.com
Managing database access
Creating and managing views
20 Oracle.com
Backup and recovery strategies
Physical Database Design and Tuning
Week 11 21 Physical database design principles Thomas Connolly
Indexing strategies
Database partitioning
22 Thomas Connolly
Performance tuning techniques
Distributed Database Systems
Week 12 23 Introduction to distributed databases Thomas Connolly
Data fragmentation and replication
Distributed query processing
24 Thomas Connolly
Distributed transaction management
Emerging Research Trends in Database Systems
25 Thomas Connolly
Week 13 Current trends and technologies
Big Data and analytics
26 Cloud databases Thomas Connolly
In-memory databases
NoSQL Databases
Week 14 27 Introduction to NoSQL Mongodb.com
Key-value stores, document stores, column-family stores, graph
databases
28 CAP theorem Mongodb.com
Use cases and examples
MongoDB
Week 15 29 Introduction to MongoDB Mongodb.com
MongoDB data model
CRUD operations in MongoDB
30 Mongodb.com
Indexing and aggregation framework
Course Review and Final Project
31
Week 16 Review of key concepts covered in the course
Final project presentations
32
Q&A and wrap-up

5
X. Course Learning Outcomes (CLO)and Program Learning Outcomes
Upon completion of the course, students will be able to:
CLO Description PLO Domain BT Level

C1 Understanding advance data models, technologies and PLO1

approaches for building distributed database systems.
Applying the models and approaches in order to become PLO2
C2
enabled to select and apply appropriate methods for a
particular case
C3 To develop a database solution for a given scenario/ PLO2
challenging problem in the domain of distributed database
systems.
*BT- Bloom’s Taxonomy, C=Cognitive domain, P=Psychomotor domain, A=Affective domain

XI. Assessment Schedule - Tentative

Give your tentative assessment plan with submission due date.
S. Artifact Due Date Remarks
No.
1 Assignment 1/Quiz 1 Before
2 Assignment 2/ Quiz 2 Before Mid Term
3 Mid Term Week 8
4 Assignment 3/ Quiz 3 After Mid Term
5 Assignment 4/Quiz 4 Before Final Exam
6 Project/ Presentation
7 Terminal Examination Week 33/34
The course teacher may add quizzes, project or more assignment as he/she may deemed fit

XII. Policy & Procedures

 Attendance Policy: Every student must attend 75% of the lectures delivered in this course
and 7 5 % of the practical/laboratory work prescribed for the respective courses. The
students falling short of required percentage of attendance of
lectures/seminars/practical/laboratory work, etc., shall not be allowed to appear in the
terminal examination of this course and shall be treated as having failed this course.
 Grading Policy: The minimum passing marks for this course shall be 24 out of 60 in
theory. Students obtaining less than 24 marks out of 60 in this course shall be deemed to
have failed the course. Similarly, in practical’s, students must obtain at least 8 out of 20 to
pass this subject. Failing either theory or practical will be considered a failure in the course .
 Teaching Pedagogy: Classroom direct instructions, whiteboard, multimedia,
presentations, case studies, research papers, workshops, seminars and assignments, projects
 Academic Integrity: All policies regarding ethics apply to this course. The students
are advised to discuss their grievances/problems with their counsellors or course
instructor in a respectful manner.
 Plagiarism Policy: Plagiarism, copying and other anti-intellectual behavior are
prohibited by the university regulations. Violators may have to face serious
consequences.