DATABASE MANAGEMENT SYSTEM: ROAD MAP TO PLACEMENT AND GATE PREPARATION

COURSE OBJECTIVES

This course helps GATE Exams aspirant students by delivering core concepts, principles and techniques of a database management system, thereby equipping them to design and implement a database application built over those concepts. It also focuses on advanced level areas like transaction processing, concurrency control and recovery management

COURSE DURATION: 4 Weeks
COURSE OUTCOMES:

By the end of this course, the learners will be able to
    • Make use of relational algebra, and tuple calculus to solve the given query
    • Demonstrate simple and complex SQL queries for a given database.
    • Apply various normalization techniques to improve the database design.
    • Apply File indexing techniques like B tree, B+ tree for effective retrieval of data.
    • Apply concurrency control and transaction processing techniques for the given scenario

COURSE CONTENTS:

Module 1: Solving Problems in Data Modeling and Query Language:
Identification of relationship in ER diagram. Solving problems using Relational Algebra. Use of Primary key and Foreign Key Constraints. Identification/Writing appropriate queries. Use of different Constraints and String functions.
Module 2: Implementation and Discussion on Extended Query Language:
Solving Queries with Join operations. Appropriate solutions for subqueries using Single row and Multi row subquery functions. Apply Complex Queries for the given Schema. Creation and Updation of View
Module 3: Analyzing the Relation using Normalization and File Organization:
Brief Introduction to Normal Form. Identification of Normal form in the given relation. Analyze the Relation Schema for 1NF,2NF,3NF, BCNF,4Nfand 5 NF.Need for File Indexing-B and B+ tree. Solution for File Indexing.
Module 4: Exploration of Transaction and Concurrency Control techniques:
Properties and States of Transaction. Identification of Serial Schedule, Conflict Serializability. Use of Two phase locking Protocol and Time stamp ordering. Applying Deferred update, Immediate Update and Shadow Paging

COURSE INSTRUCTORS:

    1. Dr.C.Deisy ,cdcse@tce.edu
    2. Dr.S.Sridevi, sridevi@tce.edu
    3. Dr.K.V.Uma, kvuit@tce.edu
    4. Ms.S.Pudumalar,spmit@tce.edu