DBMS (B-TECH Information Technology 5th)

Objective: The objective of the course is to offer good understanding of database

design, modeling and implementation of database management systems.

Introduction - Database Systems versus File Systems, View of Data, Data Models,

database languages, Database Users and Administrators. Transaction Management,

Decision Support Systems, Components of a Database management System.

Distributed Processing and Client- Server Architecture. Entity-Relationship Model –

Basic Concepts, Constraints, Keys, Design Issues, E-R Diagrams.

Relational Model - Structures of relational databases, Integrity Constraints, Logical

database Design, Tables, Views, Data Dictionary. Relational Algebra, Relational

Calculus. SQL – Basic Structures, Query Handling, Embedded SQL, Open Database

Connectivity (ODBC), Java Database Connectivity (JDBC), Triggers, Security and

Authorization. Query By Example (QBE), User Interfaces and Tools, Forms and

Graphical User Interfaces. Report Generators. Overview of Relational Query

Optimization.

Relational Database Design - Functional Dependencies, Multi-valued

Dependencies, Normal Forms, Decomposition into Normalized

Database Design – File Structures. Object-Relational Databases

Complex Data types, Object-Relational Features in SQL:1999.

Relations, Physical

– Nested Relations,

Internet Databases - World Wide Web, Client Side Scripting and Applets, Web

Servers and Sessions, Services, Server Side Scripting. XML – Structure of XML Data,

XML Document Schema, XQuery, Storage of XML Data, XML Applications.

Advanced Topics - Fundamental Concepts of Transaction Management, Concurrency

Control, Recovery Systems, Data Analysis and OLAP. Introduction to Data Mining,

Data Farming, Data Warehousing, Spatial and Geographic Databases, Temporal

databases and Multimedia Databases. NoSQL databases