DATABASE MANAGEMENT SYSTEMS
EX 765 06
Course Objectives:
The course objective is to provide fundamental concept, theory and practices in design and implementation of Database Management System.
- Introduction[3 hours]
- Concepts and Applications
- Objective and Evolution
- Data Abstraction and Data Independence
- Schema and Instances
- Concepts of DDL, DML and DCL
- Data Models[7 hours]
- Logical, Physical and Conceptual
- E-R Model
- Entities and Entities sets
- Relationship and Relationship sets
- b and Weak Entity Sets
- Attributes and Keys
- E-R Diagram
- Alternate Data Model (hierarchical, network, graph)
- Relational Languages and Relational Model [7 hours]
- Introduction to SQL
- Features of SQL
- Queries and Sub-Queries
- Set Operations
- Relations (Joined, Derived)
- Queries under DDL and DML Commands
- Embedded SQL
- Views
- Relational Algebra
- Database Modification
- QBE and domain relational calculus
- Database Constraints and Normalization[6 hours]
- Integrity Constraints and Domain Constraints
- Assertions and Triggering
- Functional Dependencies
- Multi-valued and Joined Dependencies
- Different Normal Forms (1st, 2nd, 3rd, BCNF, DKNF)
- Query Processing and Optimization[4 hours]
- Query Cost Estimation
- Query Operations
- Evaluation of Expressions
- Query Optimization
- Query Decomposition
- Performance Tuning
- File Structure and Hashing[4 hours]
- Records Organizations
- Disks and Storage
- Remote Backup System
- Hashing Concepts, Static and Dynamic Hashing
- Order Indices
- B+ tree index
- Transactions processing and Concurrency Control [6 hours]
- ACID properties
- Concurrent Executions
- Serializability Concept
- Lock based Protocols
- Deadlock handling and Prevention
- Crash Recovery [4 hours]
- Failure Classification
- Recovery and Atomicity
- Log-based Recovery
- Shadow paging
- Advanced Recovery Techniques
- Advanced database Concepts[4 hours]
- Concept of Objet-Oriented and Distributed Database Model
- Properties of Parallel and Distributed Databases
- Concept of Data warehouse Database
- Concept of Spatial Database
Practical: - Introduction and operations of MS-Access or MySQL or any suitable DBMS
- Database Server Installation and Configuration (MS-SQLServer, Oracle)
- DB Client Installation and Connection to DB Server. Introduction and practice with SELECT Command with the existing DB.
- Further Practice with DML Commands
- Practice with DDL Commands. (Create Database and Tables).
- Practice of Procedure/Trigger and DB Administration & other DBs (MySQL, PG-SQL, DB2.)
- Group Project Development.
- Project Presentation and Viva
References
- H. F. Korth and A. Silberschatz, " Database system concepts", McGraw Hill, 2010.
- A. K. Majumdar and P. Bhattacharaya, "Database Management Systems", Tata McGraw Hill, India, 2004.
Evaluation Scheme:
The question will cover all the chapters of the syllabus. The evaluation scheme will be as indicated in the table below:
Chapters |
Hour |
Marks Distribution* |
1 |
3 |
4 |
2 |
7 |
12 |
3 |
7 |
12 |
4 |
6 |
12 |
5 |
4 |
8 |
6 |
4 |
8 |
7 |
6 |
12 |
8 |
4 |
6 |
9 |
4 |
6 |
Total |
45 |
80 |
*There can be minor deviations in the numbers
|