Department of Computer Science and Engineering

B.Tech. II (CO) Semester - 4

L

T

P

C

CO204 : DATABASE MANAGEMENT SYSTEM (CS-II)

3

1

2

5
COURSE OBJECTIVES
  • To educate students with fundamental concepts of Data Base Design, Data Models, Different Data Base Languages.
  • To educate students to analyze Data Base design methodology, OLTP, OLAP and DB connectivity.
  • To get students acquainted with advanced features of RDBMS.
    		•
    COURSE OUTCOMES
    After successful completion of this course, student will be able to
    • Evaluate business information problem and find the requirements of a problem in terms of data.
    • Understand the uses the database schema and need for normalization.
    • Design the database schema with the use of appropriate data types for storage of data in database.
    COURSE CONTENT
    Introduction

    (02 Hours)

    Relational Database Design

    (08 Hours)

    Normalization – 1NF, 2NF, 3NF, BCNF, Higher Normal Forms, Denormalization.
    Query Processing   

    (08 Hours)

    Overview, General Strategies, Query Representation, Query  Transformation, Catalog Information, Estimated Size of relations, Measures of Query cost, Selection, Sorting, Join & other operations, Query Evaluation & Choice of Evaluation Plans.

    Transactions & Concurrency Control

    (08 Hours)

    ACID Properties, Serializability, Recoverability, The problems in Concurrency control, Semantics of Concurrent Transactions, Locking Scheme, Time - stamp based Protocols, Validation - based protocols, Deadlock handling, Recovery System - Failure Classification, Recovery & Atomicity, Buffer Management, Recovery with Concurrent Transactions, Failure with Loss of Nonvolatile Storage. 

    Object Oriented & Object Relational Databases

    (06 Hours)

    New Applications, The limitation due to 1NF, The Object-oriented Data Model - Persistent Programming languages. Nested Relational Model - Querying with Complex types. Comparison of Object-oriented & Object-relational Databases
    Advance Databases and Applications

    (10 Hours)

    Distributed Database, Database design for Decision Support, Data Preparation, Data Warehouses and Data Marts, OLAP. Datamining :Introduction, Functionalities, Classification of data mining systems, major issues in data mining, Temporal Database, Logic Based Databases,  Multimedia Databases, Spatial & Geographic Databases, Information Retrieval Systems, Web Warehousing, Parallel and Distributed DBMS.
    Tutorials will be based on the coverage of the above topics separately

    (14 Hours)

    (Total Contact Time: 42 Hours + 14 Hours = 56 Hours)
    PRACTICALS
    1. Query languages
    2. Database control systems and event management
    3. Mini Project
    BOOKS RECOMMENDED
    1. A Silberschatz, H. F. Korth, and S Sudarshan, "Database System Concepts", 6/E,TMH, 2010
    2. McFadden, F.Hoffer, Prescott : M. B "Modern database management", 8/E, Benjamin/Cummings Inc,2006
    3. C.J Date, "An Introduction to Database Systems", Publisher: Addison, Wesley, 8/E, 2003
    4. Raghu Ramakrishnan and Gehrke: "Database Management System", 3/E, WCB/McGraw-Hill,2003
    5. Margaret.H.Dunham , "Data Mining. Introductory and advanced topics", Pub:  Pearson Education, 2003