Namal University Mianwali

Department of Computer Science

1. COURSE DETAILS
Course Title: Database Systems
Course Code: CSC-271
Credits (Theory + Lab): 4 (3+1)
Lecture Hours/Week: 3
Lab Hours/Week: 3
Pre-Requisite: None
Brief Course Description:
This course introduces the fundamental concepts and practical skills required for designing, implementing, and
managing relational database systems. Students learn conceptual modeling using ER and Enhanced ER diagrams,
relational schema design, normalization, and functional dependency analysis to ensure data integrity. The course
emphasizes Structured Query Language (SQL) for data definition, manipulation, querying, and transaction
management. Advanced topics such as indexing, query optimization, physical database design, and concurrency
control are also covered. Through hands-on labs and a semester project, students develop real-world database
applications and gain experience in integrating databases with software systems.

2. INSTURCTOR DETAILS
Name: Ms. Asiya Batool
Lecture Timings: Tuesday: 10:30 AM to 11:55 AM
Friday: 09:00 AM to 10:25 AM
Office Hours: Monday to Thursday 02:00 PM to 03:30 PM
Office Location: Room # 16, CS Department
Office Phone: Ext. 173
Email: [Link]@[Link]

3. COURSE UNIT WISE MAJOR TOPICS

No of Teaching
Unit No. Topics
Hours
1 Introduction to Database Systems 4.5
2 Logical Database Design 12
3 Relational Database Design 6
4 Physical Database Design 7.5
5 Structured Query Language 15
Total Contact Hours 45

4. COURSE LEARNING OUTCOMES (CLOs)

 Unit Taxonomy
Sr. No CLO Statement GA
No Level
CLO’s for Theory
Explain fundamental database concepts and their role in
CLO-1 1-4 C2 1
storing, and managing data for software applications
Design logical, relational, and physical database models
CLO-2 2,3,4 C5 4
for real-world problems
Analyze functional dependencies and apply normalization
CLO-3 3 C4 3
techniques to improve data integrity
Apply database querying techniques to define, manipulate,
CLO-4 5 C3 2
and retrieve data efficiently
CLO’s for Lab
Design relational databases based on given problem
CLO-1 2 C5 4
scenarios
Implement SQL queries to define, manipulate, and
CLO-2 5 C3 5
retrieve data accurately
Demonstrate responsibility and collaboration in
CLO-3 - A3 6
individual and team-based work

5. WEEKLY LECTURE BREAKUP

Reference in
Lecture Unit
# #
Topics Covered in Class Topics Covered in Lab Book /
Assessments
Overview of the course,
Basic terminologies related to
1 1 database systems, The need of a TB: Ch 01
database, Application of database, Installation of a DBMS,
Operational vs Analytical Databases Import Schema, Managing
Comparison of SQL and NoSQL User Access (Non Graded)
databases, File Systems vs. Database
2 1 TB: Ch 01
Systems, Database System
Architecture (3-tier architecture)
Introduction to databases, Select, From, Aliasing
3 1 TB: Ch 04
Terminologies, Concept of Keys Columns and Tables,
Arithmetic Operations in
Introduction to SQL, Select, from SELECT, Concatenation of
4 5 TB: Ch 06
Clause in SQL Strings, Built-in Functions
in Select (CLO-2, CLO-3)
Database languages – DQL
Conditions in Where clause TB: Ch 06
5 5 Conditions in Where – [In, Between,
with different datatypes Quiz 1
Like, Not, And, Or],
In, Between, Not, And, Or,
TB: Ch 06
Order by, Use of Limit and Top, Searches with Like, Order
CCP Part 1 -
6 5 Null, Extracting data from multiple by, Limit, Top
Project
tables in SQL (CLO-2, CLO-3)
Proposal
Introduction to database design - ER Joining Multiple Tables
7 2 Diagrams using conditions in Where TB: Ch 07
Defining Entities clause.
 Strong VS Weak Entities (CLO-2, CLO-3)
Defining Attributes, Types of
TB: Ch 02
8 2 Attributes
Associative Entity
Defining Relationship
9 2 TB: Ch 02
Types of Relationship Joining multiple tables
Mapping Cardinalities using Join Clauses
10 2 Types of Participation (CLO-2, CLO-3) TB: Ch 02
Multiple Relationships
11 2 ERD Case Studies TB: Ch 02
Enhanced-ERD Designing an ERD
TB: Ch 03
12 2 Supertype/Subtype Entities (CLO-1, CLO-3)
Quiz 2
Specialization/Generalization
Specifying Constraints in
13 2 Supertype/Subtype Relationships: TB: Ch 03
Completeness Constraints Designing an EERD
Specifying Constraints in (CLO-1, CLO-3)
14 2 Supertype/Subtype Relationships: TB: Ch 03
Disjointness Constraints
TB: Ch 06
Aggregate functions: COUNT, SUM, CCP Part 2 –
15 5 AVG, MIN, MAX, and grouping Conceptual
data with GROUP BY Lab Mid Term Exam Model ERD
(CLO-1, CLO-2, CLO-3) Diagram
Filtering groups using the HAVING
TB: Ch 06
16 5 clause and final discussion on query
Quiz 3
results
Mid Term Exam
Relational Schema Aggregation, Conditions in
17 3 TB: Ch 04
Integrity Constraints Having clause, Different
Converting ERD to Relational filters in Where and Having
18 3 TB: Ch 04
Schema clauses (CLO-2, CLO-3)
19 5 Data Definition Language DDL Queries: Table TB: Ch 06
Creation, Defining Columns
20 5 Data Manipulation Language and Constraints TB: Ch 06
(CLO-2, CLO-3)
Understanding Normalization and
Anomalies, Functional TB: Ch 04
21 3 DML Queries: Data
Dependencies: Definition and Quiz 4
insertion, editing and
Examples
deletion
1st Normal Form,
(CLO-2, CLO-3)
22 3 2nd Normal Form, TB: Ch 04
3rd Normal Form
Nested queries, Single row
23 5 subqueries, Multi row subqueries TB: Ch 07
(IN, ANY and ALL operators) Nested queries
Aggregation in both/either Outer and (CLO-2, CLO-3) TB: Ch 07
24 5 Inner queries, EXISTS CCP Part 3 –
Relational
 Schema and
the database
Views, Stored Functions and
25 5 TB: Ch 07
Procedures Connecting the MySQL
Physical Database Design, Storage database with a high-level
Fundamentals: Disk Structure, language backend TB: Ch 05
26 4
Storage Hierarchy, Pages, blocks, (CLO-2, CLO-3) Quiz 5
rows
Indexing: Concepts and Usage, File
27 4 Triggers, Views, Stored TB: Ch 05
Organization Techniques
functions, Stored procedures
Query Optimization: Execution
28 4 (CLO-2, CLO-3) TB: Ch 05
plans, Query efficiency
Transactions: ACID Properties,
29 4 Concurrency Issues: Problems and TB: Ch 07
Solutions
Implementing transactions TB: Ch 07
using SQL commands CCP Part 4 –
Concurrency Control Techniques:
(CLO-2, CLO-3) GUI
30 4 Locks, Timestamps
Application
Role of DBMS in AI systems
connected
with database
31 - Project Exhibition Final Lab Exam -
32 - Course Review (CLO-2, CLO-3) -
Final Term Exam

6. CLO ASSESSMENT MECHANISM

Course CLOs Assessment
Assessment Tool CLO-1 CLO-2 CLO-3 CLO-4
Quizzes (5) ✔ ✔ ✔ ✔
Complex Computing Problem (CCP) ✔ ✔ ✔
Mid Term Exam ✔ ✔ ✔
Final Term Exam ✔ ✔ ✔ ✔
Lab CLOs Assessment
Assessment Tool CLO-1 CLO-2 CLO-3
Graded Labs (13) ✔ ✔ ✔
Project ✔
Mid Term Exam ✔ ✔ ✔
Final Term Exam ✔ ✔ ✔

7. TEACHING MATERIAL
Text Books:
1. Modern Database Management: Jeffrey A. Hoffer, V. Ramesh Heikki Topi (13th Edition) 2019.
2. Introduction to Database Systems, (8th Edition) by C. J. Date 2003
Reference Material:
1. Silberschatz, Abraham, Henry F. Korth, and Shashank Sudarshan. Database system concepts. (Seventh
Edition), McGraw-Hill, 2019
2. Database systems: A Practical Approach to Design, Implementation, And Management, Thomas Connoll
y, Carolyn Begg, Pearson, 2015.

8. POLICY & PROCEDURES

• Attendance Policy: Students must attend 75% of this course's lectures. Students who fall short of the
required attendance percentage cannot appear in the terminal examination.
• Plagiarism Policy: Namal University's rules and regulations prohibit plagiarism, copying, and other
dishonest behavior. Violators will face serious disciplinary action.
• Assessments Percentage Distribution:
Course Assessments
Sessional Mid Term Final Term
Total
Quiz CCP Exam Exam
15 15 30 40 100
Lab Assessments
Mid Term Exam
Graded Labs Project Final Term Exam Total
(Open Ended Lab)
50 5 15 30 100

9. VERIFICATION
(i) I verify that the content of this document is correct and up-to-date.

Feb 11, 2026

Ms. Asiya Batool Date
Instructor’s Name and Signature

(ii) I have reviewed course-outline and state that it complies with Namal University policies and
guidelines.

Feb 11, 2026

Date
Dr. Muhammad Ali Shahid
Name and Signature of Head of Department