MTech Database Management Systems syllabus for 1 Sem 2020 scheme 20BBI14

Module-1 Overview of Database Management System 0 hours

Overview of Database Management System:

Introduction, file-based system, Drawbacks of fileBased System , Data and information, Database, Database management System, Objectives of DBMS, Evaluation of Database management System, Classification of Database Management System, DBMS Approach, advantages of DBMS, Anis/spark Data Model, data models, Components and Interfaces of Database Management System. Database Architecture, Situations where DBMS is not Necessary, DBMS Vendors and Their Products.

Module-2 Entity-Relationship Model 0 hours

Entity-Relationship Model:

Introduction, the building blocks of an entity relationship diagram, classification of entity sets, attribute classification, relationship degree, relationship classification, reducing ER diagram to tables, enhanced entity-relationship model (EER model), generalization and specialization, IS A relationship and attribute inheritance, multiple inheritance, constraints on specialization and generalization, aggregation and composition, entity clusters, connection types, advantages of ER modelling.

A d v e r t i s e m e n t
Module-3 Relational Model 0 hours

Relational Model:

Introduction, CODD Rules, relational data model, concept of key, relational integrity, relational algebra, relational algebra operations, advantages of relational algebra, limitations of relational algebra, relational calculus, tuple relational calculus, domain relational Calculus (DRC). QBE

Module-4 Structured Query Language 0 hours

Structured Query Language:

Introduction, History of SQL Standard, Commands in SQL, Data Types in SQL, Data Definition Language, Selection Operation, Projection Operation, Aggregate functions, Data Manipulation Language, Table Modification Commands, Table Truncation, Imposition of Constraints, Join Operation, Set Operation, View, Sub Query, and Embedded SQL.

Module-5 PL/SQL 0 hours

PL/SQL:

Introduction, Shortcoming in SQL, Structure of PL/SQL, PL/SQL Language Elements, Data Types, Operators Precedence, Control Structure, Steps to Create a PL/SQL, Program, Iterative Control, Cursors, Steps to create a Cursors, Procedure, Function, Packages, Exceptions Handling, Database Triggers, Types of Triggers.

 

Course outcomes:

At the end of the course the student will be able to:

  • Understand the concepts of database structures , systems and formats
  • Understand the design and models of data in database.
  • Understand the concepts of SQL and PL/SQL.

 

Question paper pattern:

The SEE question paper will be set for 100 marks and the marks scored will be proportionately reduced to 60.

  • The question paper will have ten full questions carrying equal marks.
  • Each full question is for 20 marks.
  • There will be two full questions (with a maximum of four sub questions) from each module.
  • Each full question will have sub question covering all the topics under a module.
  • The students will have to answer five full questions, selecting one full question from each module.

 

Textbook/ Textbooks

1 Database System Concepts Abraham Silberschatz, Henry Korth, and S. Sudarshan, McGraw Hill, 2010

2 Fundamentals of Database Systems” R. Elmasri and S.B Navathe, Pearson 2017

 

Reference Books

1 An Introduction to Database Systems Bipin C Desai Galgotia publications 1981

2 Principles of Database Systems J. D. Ullman, F Galgotia publications 1982

3 Database Management Systems” Raghu Ramakrishnan McGraw-Hill 2002

Categories

VTU Updates