Section–A
Review of DBMS:
Basic DBMS terminology; Architecture of a DBMS: Data IndependencePhysical
and Logical
Independence, Degree of Data Abstraction, Initial Study of the Database,
Database Design,
Implementation and Loading, Testing and Evaluation, Operation, Maintenance
and Evaluation.
Conceptual Model:
Entity Relationship Model, Importance of ERD, Symbols (Entity:Types of
Entities, week Entity, Composite Entity, Strong Entity, Attribute: Types of
Attribute, Relationship: Type of relationship, Connectivity, Cardinality).
Section–B
Database Models and Normalization:
Comparison of Network, Hierarchical and Relational Models, Object Oriented
Database, Object
Relational Database, Comparison of OOD & ORD; Normalization and its
various forms, De-Normalization, Functional Dependencies, Multi-valued
Dependencies, Database Integrity:
Domain, Entity, Referential Integrity Constraints.
Transaction Management and Concurrency Control:
Client/ Server Architecture and implementation issues, Transaction:
Properties, Transaction Management with SQL, Concurrency; Concurrency
Control: Locking Methods: (Lock Granularity, Lock Types, Two Phase Locking,
Deadlocks), Time Stamping Method, Optimistic Method, Database Recovery
Management.
Section–C
Distributed Databases:
Centralized Verses Decentralized Design; Distributed Database Management
Systems (DDBMS): Advantage and Disadvantages; Characteristics, Distributed
Database Structure, Components, Distributed Database Design, Homogeneous
and Heterogeneous DBMS.
Levels of Data and Process Distribution:
SPSD (Single–Site Processing, Single- Site Data), MPSD (Multiple-Site
Processing, Single Site
Data), MPMD (Multiple–Site Processing, Multiple-Site Data), Distributed
Database Transaction
Features, Transaction Transparency, Client/Server Vs DDBMS.
Section–D
Business Intelligence and Decision Support System: The need for Data
Analysis, Business Intelligence, Operational Data vs. Decision Support Data,
DSS Database properties and importance, DSS Database Requirements.
OLAP and Database Administration:
Introduction to Online Analytical Processing (OLAP), OLAP Architecture
Relational, Star Schemas, Database Security, Database administration tools,
Developing a Data Administration Strategy.