X
X
X

X

Database Management System

By Dr. B. Lavanya, Assistant Professor   |   University of Madras
This course aims at providing basic understanding of data, data bases, its storage using database structures, its accessing methods, transaction management and recovery procedures.  The objective of this course is to systematically teach the learner ,  Introduction to database, its architecture, procedural language formats and usage, relational data model in detail, query structures, query writing, usage of DML, DDL, TCS queries, query formatting, data base structure creation using normalization, query processing concurrent transaction processing, deadlock handling , storage structures using RAID, data security , distributed databases and recovery methods. 

Learners enrolled: 12334

SUMMARY

Course Status : Completed
Course Type : Not Applicable
Duration : 12 weeks
Start Date : 08 Jul 2019
End Date : 24 Sep 2019
Exam Date :
Category :
  • Computer Science and Engineering
  • Level : Undergraduate

    Share this course with your friends and family

    COURSE LAYOUT

    Week 1

    Introduction to DBMS,
    Filed based systems and its issues
    Three level architecture
    DML and DDL
    Query processing and transaction management


    Week 2

    Relational data model 
    database design 
    Relational integrity 
    constraints 
    Referential integrity 
    Relational algebra  
    Operations in relational algebra

    Week 3

    Tuple and Domain Relational calculus
    ER modelling,
    Constraints and cardinality relationships
    Extended ER model
    Specialization and Generalization
    ER and EER model of relational mappings

    Week 4

    Group by queries
    Nested queries Join
    Views, 
    Integrity and Constraints, 
    Assertion,Triggers

    Week 5

    Database designs, 
    Anomalies, Functional Dependency, 
    normalization, closure of FD, 
    Armstrong algorithms

    Week 6

    1NF, 2 NF, 3 NF, BCNF and Decomposition

    Week 7

    Transactions and Recovery, ACID properties, Roll back and Commit, Concurrency execution, Serialisation

    Week 8

    Precedence graphs, Recoverable Schedule, Concurrency control, Lock and Lock based protocol, 
    Deadlock detection, Time stamping, Failures and Recovery, Distributed Recovery, Two Phase Commit

    Week 9

    Storage structure, file organisation, Recovery and atomicity,
    Performance measures of discs, Database management, RAID levels

    Week 10

    Indices, B+ Tree, Hashing, Bitmap indices

    Week 11

    Query processing for different queries, sorting and different joins, Query optimizations

    Week 12

    Database Security, Data mining models and techniques, Distributed Databases, GIS

    BOOKS AND REFERENCES

     
     
    1. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, Fourth Edition, Tata McGraw Hill, 2002. 
     
    2. Ramez Elmasri, Shamkant B. Navathe, “Fundamentals of Database Systems”, FourthEdition ,addision weskey, 2002. 
     
    3. Raghu Ramakrishnan, “Database Management Systems”, Third Edition, McGraw Hill, 2002. 
     
    4. Peter Rob and Corlos Coronel, “Database Systems – Design, Implementation and Management, Fifth Edition, Thompson Learning, Course Technology, 2003. 

    INSTRUCTOR BIO


    Dr. B. Lavanya, Assistant Professor

    COURSE CERTIFICATE

    30% for in course Assessment & 70% of end-term Proctored Exam


    DOWNLOAD APP

    FOLLOW US