Course Content

Other Courses

Tribhuvan university CSIT 2065 Syllabus Advanced Database Management System

Advanced 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 Advanced Database Management System course () within the distinguished Tribhuvan university's CSIT department. Aligned with the 2065 Syllabus, this course (CSC-401) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 60 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: To study the concept of advanced database techniques.

Goal: To study the further advanced database techniques beyond the fundamental database techniques which were covered in the sophomore year (fourth semester) BSc. CSIT course, and thus to acquaint the students with some relatively advanced issues. At the end of the course students should be able to: critically assess new developments in database technology, interpret and explain the impact of emerging database standards. Evaluate the contribution of database theory to practical implementation of database management systems.

Units

Key Topics

  • Relational Model Concepts
    TH-1

    This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

  • Relational Model Constraints
    TH-2

    This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

  • Relational Database Schemas
    TH-3

    This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

  • Update Operations and Transactions
    TH-4

    This topic covers update operations, transactions, and how to deal with constraint violations, including insert, delete, and update operations, as well as restrict, cascade, set null, and set default.

  • Basic Relational Algebra Operations
    TH-5

    This topic introduces basic relational algebra operations, including unary operations (select, project, rename) and binary operations (set theory, Cartesian product, join, and outer join).

  • XML Schema
    TH-6

    Defining the structure and constraints of XML documents using XML Schema.

  • Simple and Complex Types
    TH-7

    Understanding simple and complex data types in XML Schema.

  • XSD Attributes
    TH-8

    Using attributes in XML Schema to provide additional information.

Key Topics

  • Relational Model Concepts
    TH-1

    This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

  • Relational Model Constraints
    TH-2

    This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

  • Relational Database Schemas
    TH-3

    This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

  • Update Operations and Transactions
    TH-4

    This topic covers update operations, transactions, and how to deal with constraint violations, including insert, delete, and update operations, as well as restrict, cascade, set null, and set default.

  • Basic Relational Algebra Operations
    TH-5

    This topic introduces basic relational algebra operations, including unary operations (select, project, rename) and binary operations (set theory, Cartesian product, join, and outer join).

  • XML Schema
    TH-6

    Defining the structure and constraints of XML documents using XML Schema.

  • Simple and Complex Types
    TH-7

    Understanding simple and complex data types in XML Schema.

  • XSD Attributes
    TH-8

    Using attributes in XML Schema to provide additional information.

  • Default and Fixed Values
    TH-9

    Specifying default and fixed values for elements and attributes in XML Schema.

  • Facets
    TH-10

    Restricting data types using facets in XML Schema.

Key Topics

  • Object Oriented Database Concepts
    EM-01

    This topic covers the fundamental concepts of object-oriented databases, including object identity, structure, and type constructors, encapsulation, type and class hierarchies, and inheritance.

  • Object Relational Database Concepts
    EM-02

    This topic explores the integration of object-oriented and relational database concepts, including the SQL standard, object-relational features, and extended type systems.

  • Active Database Concepts
    EM-03

    This topic introduces the concept of active databases, including the generalized model, design and implementation issues, and potential applications.

  • Temporal Database Concepts
    EM-04

    This topic covers the representation and management of time in databases, including time dimensions, tuple versioning, and attribute versioning.

  • Multimedia Databases
    EM-05

    This topic explores the nature of multimedia data and applications, including spatial database concepts and architecture.

  • Deductive Databases and Query Processing
    EM-06

    This topic introduces deductive databases, including Prolog/Datalog notations, clausal form, and horn clauses, as well as query processing techniques.

  • Mobile Databases
    EM-07

    This topic covers the characteristics of mobile environments, data management issues, and mobile computing architecture.

  • Geographic Information Systems (GIS)
    EM-08

    This topic explores the data management requirements of GIS, including specific data operations and applications.

Key Topics

  • Neurally Inspired Models of Information Processing
    NE-1

    This topic explores models of information processing inspired by the structure and function of the brain. It introduces the concept of neural networks and their application to information processing.

  • Single-Layer Networks and Boolean Functions
    NE-2

    This topic delves into the basics of single-layer neural networks and their relationship with Boolean functions. It covers the fundamentals of neural network architecture and its application to simple logical operations.

Key Topics

  • Introduction to Databases
    DA-1

    Introduction to databases, including examples and basic concepts.

  • Database Management System
    DA-2

    Introduction to Database Management Systems (DBMS), including advantages and examples.

  • Database Users
    DA-3

    Types of database users, including actors on the scene and workers behind the scene.

  • Benefits of Databases
    DA-4

    Advantages and benefits of using databases.

Lab works

The course involves a mini project using any one of the popular Commercial Object-Oriented DBMS software such as Oracle, MS SQL Server etc., along with any MVC software development framework.