National University of Sciences & Technology (NUST)
Department of Computer Science
Advanced Database Concepts
(Tentative)
Course Code : CS-820 Semester: 1st (Fall 2024)
Credit Hours: 3+0 Prerequisite None
Codes:
Instructor: Hafiz Syed Muhammad Class: MSIT-2K24
Bilal
Office: A-301 (Faculty Telephone: 051-8862164
Block, SEECS)
Lecture Days: As per timetable E-mail: [Link]@[Link]
Class Room: As per timetable Consulting Hours: Monday 5:00 pm to 7:00
pm
Course Description
The course focuses generally on the advanced concepts prevail in databases. This course covers: files storage
and structures; indexing and hashing, query processing component of a relational database system;
Fundamental knowledge of transaction processing i.e., concurrency control and database recovery; NoSQL
Database, Fundamental knowledge of XML/JSON data management and its query languages.
Course Objectives
Databases are at the heart of modern commercial application development. The objective of the course is to
familiarize students with the concepts and applications of advanced techniques in database systems, Students
can apply advanced database concepts for complex issues and manage and manipulate advanced database
processing.
Program Objectives
The MS (IT) degree aims to equip graduates with a range of technical, business and behavioral skills needed for
the successful implementation and management of Information Technology in todays’ business environment.
Graduates of the program take appropriate IT professional positions in industry and organizations, or pursue
higher education and research in related disciplines.
Books
Text Books 1. Database System Concepts, Seventh Edition, Avi Silberschatz, Henry F.
Korth,S. Sudarshan, 2019, McGraw-Hill
2. MongoDB in Action, second Edition, Manning publications, 2016
3. GraphDatabases in Action, Examples in Gremlin, Manning publications, 2020
Reference 1. [Link]
Materials 2. Web is the greenest book.
Page 1 of 2
National University of Sciences & Technology (NUST)
Department of Computer Science
Week No Topics Activity
1 Relational Database Fundamentals Lecture
2 Relational Algebra, SQL, Normalization, Lecture/discussion
3 Amalgamation of Databases in today modern applications Lecture
4 Disk Storage and Basic File Structure Lecture/Class Activity
5 Hashing and Indexing Techniques
6 Hashing and Indexing Techniques Lecture/ Assignment N0.1
7 Query Processing Lecture/ Class Activity
8 Query Processing Lecture/ Final Project
proposal Submission
9 Mid Term
10 Query Optimization
11 Query Optimization Assignment No.02
12 Transaction Management Lecture
13 Concurrency Control Lecture
14 Concurrency Control Lecture
Database Recovery Techniques Lecture
15 NoSQL databases Assignment no.03
16 Semi Structure data models XML/Jason Lab Work/ Class Activity
17 Project Viva Project Viva
18 ESE
Course Assessment Weightages (In accordance with NUST statutes)
Theory: 100%
o Assignments and Quizzes: 20%
o Midterm:30 %
o End Semester Exam: 40%
o Project: 10%
Grading Policy
Quiz Policy: The quizzes may be unannounced and normally last for ten minutes. The question framed is to
test the concepts involved in last few lectures.
Assignment Policy:
In order to develop comprehensive understanding of the subject, assignments will be given. Late assignments
will not be accepted / graded. All assignments will count towards the total (No ‘best-of’ policy). The students
are advised to do the assignment themselves. Copying of assignments is highly discouraged and violations will
be dealt with severely by referring any occurrences to the disciplinary committee. The questions in the
assignment are meant to be challenging to give students confidence and extensive knowledge about the
subject matter and enable them to prepare for the exams.
Plagiarism:
SEECS maintains a zero-tolerance policy towards plagiarism. While collaboration in this course is highly
encouraged you must ensure that you do not claim other people’s work/ ideas as your own. Plagiarism occurs
when the words, ideas, assertions, theories, figures, images, programming codes of others are presented as
your own work. You must cite and acknowledge all sources of information in your assignments. Failing to
comply with the SEECS plagiarism policy will lead to strict penalties including zero marks in assignments and
referral to the academic coordination office for disciplinary action.
Page 2 of 2
