Scribd Logo
Upload

Welcome to Scribd!

    • 8 views

    TMC 204 Database Management System

    Uploaded by

    Suraj Bisht
    DBMS course

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    TMC 204 Database Management System

    Uploaded by

    Suraj Bisht
    8 views3 pages
    DBMS course

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    DBMS course

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    8 views3 pages

    TMC 204 Database Management System

    Uploaded by

    Suraj Bisht
    DBMS course

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 3

    Subject Name: Database Management System Subject Code: TMC 204

    Course Name: Master of Computer Applications (MCA)

    1 Contact 45 L 3 T 0 P 0
    Hours:

    2 Examination Theory 0 3 Practical 0 0


    Duration(Hrs):

    3 Relative CWE: 25 MTE: 25 ETE: 50


    Weightage:

    4 Credits 0 3

    5 Pre-Requisite: Basic of Computer Science.

    6 Subject Area: Computer Science.

    7 Objective: To familiarize students with the concepts of Database and their


    application in real life software development

    8 Course Outcome:
    A student who successfully fulfills the course requirements will be able to:
    CO 1 Understand the concepts of database management and can differentiate the
    database approach with the file system approach.
    CO 2 Sketch and develop Entity Relationship Diagrams for real world problems and
    design databases.
    CO 3 Apply and analyze Relational database queries with the help of Structured
    Query Language (SQL) and construct simple and moderately advanced
    database queries in SQL/PL-SQL.
    CO 4 Understand the basics of NoSQL and differentiate it with relational databases.
    CO 5 Evaluate and Apply logical database design principles, including keys,
    constraints and database normalization and design normalized databases.
    CO 6 Understand and defend the importance of concurrency control in Transaction
    Processing Systems .

    9 Details of the
    Course:
    Unit CONTENT CONTACT
    No. HOURS
    1 Introduction to DBMS: An overview of database management 5
    system, Database System Vs File System, Database system
    concepts, data models. Advantages of DBMS, Schema and
    instances, Three schema architecture, data independence. Data

    Graphic Era Hill University, School of Computing, Effective from Academic Year 2022-23
    base languages and interfaces, Disadvantages of DBMS.
    2 Data Modeling and Entity Relationship Model: ER model concepts, 7
    notation for ER diagram, mapping constraints, keys, Concepts of
    Super Key, Candidate key, Primary key, Generalization,
    Specialization and Aggregation, reduction of an ER diagrams to
    tables, extended ER model, relationships of higher degree, ER Case
    Studies.
    Relational Data Base Model (RDBMS): Relational data model
    concepts, integrity constraints: entity integrity, referential integrity,
    Keys constraints, Domain constraints, Relational algebra:
    operations and queries.
    3 Introduction to SQL: Characteristics of SQL, Advantages of SQL, 13
    SQL data types and literals, Types of SQL commands, DDL, DML,
    DCL, and DQL statements, SQL operators and their use, Tables,
    views and indexes, Queries and sub queries, Aggregate functions,
    Insert, update and delete operations, Joins, Unions, Intersection,
    Minus.
    Overview of PL/SQL, Variables, Datatypes, Conditions, Loops,
    Procedures, Functions, Triggers and cursors.
    Introduction to NoSql Database, Comparison of NoSql with
    Relational Database, Types of NoSql Databases.
    4 High Level Data Base Design & Normalization: Functional 8
    dependencies, normal forms, first, second, third normal forms,
    BCNF, inclusion dependencies, loss less join decompositions,
    normalization using FD, MVD, and JDs.
    5 Transaction Processing Concepts: Transaction system, Testing of 8
    serializability, Serializability of schedules, conflict & view
    serializable schedule, recoverability, Recovery from transaction
    failures, log based recovery, checkpoints, deadlock handling.
    Concurrency Control: Concurrency control mechanism, locking
    Techniques for concurrency control.
    TOTAL 42

    11 Suggested Books:
    Sl. NAME OF AUTHORS/BOOKS/PUBLISHERS YEAR OF
    NO. PUBLICATION
    1 Elmasri and Navathe: Fundamentals of Database Systems, 5th 2007
    Edition, Pearson Education.
    2 Silberschatz, Korth and Sudharshan: Data base System 2006
    Concepts,5th Edition, Mc-GrawHill.
    3 C.J. Date, A. Kannan, S. Swamynatham: A Introduction to Database 1996
    Systems, 8th Edition, Pearson education.

    Graphic Era Hill University, School of Computing, Effective from Academic Year 2022-23
    4 Raghu Ramakrishnan and Johannes Gehrke: Database 2003
    rd
    Management Systems, 3 Edition, McGraw-Hill.

    Graphic Era Hill University, School of Computing, Effective from Academic Year 2022-23

    You might also like