ADBMS

ADBMS Syllabus ( Theory )

Detailed Contents	Contact Hours
Part A Need of DBMS over traditional Data storage mechanisms, Basic DBMS terminologies; Architecture of a DBMS: Data Independence, DBMS Component Structure, DBMS USERS, various DBMS Data Models, 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). Normalization and its various forms, Functional Dependencies, Multivalued Dependencies, Join Dependencies Database Integrity: Domain, Entity, Referential Integrity Constraints Relational Languages: Relational Algebra, Relational Calculus, Query Execution, optimization and evaluation Plans. Transaction Management and Concurrency Control techniques, Database Recovery Management Concepts and methods. Introduction and Need of Database Administration and activities of Database administration	7
	7
Part B Parallel Databases : Database System Architectures: Centralized and Client-Server Architectures – Server System Architectures – Parallel Systems-Parallel Databases: I/O Parallelism – Inter and Intra Query Parallelism – Inter and Intra operation Parallelism Distributed Database Concepts : Distributed Data Storage – Distributed Transactions – Commit Protocols – Concurrency Control – Distributed Query Processing Multidimensional Databases and their uses in data analytics. Temporal Databases : Introduction to Temporality, Temporal relationships, temporal hierarchies. Spatial Databases: Spatial data types, spatial relationships, Topological Relationships, Spatial Data Structures and methods of storage. Big Data : introduction: introduction to NOSQL Databases (Open Source only). Need and usage of XML Databases: XML Data Model – DTD – XML Schema	8

Programming in ADBMS Laboratory

1	Implementation of DDL Commands to perform a) Creation of table b) Alter c) Modify d) Drop column operations.
2	Implementation of Constraint a) Check Constraint b) Entity Integrity Constraint c) Referential Integrity Constraint d) Unique Constraint e) Null Value Constraint
3	Implementation of :- a) DML Commands b) DCL Commands
4	Implementation of Data and Built in Functions in SQL
5	Implementation of :- a) Nested Queries b) Join Queries
6	Implementation of Cursors.
7	Implementation of Procedures and Functions
8	Implementation of Triggers.
9	Implementation of Embedded SQL.
10	Consider a Database applications, Design and Develop Conceptual Data Model (ER Diagram) with all the necessary entities, attributes, constraints and relationships. Design and build Relational Data Model for application specifying all possible constraints.
11	Implementation of various DBA roles/techniques a) Creation of user b) Granting of privileges to the users c) Creation of roles d) Loading of privileges into user defined roles. e) Import/Export data between various databases and flat files

Question Bank