Subject Details
Dept     : CSE
Sem      : 4
Regul    : 2019
Faculty : Subhashree P
phone  : NIL
E-mail  : subashree.p.cse@snsct.org
306
Page views
42
Files
2
Videos
0
R.Links

Icon
Announcements

  • Youtube Video

    Dear Students the Youtube Video has been uploaded for the following topics:
    Case Study on Oracle DB Design and Query tools
    Normalization

  • Assignment

    Assignment topic is Case Study on Oracle DB Design and Query tools and due date is .

  • Assignment

    Assignment topic is Functional dependencies and due date is .

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    Purpose of DBMS,Views of Data,
    Components of DBMS,
    Data Models,
    DBMS Three schema architecture,
    Entity Relationship model,
    ER Diagram notations,
    Relational Data Model - keys, referential integrity and foreign keys,
    Relational Algebra,
    SQL fundamentals - Introduction, data definition in SQL,
    Table, key and foreign key definitions, update behaviors,
    Advanced SQL features,
    Embedded SQL,
    Intermediate SQL,
    Dynamic SQL,
    CASE Studies- OracleDatabase Design and Querying Tools; SQL Variations and Extensions,
    Dependencies,
    Normal Forms,
    Functional Dependency,
    Armstrong Axioms,
    Minimal Cover,
    2NF,3NF,
    4NF and 5NF,
    BCNF,
    Join Dependency,
    Transaction Concepts – ACID Properties,
    SCHEDULE,
    Serializability,
    Concurrency Control – Need for Concurrency,
    Locking Protocols,
    Two Phase Locking,
    Deadlock – Transaction Recovery,
    Save Points – Isolation Levels,
    SQL Facilities for Concurrency and Recovery,
    Data Storage,
    RAID,
    File Organisation,
    Indexes,
    Hashing,
    Ordered Indicies,
    B-Tree Index file,
    B+ Tree,
    Query Processing Overview

X
maheskumar
SNS COLLEGE OF ENGINEERING
Admin Dept
facbook_profile
facbook_profile