Syllabus For The Subject RELATIONAL DATA BASE MANAGEMENT SYSTEM

UNIT - 01

INTRODUCTION TO DATABASE SYSTEM - RELATIONS - INTEGRITY CONSTRAINS -

ENFORCING INTEGRITY CONSTRAINS - QUERY LANGUAGES - FILE ORGANIZATIONS AND

INDEXES.

UNIT - 02

TREE STRUCTURED INDEXING : ISAM - B+ TREES - FORMAT OF A NODE : SEARCH,

INSERT, DELETE, DUPLICATES, B+ TREES IN PRACTICE MULTIDIMENSIONAL INDEXES -

HASH BASED INDEXING.

UNIT - 03

RELATIONAL ALGEBRA AND CALCULUS - SQL : THE QUERY LANGUAGE - SECURITY,

VIEWS AND SQL.

UNIT - 04

CONCEPTUAL DESIGN AND THE ER MODEL - SCHEMA REFINEMENT AND NORMAL

FORMS.

UNIT - 05

PARALLEL AND DISTRIBUTED DATABASES - OBJECT DATABASE SYSTEMS - BASIC

CONCEPTS OF NETWORK MODEL AND HIERARCHY MODEL.