[1] DBMS:
What is a DBMS. Need for using DBMS. Concepts of tables, records, attributes, keys, integrity constraints,
3-schema architecture, data independence.
Data models – Hierarchical, Network, Relational
[2] The Relational Model, Language & Systems :
The Relational Data Model & Relational Algebra.
SQL: DDL , DML, & DCL concepts, SQL commands (ANSI standard).
Oracle 8 or above/ MS SQL Server / MS Access
[3] Integrity and Security:
[a] Integrity constraints, concept of triggers, stored procedures (theoretical concepts only)
[b] Database Security & Authorization (concept of GRANT / REVOKE).
[4] Database Design :
ER modeling [Entity-Relationship Diagrams (ERD), construction of tables], Functional Dependencies & Normalization
(upto 3NF; concept of BCNF), Denormalization.
Case Study on Normalization.
[5] System Implementation Techniques :
[a] Query Processing & Optimization (concept only).
[b] Transaction Processing Concepts, Concurrency Control and Recovery Techniques (concept only).
[6] Indexing concepts:
Ordered indices (primary , secondary, dense, sparse, multilevel), concepts of hashing (static, dynamic)
[7] Advanced Data Models & Emerging Trends :
Advanced Data Modeling Concepts, Object–Oriented Databases, Distributed Databases & Client Server Architecture, XML