Advanced DBMS Concepts

Advanced Concepts in Database Management System

• Database Management Systems - An Introduction

• Entity-Relationship model (ER model) 

• Relational Algebra 

• Deadlock

• Deadlock Handling Techniques

• Normalization

• How an SQL Query is executed by a DBMS?

• Database Query Processing

• Transactions Management in DBMS

• Simple Hash Join in DBMS

• Database Triggers - Overview

• Keywords and Definitions in DBMS

• Optimization of disk-block access - Techniques

• What are the performance measures of a hard disk drive?

• Database performance and selection of storage devices (Harddisk vs RAM)  

• Limits on database tables

  • Maximum number of indexes that can be created per table in different RDBMSs   

  • Maximum number of columns per table, index, primary key and foreign key

Questions and Answers

• Anna University DBMS subject Question and Answers - Two Marks
• Multiple Choice Questions - With answers explained 
• Solved Exercises in DBMS