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-1

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