BSCS students can now download the complete IT Series textbook “A Fundamental Study of Database Management Systems” in PDF format. Written by Imran Saeed, Tasleem Mustafa, Tariq Mahmood, and Ahsan Raza Sattar, this 3rd edition covers the full DBMS course as taught in Pakistani universities — with complete SQL and MS Access chapters, plus hundreds of short questions, MCQs, and true/false exercises.
This book is designed specifically for Pakistani university students preparing for DBMS exams. It covers both theory and practical implementation side by side. Whether you are studying for finals or working on an MS Access project, this guide has you covered from Chapter 1 all the way to Chapter 16.
Book Overview
- Class: BSCS
- Subject: Database Management Systems
- Series: IT Series
- Edition: 3rd Edition
- Authors: Imran Saeed, Tasleem Mustafa, Tariq Mahmood, Ahsan Raza Sattar
- Total Chapters: 16
- Format: PDF (Free Download)
Chapter List
Chapter 1: Introduction to Databases
Covers data, information, metadata, file processing systems, database approach, types of users, and history of database systems. Includes short questions, MCQs, and true/false exercises.
Chapter 2: Database Environment
Explains three-level architecture, mapping, data independence, database models, functions of DBMS, database design process, DBA and DA roles, logical and physical database design.
Chapter 3: Entity Relationship Model
Covers ER model, elements of E-R model, ER diagrams, degree of relationships, subtype and supertype entities. Includes 10 E-R practice projects.
Chapter 4: Semantic Object Model
Explains semantic object model, semantic objects, attribute domains, semantic object views, and types of objects with short questions and MCQs.
Chapter 5: Relational Model & Normalization
Covers relational model, relational keys, Codd’s Rules, relational algebra, joins, relational calculus, normalization from 1NF to 5NF, functional dependency, and includes 2 normalization projects.
Chapter 6: Database Design using E-R Model
Focuses on practical database design using the E-R model with design exercises and short questions.
Chapter 7: Database Design with Semantic Object Model
Covers mapping simple, composite, compound, hybrid, and association objects, plus converting 1:1, 1:N, and M:N compound objects to relational tables.
Chapter 8: Structured Query Language (SQL)
Complete SQL coverage including basic statements, operators, functions, joins, subqueries, correlated subqueries, data definition, constraints, DML, and views.
Chapter 9: Concurrency & Security
Explains transactions, concurrency, resource locking, serializable schedules, deadlock, database failure, recovery, types of backups, and database security.
Chapter 10: Client-Server Databases & ODBC
Covers client-server architecture, reliability and security in client-server systems, ODBC, and conformance levels.
Chapter 11: Distributed & Object Oriented Databases
Explains centralized, distributed and decentralized database systems, distributed DBMS, object oriented databases, object oriented data model, and future developments.
Chapter 12: Introduction to MS Access
Covers Microsoft Access basics, starting MS Access, application window, creating tables, data types, table views, modifying tables, sorting, finding and replacing data, and filters.
Chapter 13: Relationships in MS Access
Explains relationships, queries, simple query wizard, design view queries, multi-table queries, wildcards, calculated fields, expression builder, parameter queries, summarize queries, and action queries.
Chapter 14: Forms & Reports
Covers creating forms, subforms, reports, and label reports in MS Access with step-by-step practical guidance.
Chapter 15: Data Access Pages
Explains data access pages, connecting to data sources, and MS Access exercises for practical practice.
Chapter 16: MS Access Projects
Includes 5 complete MS Access projects: Library Management System, Sales Management System, Student Management System, Magazine Database, and Construction Company Database.
Download Database Management Systems PDF
Your free PDF is ready. Click the button below to download the complete IT Series DBMS textbook.
⬇ Download PDFWho Should Read This
This book is specifically written for BSCS students studying Database Management Systems at Pakistani universities. BIT, BSIT, and MCS students with DBMS in their curriculum will also find it very useful. With 275+ short questions, 300+ MCQs, complete SQL and MS Access coverage, and 5 real-world projects, it is ideal for both theory and practical exam preparation.
Applicable Universities
This IT Series textbook is widely used at Pakistani universities offering BSCS, BIT, BSIT, and MCS programs including Punjab University, Virtual University, COMSATS, FAST, UET, and other HEC-recognized institutions.
FAQs
Is this the IT Series DBMS book used in Pakistani universities?
Yes, this is the IT Series “A Fundamental Study of Database Management Systems” 3rd edition by Imran Saeed and co-authors, widely used in BSCS programs across Pakistan.
Does this book cover SQL and MS Access?
Yes, Chapter 8 covers complete SQL and Chapters 12 to 16 are fully dedicated to MS Access including tables, queries, forms, reports, and 5 complete projects.
How many questions does this book include?
More than 275 short questions, 300+ MCQs, and 275+ true/false questions are included to help students prepare for exams from every angle.
Does it cover normalization in detail?
Yes, Chapter 5 covers all normal forms from 1NF to 5NF, Codd’s Rules, functional dependency, relational algebra, and includes 2 normalization practice projects.
Can BIT or BSIT students also use this book?
Yes, BIT, BSIT, and MCS students with DBMS in their syllabus will find this book very useful for both theory and practical exam preparation.
Is this the latest edition?
This is the 3rd edition of the IT Series DBMS book — the most updated version available for Pakistani university students.