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