Find papers

IT 232

Database Management System

TU BBM · Semester 6 · BBM curriculum effective from 2021

Requirement
required
Credits
3
Syllabus
4 sections

Syllabus

What this course covers and how the teaching time is divided.

course syllabus loaded.

Database Management System Syllabus

Official TU PDF

Tribhuvan University

Faculty of Management

Office of the Dean

Bachelor of Business Management (BBM)

Course Title: Database Management System

Course Code: IT 232

Semester: Semester 6

Nature of Course: required

Full Marks: 100

Pass Marks: 50

Credit Hours: 3 Cr.

Curriculum: BBM curriculum effective from 2021

Course Description

:

The course covers different concepts of database management systems including database system concepts and architecture, ER diagram, relational model, SQL, normalization, transacti on processing, concurrency control, and database recovery.

Course Objective

:

The main objective of this course is to introduce different concepts of database, data modeling with ER diagram, features SQL, normalization, transaction processing, concurrency control, and database recovery

Course Contents:

Lecture hours show the approximate classroom time allocated to each unit.

Unit 1.Database Concepts and Architecture

5 hours
  • Database, Database Management System, Database Users, and Benefits of Databases
  • Data Models, Schemas, and Instances
  • Three -Schema Architecture and Data Independence
  • Database Languages and Interfaces
  • the Database System Environment
  • Centralized and Client/Server Architectures for DBMSs
  • Classification of Database Management Systems.

Unit 2.Data Modeling Using Entity-Relational Model and Relational Model

10 hours
  • Using High -Level Conceptual Data Models for Database Design
  • Entity Types, Entity Sets, Attributes, and Keys
  • Relationship Types, Relationship Sets, Roles, and Structural Constraints
  • Weak Entity Types
  • ER Diagrams, Naming Conventions, and Design Issues
  • Relationship Types of Degree Higher Than Two
  • Concepts of Specialization and Generalization
  • Constraints and Characteristics of Specialization and Generalization
  • Converting ER Schema to Relational Schema
  • Structure of the Relational Database.

Unit 4.SQL

12 hours
  • Data Definition and Data Types
  • Specifying Constraints
  • Basic Retrieval Queries
  • Complex Retrieval Queries
  • INSERT, DELETE, and UPDATE Statements
  • Views.

Unit 5.Relational Database Design

10 hours
  • Informal Design Guidelines for Relational Schemas
  • Functional Dependencies
  • Normal Forms Based on Primary Keys
  • General Definitions of Second and Third Normal Forms
  • Boyce-Codd Normal Form
  • Properties of Relational Decomposition.

Unit 6.Transaction Processing and Concurrency Control, and Recovery

7 hours
  • Introduction to Transaction Processing
  • Transaction and System Concepts
  • Desirable Properties of Transactions
  • Serializable Schedule
  • Two -Phase Locking and Timestamp Ordering Concurrency Control Techniques.

Unit 7.Database Recovery Techniques

4 hours
  • Recovery Concepts
  • NO -UNDO/REDO Recovery Based on Deferred Update
  • Recovery Technique Based on Immediate Update
  • Shadow Paging
  • Database Backup and Recovery from Catastrophic Failures. Laboratory Works: The laboratory work includes writing SQL statements to create databases and tables, inserting and deleting data, updating data, and writing select queries.

References:

Fundamentals of Database Systems; Seventh Edition; RamezElmasri, Shamkant B. Navathe; Pearson Education Database System Concepts; Sixth Edition; AviSilberschatz, Henry F Korth, S Sudarshan; McGraw-Hill NoSQL for Dummies; Adam Fowler; John Wiley & Sons, Inc. Principles of Distributed Database Systems; M. Tamer Ozsu and Patrick Valduriez; Fourth Edition; Springer 2020 Database Management Systems; Third Edition; Raghu Ramakrishnan, Johannes Gehrke; McGraw-Hill A First Course in Database Systems; Jaffrey D. Ullman, Jennifer Widom; Third Edition; Pearson Education Limited