DBMS – Syllabus / Books / Question Papers

File Organization
STORAGE DEVICES CHARACTERISTIC
FILE ORGANIZATION

Introduction to database system
COMPONENTS OF DBMS
TYPES OF DBMS
WHY RDBMS?
FEATURES OF RDBMS
ATTRIBUTES, TUPLES & TABLES, CODD’S RULES

Entity relationship model
ENTITY-RELATIONSHIP MODEL
STRONG AND WEAK ENTITIES
KEYS IN DBMS
CONVENTIONS FOR DRAWING ERD
ABSTRACTION
GENERALIZATION

DBMS concepts
ACID PROPERTIES:-TRANSACTION PROPERTIE
CONCURRENCY CONTROL
RECOVERY MECHANISMS
VIEWS AND SECURITY
INTEGRITY CONSTRAINTS
DATA SECURITY

Relational database design
NEED FOR PROPER DATABASE
UNDESIRABLE PROPERTIES OF BAD DATABASE DESIGN
FUNCTIONAL DEPENDENCIES
NORMALIZATION USING FDS
PROPERTIES OF DECOMPOSITION

SQL Relational database language
DDL- DATA DEFINITION LANGUAGE
DML- DATA MANIPULATION LANGUAGE
DCL- DATA CONTROL LANGUAGE
SIMPLE QUERIES

Security
GRANTING ACCESS TO USERS
EXTENDING AND RESTRICTING PRIVILEGES
USING VIEWS OF SECURITY

Transaction processing
TRANSACTION PROCESSING
PROPERTIES OF TRANSACTION
SCHEDULES
SERIALIZING AND ITS NEED

Backup and recovery
TYPES OF FAILURE AND STORAGE SYSTEMS
NEED FOR BACKUP AND RECOVERY

Concurrency Control and Recovery Techniques
CONCURRENCY PROBLEMS
CONCURRENCY CONRTOL MECHANISMS
DEADLOCKS
DEADLOCKS HANDLING DETECTION AND PREVENTION

Introduction to Data warehousing and data mining
DATA WAREHOUSING
DATA MINING

For TMV, Click here

To study more about DBMS, Click here

Previous Years Question Papers, Click Here

Special Thanks to Atif Usmani for his contributions.

Advertisements