Subject Details
Dept     : CSE
Sem      : 4
Regul    : 2019
Faculty : Jacquelin Anushya
phone  : NIL
E-mail  : janushya.p.cse@snsct.org
583
Page views
49
Files
1
Videos
2
R.Links

Icon
Announcements

  • Question Bank

    Dear Students the Question Bank 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. MongoDB-Installing and Set up, Database creation and manipulation, Indexing and ordering. CASE Studies- Oracle,DB2: Storage and Indexing

  • Puzzles

    Dear Students the Puzzles has been uploaded for the following topics:
    integrity,
    RAID

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    Data Storage,
    Indexes,
    B+Tree,
    B -tree index file,
    File organisation,
    Hashing,
    Ordered indicies,
    Query processing overview,
    RAID

  • Puzzles

    Dear Students the Puzzles has been uploaded for the following topics:
    Data base management system

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    Dependencies and Normal forms,
    Functional Dependencies,,
    First,Second,Third Normal Forms,,
    Fourth Normal Form,Fifth Normal Form,
    Boyce/Codd Normal Form,
    Join Dependency,
    minimal covers,
    Normal Forms

  • Youtube Video

    Dear Students the Youtube Video has been uploaded for the following topics:
    Basic Concepts of database Normalization

  • Assignment

    Assignment topic is First,Second,Third Normal Forms, Dependency Preservation-Boyce/Codd Normal Form-Multivalued Dependencies and Fourth Normal Form- Join Dependencies and Fifth Normal Form and due date is 10-04-2023.

  • Assignment

    Assignment topic is First,Second,Third Normal Forms, Dependency Preservation-Boyce/Codd Normal Form-Multivalued Dependencies and Fourth Normal Form- Join Dependencies and Fifth Normal Form and due date is 18-04-2023.

  • Assignment

    Assignment topic is First,Second,Third Normal Forms, Dependency Preservation-Boyce/Codd Normal Form-Multivalued Dependencies and Fourth Normal Form- Join Dependencies and Fifth Normal Form and due date is 20-04-2023.

  • Resource Link

    Dear Students the Resource Link has been uploaded for the following topics:
    boyce codd normal form

  • 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 - ,
    Database Management system - Three-schema architecture of DBMS,,
    Components of DBMS,
    Entity –Relationship Model ,
    E/R diagram notations, ,
    E/R diagram notations, Examples

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:
    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.

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:
    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.

  • Question Bank

    Dear Students the Question Bank 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 - Conceptual data modeling - motivation, entities, entity types, attributes, relationships, relationship types, E/R diagram notations, Examples,
    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

  • Resource Link

    Dear Students the Resource Link has been uploaded for the following topics:
    Three Schema Architecture

  • Assignment

    Assignment topic is E-R Diagram for a Company Data Base and due date is 04-03-2023.

  • Assignment

    Assignment topic is E-R Diagram for a Company Data Base and due date is 13-02-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,
    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