IOE Syllabus of Database Management Systems (DBMS)

Database Management Systems (DBMS) whose course objective is to provide fundamental concept, theory and practices in design and implementation of Database Management System is regular course for BE Computer III Year – II Part. The course code of DBMS is: CT652, Lecture : 3, Tutorial : 1, Practical : 3. The following syllabus of Database Management System is according to updated syllabus of IOE.

  1. Introduction [3 hours]
    1. Concepts and Applications
    2. Objective and Evolution
    3. Data Abstraction and Data Independence
    4. Schema and Instances
    5. Concepts of DDL, DML and DCL
  2. Data Models [7 hours]
    1. Logical, Physical and Conceptual
    2. E‐R Model
    3. Entities and Entities sets
    4. Relationship and Relationship sets
    5. Strong and Weak Entity Sets
    6. Attributes and Keys
    7. E‐R Diagram
    8. Alternate Data Model (hierarchical, network, graph)
  3. Relational Languages and Relational Model [7 hours]
    1. Introduction to SQL
    2. Features of SQL
    3. Queries and Sub‐Queries
    4. Set Operations
    5. Relations (Joined, Derived)
    6. Queries under DDL and DML Commands
    7. Embedded SQL
    8. Views
    9. Relational Algebra
    10. Database Modification
    11. QBE and domain relational calculus
  4. Database Constraints and Normalization [6 hours]
    1. Integrity Constraints and Domain Constraints
    2. Assertions and Triggering
    3. Functional Dependencies (Chase Algorithm)
    4. Multi‐valued and Joined Dependencies
    5. Different Normal Forms (1st, 2nd, 3rd, BCNF, DKNF)
  5. Query Processing and Optimization [4 hours]
    1. Query Cost Estimation
    2. Query Operations
    3. Evaluation of Expressions
    4. Query Optimization
    5. Query Decomposition
    6. Performance Tuning
  6. File Structure and Hashing [4 hours]
    1. Records Organizations
    2. Disks and Storage
    3. Remote Backup System
    4. Hashing Concepts, Static and Dynamic Hashing
    5. Order Indices
    6. B+ tree index
  7. Transactions processing and Concurrency Control [6 hours]
    1. ACID properties
    2. Concurrent Executions
    3. Serializability Concept
    4. Lock based Protocols
    5. Deadlock handling and Prevention
  8. Crash Recovery [4 hours]
    1. Failure Classification
    2. Recovery and Atomicity
    3. Log‐based Recovery
    4. Shadow ept of Spatial Database
    5. Advanced Recovery Techniques
  9. Advanced database Concepts [4 hours]
    1. Concept of Object‐Oriented and Distributed Database Model
    2. Properties of Parallel and Distributed Databases
    3. Concept of Data warehouse 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:

Unit

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

We're always listening.
Have something to say about this article? Find us on Facebook, Twitter or our LinkedIn.
Raju Dawadi
Raju Dawadi
Raju is currently actively involved in DevOps world and is focused on Container based architecture & CI/CD automation along with Linux administration. Want to discuss with him on any cool topics? Feel free to connect on twitter, linkedIn, facebook.

1 Comment

  1. saroj says:

    can you please provide notes for DBMS

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.