Loading

Programmes Handwritten Notes Courses About Contact Login Enrol Now

Handwritten NotesDatabase Management Systems

Database Management Systems

DBMS theory, SQL, and normalization.

Database management system

Characteristics of dbms

Advantages of dbms

Disadvantages of dbms

Applications of dbms

Relational Database Management System

Database architecture

Data abstraction

Instances and schemas

Data independence

Schema architecture

Database language

Database manager

Database administrator

Database models

Relational model

Strong and weak entity types

Structural constraints

Integrity constraints

Relational algebra operations

Introduction on views

Database design process

Relational database design

Anomalies in a database

Normalization rule

Functional dependency

Reduction of ER diagram to table

Introduction to SQL

Overview of file organization techniques

Secondary storage devices

File operations

Desirable property of transactions

Testing of serializability

Recoverability of schedule

Concurrency control

Deadlock handling