Database Management System

This course introduces the fundamental concepts, architectures, and techniques of database management systems. It covers data modeling using ER/EER models, relational data model, SQL, normalization, transaction processing, and modern database applications including distributed systems and big data technologies.

Term: Summer, Spring, Fall

Location: IUBAT Campus (Rooms vary by section)

Time: Multiple sections

Course Overview

This course provides a comprehensive understanding of database systems, including their design, implementation, and management. Students will explore conceptual, logical, and physical database design, relational data models, SQL, normalization, and transaction processing. Advanced topics such as distributed databases, query optimization, and big data technologies are also introduced.

By the end of the course, students will be able to:

  • Understand fundamental DBMS concepts and architecture
  • Design databases using ER and relational models
  • Write and optimize SQL queries
  • Apply normalization techniques
  • Understand transaction management and concurrency control

Prerequisites

  • CSC 103: Fundamentals of Computers and Applications

Textbooks

  • Primary: Fundamentals of Database Systems by Ramez Elmasri (7th Edition, 2017)
  • Reference:
    • Database System Concepts by Silberschatz, Korth, Sudarshan (6th Edition)
    • Database Management Systems by Ramakrishnan and Gehrke (3rd Edition)

Teaching-Learning & Assessment Strategy

  • Lectures and multimedia presentations
  • Class discussions and problem-solving sessions
  • Assignments and project work
  • Class tests and quizzes
  • Written examinations

Course Outcomes

At the end of the course, students will be able to:

  • CO1: Describe the fundamental concepts of relational database management systems
  • CO2: Identify entities, relationships, and system modules for database design
  • CO3: Analyze systems and apply normalization and SQL for implementation

Grading Policy

Component Weight
Mid-Term Exam 25%
Class Test 10%
Final Exam 50%
Assignment/Project/Presentation 10%
Participation/Attendance 5%
Total 100%

Grade Distribution

Grade Marks Grade Marks
A+ 80–100 C+ 50–54
A 75–79 C 45–49
A- 70–74 D 40–44
B+ 65–69 F <40
B 60–64 W Withdraw
B- 55–59 I Incomplete

Assessment Breakdown

Continuous Internal Evaluation (50%)

  • Midterm Exam: 25
  • Class Test: 10
  • Assignments/Projects: 10
  • Participation: 5

Semester End Examination (50%)

  • Focus on understanding, application, and analysis of DBMS concepts

Additional Notes

  • Students will engage in hands-on activities such as ER diagram design, SQL query implementation, normalization, and indexing.
  • Real-world systems (e.g., CRM, appointment systems) will be used for assignments and projects.

Schedule

Week Date Topic Materials
1 Introduction to DBMS

Course overview, database concepts, DBMS characteristics, users, and advantages.
2 Database Architecture & ER Modeling

DBMS architecture, schemas, three-schema architecture, introduction to ER model.
3 ER Modeling & Relational Model

ER diagrams, constraints, relational model concepts and schema design.
4 Relational Model & SQL Basics

Relational constraints, transactions, SQL basics and data definition.
5 Midterm & SQL Operations

Midterm exam and introduction to SQL queries (CRUD operations).
6 Advanced SQL & Relational Algebra

SQL joins, conditions, relational algebra operations.
7 SQL Programming Techniques

Embedded SQL, JDBC, stored procedures, and database programming.
8 Normalization

Functional dependencies, normalization (1NF, 2NF, 3NF).
9 Storage & Indexing

File structures, hashing, indexing techniques.
10 Indexing & Transactions

B-trees, B+ trees, transaction processing basics.
11 Concurrency Control

Transactions, locking, recoverability, concurrency control methods.
12 Advanced Topics

Distributed databases, query optimization, big data (Hadoop, MapReduce).
13 Data Mining & Review

Introduction to data mining and course review.