Course Content

Other Courses

Tribhuvan university CSIT 2065 Syllabus Database Management System

Database Management System - Syllabus

Course Overview and Structure
Syllabus Notes Old Questions Unit Wise Questions Question Bank

Embark on a profound academic exploration as you delve into the Database Management System course () within the distinguished Tribhuvan university's CSIT department. Aligned with the 2065 Syllabus, this course (CSC-253) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 60+20+20 marks system, coupled with a challenging passing threshold of , propels students to strive for excellence, fostering a deeper grasp of the course content.

This 3 credit-hour journey unfolds as a holistic learning experience, bridging theory and application. Beyond theoretical comprehension, students actively engage in practical sessions, acquiring valuable skills for real-world scenarios. Immerse yourself in this well-structured course, where each element, from the course description to interactive sessions, is meticulously crafted to shape a well-rounded and insightful academic experience.


Course Synopsis: This is a first database course for B.Sc. Computer Science and Information Technology students. It introduces the fundamentals of database technology. Topics covered include: database concepts, Database System Architecture, E-R model, relational model, database design theory, database languages, transaction management, concurrency control and database recovery.

Goal:   There are two principle objectives for this course.
  • To introduce the fundamental concepts and methods necessary for the design and use of a database systems. 
  • To provide practical experience in applying these concepts and methods using commercial database management systems.

Units

Key Topics

  • Compiler Structure
    UN-1.1

    Analysis and Synthesis Model of Compilation, including different sub-phases within analysis and synthesis phases.

  • Compiler Concepts
    UN-1.2

    Basic concepts related to Compiler, including interpreter, simple One-Pass Compiler, preprocessor, macros, symbol table, and error handler.

  • Institutional Infrastructural Preparedness
    UN-1.3

    Institutional infrastructural preparedness refers to the readiness of government agencies and institutions to adopt and implement e-governance systems.

  • Human Infrastructural Preparedness
    UN-1.4

    Human infrastructural preparedness involves the development of skills and capacities of public officials and citizens to effectively use e-governance systems.

  • Technological Infrastructural Preparedness
    UN-1.5

    Technological infrastructural preparedness refers to the availability and quality of technology infrastructure, including computers, internet connectivity, and other digital tools.

  • Present Global Trends in E-Governance
    UN-1.6

    This topic analyzes the current state of E-Governance globally, including its growth, adoption, and impact on governments and societies.

  • Other Issues in E-Governance
    UN-1.7

    This topic covers additional topics and concerns related to E-Governance, including security, privacy, and ethics.

  • TTL and CMOS Integrated Circuit Logic Devices
    UN-1.8

    This topic focuses on the characteristics and applications of TTL and CMOS integrated circuit logic devices.

  • Relational Commercial Languages
    UN-1.9

    Introduction to SQL and Query By Example (QBE).

Key Topics

  • Integrity and Security
    UN-201

    This topic covers the concepts of domain constraints, referential integrity, assertions, triggers, authorization, authentication, and data encryption to ensure the reliability and security of a database.

  • Theory of Database Design
    UN-202

    This topic explores the fundamental concepts of functional dependencies, including trivial and non-trivial dependencies, closure of a set of functional dependencies, and irreducible sets of dependencies.

  • Normalization
    UN-203

    This topic discusses the process of normalization, including non-loss decomposition, functional dependencies, first, second, and third normal forms, dependency preservation, and Boyce-Codd normal form.

Key Topics

  • Symbol Table Design
    UN-3.1

    Function of Symbol Table, Information provided by Symbol Table, Attributes and Data Structures for symbol table

  • Run-time Storage Management
    UN-3.2

    Managing storage during runtime

  • Database Recovery
    UN-3.3

    Failure Classification, The Storage Hierarchy, Transaction Model, Log-Based recovery, Buffer Management, Checkpoints, Shadow Paging, Failure with Loss of Non-volatile Storage.