Subject Details
Dept     : CSE
Sem      : 4
Regul    : 2019
Faculty : vasuki S
phone  : NIL
E-mail  : vasuki.s.cse@snsct.org
636
Page views
54
Files
5
Videos
2
R.Links

Icon
Announcements

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    Data Storage and Indexes,
    RAID- File organization,
    Indexing and Hashing,
    Ordered Indices,
    B+ Tree Index Files & B Tree Index Files,
    Static Hashing – Dynamic Hashing,
    Query Processing Overview,
    CASE Studies- Oracle,DB2: Storage and Indexing,
    MongoDB, Database creation and manipulation, Indexing and ordering

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    Purpose of Database System, Views of data ,
    Data Models,
    Database Management system - Three-schema architecture of DBMS,
    Components of DBMS,
    Entity-Relationship Model,
    Entities, entity types, attributes, relationships,
    E/R diagram notations, Examples,
    Relationship types

  • Youtube Video

    Dear Students the Youtube Video has been uploaded for the following topics:
    SQL FUNDAMENDALS

  • Assignment

    Assignment topic is CASE Studies- Oracle:Database Design and Querying Tools; SQL Variations and Extensions and due date is 04-05-2023.

  • Assignment

    Assignment topic is CASE Studies- Oracle:Database Design and Querying Tools; SQL Variations and Extensions and due date is 05-05-2023.

  • Assignment

    Assignment topic is CASE Studies- Oracle:Database Design and Querying Tools; SQL Variations and Extensions and due date is 08-04-2023.

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:
    UNIT II AND III

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    Dependencies and Normal forms - Functional Dependencies,
    First, Second Normal Forms,
    Join Dependencies and Fifth Normal Form,
    Multi-valued Dependencies and Fourth Normal Form,
    Dependency Preservation –Boyce/Codd Normal Form,
    Third Normal Forms,
    Transaction Concepts – ACID Properties,
    Schedules,
    Serializability,
    Concurrency Control – Need for Concurrency,
    Locking Protocols ,
    Two Phase Locking,
    Deadlock – Transaction Recovery,
    Save Points – Isolation Levels,
    SQL Facilities for Concurrency and Recovery

  • Youtube Video

    Dear Students the Youtube Video has been uploaded for the following topics:
    Deadlock
    Locking protocol
    ACID Properties

  • Puzzles

    Dear Students the Puzzles has been uploaded for the following topics:
    PUZZLE,
    PUZZLE 1,
    PUZZLE 2

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:
    QUESTION BANK,
    QUESTION BANK

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:
    INTRODUCTION,
    RELATIONAL MODEL ,
    DATABASE DESIGN ,
    TRANSACTIONS ,
    PHYSICAL STORAGE AND MONGODB

  • Resource Link

    Dear Students the Resource Link has been uploaded for the following topics:
    Database Management system - Three-schema architecture of DBMS
    E/R diagram notations, Examples

  • Assignment

    Assignment topic is E-R DIAGRAM and due date is 15-03-2023.

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    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,
    Intermediate SQL,
    Advanced SQL features,
    Embedded SQL,
    Dynamic SQL,
    CASE Studies- Oracle:Database Design and Querying Tools; SQL Variations and Extensions

X
maheskumar
SNS COLLEGE OF ENGINEERING
Admin Dept
facbook_profile
facbook_profile