|Course Archives Statistical Quality Control & Operations Research Unit|
Course:Data Base Management
Time: Currently not offered
| Syllabus |
Syllabus: Basic concepts: Introductory database terminologies, data models, advantages of DBMS, data types in programming languages vs databases, identifying entities and relationships, hierarchical, network, relational and object oriented databases, hybrid models.
The relational model: Relational schema, tuples, domains, advantages of relational model, primary, composite and foreign keys, relational algebra, relational calculus, views, integrity constraints, key constraints, types and integrity maintenance, well-structured relations: insertion, deletion and modification anomalies, physical database design and performance.
The SQL language: SQL relational database language (DDL, DML, SELECT-FROM-WHERE, grouping, aggregation, subqueries), database definition: CREATE TABLE, ALTER TABLE, CREATE VIEW, database manipulation: SELECT, INSERT, UPDATE and DELETE statements, SQL expressions and functions, comparison and boolean operators, ORDER BY, GROUP BY and HAVING clauses, table joins, simple and complex joins, outer joins and NULL values, sub-queries, nested queries, SQL execution modes, recursion in SQL 3, embedded SQL, Query by Example, query optimisation, application development using JDBC, application development using PL/SQL, query optimisation, concurrency control, query execution plans, triggers and stored procedures.
Database design: ER modeling, database normalisation, first, second and third normal forms, Boys-Codd normal form, extension of normal forms, ER and EER mapping.
Transaction Management: Transaction processing,desirable properties of transactions, need for concurrency control, schedule and recoverability, serializability, types of locks, levels of locking (data and records), two phases locking, recovery techniques.
Database Indexing: B-trees, hashing-based indexing, creating indexes, index manipulations (create, update, drop), bitmap indexing.
Current trends: Object databases and XML,client-server architecture, distributed databases, parallel databases, temporal databases, object-relational databases, VLDB, replication and partitioning, Internet and Intranet databases, Datawarehouses, Database Languages, object oriented query languages.
1. Introduction to Databes Systems: By C. J. Date, Narosa Publishers.
2. Database System Concepts: By Henry F. Korth, Abraham Silberschatz, and S. Sudarshan, McGraw: By Hill (5th Edition).
3. Principles of Database Systems: By J. Ullman, Galgotia Publishers.
Software required: Oracle 10g, Microsoft SQL Software, and MS-Access.
Top of the page
Top of the page
[Indian Statistical Institute]