Scribd Logo
Upload

Welcome to Scribd!

    • 26 views

    TBC 302 Database Management System-1

    Uploaded by

    vanshikavanshika920
    hrm

    Copyright:

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

    TBC 302 Database Management System-1

    Uploaded by

    vanshikavanshika920
    26 views2 pages
    hrm

    Original Title

    TBC 302 Database Management System-1 (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    hrm

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    26 views2 pages

    TBC 302 Database Management System-1

    Uploaded by

    vanshikavanshika920
    hrm

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Subject Name: Database Management System Subject Code: TBC 302

    Course Name: Bachelor of Computer Applications (BCA)

    1 Contact Hours: 42 L 2 T 1 P 0

    2 Examination Duration(Hrs): Theory 0 3 Practical 0 0

    3 Relative Weightage: CWE: 25 MTE: 25 ETE: 50

    4 Credits: 0 3

    5 Semester: 
    Autumn Spring Both

    6 Pre-Requisite: Basic knowledge of computer fundamentals.

    7 Subject Area: Computer Applications

    8 Objective: To familiarize students with the Data Base Management System

    9 Course Outcomes: 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.
    CO 4 Evaluate and Apply logical database design principles, including keys, constraints and
    database normalization and design normalized databases.
    CO 5 Understand and defend the importance of concurrency control in Transaction Processing
    Systems.
    CO 6 Examine the importance of recovery management in databases and solve deadlock
    related problems.

    10 Details of the Course:


    Unit CONTENT CONTACT
    No. HOURS
    1 Introduction: An overview of database management system, Database 9
    System Vs File System, Database system concepts, data models. Advantages
    of DBMS, Schema and instances, Three schema architecture, data
    independence. Data base languages and interfaces, Disadvantages of DBMS.
    Data modeling using the Entity Relationship Model: ER model concepts,
    notation for ER diagram, mapping constraints, keys, Concepts of Super Key,

    Graphic Era Hill University, 2022, Review-6, w.e.f.: 2022-23


    candidate key, primary key, Generalization, specialization and aggregation,
    reduction of an ER diagrams to tables, extended ER model, relationships of
    higher degree.
    2 Relational Data Model and Relational Algebra: Relational data model 9
    concepts, integrity constraints: entity integrity, referential integrity, Key
    constraints, Domain constraints. Relational algebra, Operations of relational
    algebra, queries in relational algebra.
    3 Introduction to SQL: Characteristics of SQL, Advantages of SQL, SQL data 8
    types and literals, Types of SQL commands, SQL operators and their
    procedure, Tables, views and indexes, Insert, update and delete operations,
    Queries and sub queries, Scalar and Aggregate functions, Joins, Unions,
    Intersection, Minus.
    4 High Level Data Base Design & Normalization: Functional dependencies, 8
    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 and view serializable
    schedule, recoverability, Recovery form transaction failures, deadlock
    handling.
    Concurrency Control Techniques: Concurrency control, locking Techniques
    for concurrency control.
    TOTAL 42

    11 Suggested Books:
    Sl.N NAME OF AUTHERS/BOOKS/PUBLISHERS YEAR OF
    O PUBLICAT
    ION/REPRI
    NT
    th
    1 Elmasri and Navathe: Fundamentals of Database Systems, 5 Edition, Pearson 2007
    Education.
    2 Silberschatz, Korth and Sudharshan: Data base System Concepts,5 th Edition, 2006
    Mc-GrawHill.
    3 C.J. Date, A. Kannan, S. Swamynatham: A Introduction to Database Systems, 1996
    8th Edition, Pearson education.
    4 Raghu Ramakrishnan and Johannes Gehrke: Database Management Systems, 2003
    3rd Edition, McGraw-Hill.

    Graphic Era Hill University, 2022, Review-6, w.e.f.: 2022-23

    You might also like