Database Management Systems DBMS MNCST409 BTech CS Minor 2024

About Me

Scheme and Syllabus DBMS MNCST409 BTech  CS Minor 2024

Model Question Paper DBMS MNCST409 BTech  CS Minor 2024

Module-I

Introduction to DBMS

Introduction to DBMS

Example  Database

Database System Vs Traditional File Processing

Database System Concepts and Architecture

Data Models, Schemas and Instances 

Three schema architecture and Data Independence

Database Languages and Interfaces

Centralized and Client Server Architectures in DBMS

Classification of Database Management Systems

Conceptual Data Modeling and Database Design

Conceptual Modeling and the Role of the ER Model in Database Design

Entities and Attributes 

Company Database Application - Example

Entity Types, Entity Sets, Keys, and Value Sets in the ER Model

Initial Conceptual Design of the COMPANY Database

Relationship Types in the ER Model

Relationship Degree, Role Names, and Recursive Relationships

Constraints on Binary Relationship Types

Attributes of Relationship Types

Weak Entity Types

Summary of the Notations Used in ER Diagram , Naming Conventions and Design Issues

Alternative (min, max) Notation for ER Diagrams

Module-II 

Relational Database Constraints

Relational Model Concepts

Relational Database Constraints

Update Operations, Transactions, and Dealing with Constraint Violations

Relational Algebra and Relational Calculus

Introduction to Relational Algebra and Relational Calculus

Unary Relational Operations

Relational Algebra Operations from Set Theory

Cartesian Product Operation

Binary Relational Operations - Join

Binary Relational Operation- Division

Relational Algebra Operations- Summary

Inner Join Vs Outer Join

Tuple Relational Calculus

Domain Relational Calculus- Comparison with TRC

Structured Query Language ( SQL)

Introduction to basic SQL

Data Definition Language and Data Manipulation Language 

Specifying constrains in SQL

Basic retrieval Queries in SQL

Insert, delete and update statements in SQL

NULL Values and Three-Valued Logic in SQL

Nested Queries in SQL

EXISTS and UNIQUE Functions in SQL

Explicit Sets and Renaming in SQL

Joined Tables in SQL and Outer Joins

Aggregate Functions, GROUP BY and HAVING in SQL

Assertion and Triggers

Views ( virtual tables) in SQL

Schema change statements in SQL

Learn and practice SQL

Relational Database Design

ER to Relational Mapping

Comparison between ER Model and Relational Model

Module-III

Normalization

Informal Design Guidelines for Relational Schema

Functional Dependencies ( FD's)

Inference Rules for Functional Dependencies

Armstrong's Axioms ( Inference  Rules)

Attribute Closure (X⁺)

Identifying Candidate Keys

Solved Problems

Introduction to Normal Forms

First Normal Form(1NF) Explanations with Examples

Second Normal Form(2NF) Explanation with Examples

Third Normal Form (3NF) - Detailed Explanation

Summary of Normal Forms

More General Definitions of 2NF and 3NF

Boyce-Codd Normal Form ( BCNF)

Solved Problems - Normalization

 Transactions and Concurrency Control

Introduction to Transaction Concepts and Concurrency Control

Transactions, Database Items, Read/Write Operations, and DBMS Buffers

Why Concurrency is Required - Major Issues

Why Recovery is Required - Types of Failures

Transaction and System Concepts

Desirable Properties of Transactions (ACID Properties)

Schedules (Histories) of Transactions

Characterizing Schedules Based on Recoverability

Characterizing Schedules Based on Serializability

Testing serializability of a schedule

Why serializability is important

Introduction to Concurrency Control in DBMS

Concept of Locking - Binary and Read/Write Locks

Two-Phase Locking (2PL) Protocol in Concurrency Control

Database Recovery Concepts

Database Recovery  Based on Deferred Update

Recovery Techniques Based on Immediate Update

Shadow Paging Recovery Technique

Module-IV 

NoSQL

Introduction To NoSQL

Categories of NoSQL systems

RDBMS Vs NoSQL

ACID(RDBMS) Vs BASE( NoSQL)

CAP Theorem in Distributed System ( NoSQL)

NoSQL Architectural Patterns

    Key-value stores 

    Graph stores 

    Column family(Bigtable) stores 

    Document stores 

    Variations of NoSQL architecture patterns