Menu
Subject Details
Dept     : AIDS
Sem      : 3
Regul    : 2023
Faculty : REVATHI P
phone  : NIL
E-mail  : revathi.p.ad@snsce.ac.in
1.42K
Page views
75
Files
3
Videos
2
R.Links

Icon
Announcements

  • Puzzles

    Dear Students the Puzzles has been uploaded for the following topics:</br>Database Design, </br>Transactions, </br>Implementation Techniques, </br>Advanced Topics

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:</br>Unit 4 Implementation Techniques, </br>Unit 4 Implementation Techniques, </br>Unit5 - Advanced Topics, </br>Unit5 - Advanced Topics

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Encryption and Public Key infrastructures – MangoDB- Challenges, </br>Flow Control, </br>Indexing and Hashing –Ordered Indices , </br>RAID – File Organization – Organization of Records in Files , </br>Distributed Databases: Architecture, Data Storage, Transaction Processing

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>B+ tree Index Files , </br>Query optimization using Heuristics - Cost Estimation., </br>NOSQL Databases: Introduction – CAP Theorem, </br>CAP Theorem, </br>Document Based systems – Key value Stores – Column Based Systems – Graph Databases

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:</br>unit 2 Database Design, </br>Relational Database, </br>unit 2 database design 16 marks

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Functional Dependencies , </br>Non loss decomposition, </br>1NF, 2NF,3NF, </br>Dependency Preservation, </br>Boyce Codd Normal form, </br>Multi-valued Dependencies and Fourth Normal Form , </br>Join Dependencies and Fifth Normal Form

  • Youtube Video

    Dear Students, the Youtube Video has been uploaded for the following topics:</br>Stored Function</br>Triggers

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Storage Technique, </br>B Tree

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Multiple Granularity locking – Deadlock Handling , </br>– Recovery Concepts – Recovery based on deferred and immediate update, </br>Shadow paging – ARIES Algorithm, </br>Multiple Granularity locking – Deadlock Handling , </br>Deadlock Handling, </br>Shadow Paging

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:</br>unit3 -Transactions 2 marks, </br>Transaction unit3 16 marks

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Need for Concurrency – Concurrency control , </br>Transaction support in SQL , </br>Two Phase Locking, </br>Time Stamp Validation based protocol, </br>Schedules – Serializability

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Transaction Concepts – ACID Properties

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Dynamic SQL, </br>Entity-Relationship model ER Diagram, </br>Enhanced-ER Model – ER-to-Relational Mapping

  • Resource Link

    Dear Students the Resource Link has been uploaded for the following topics:</br>Introduction to SQL</br>Introduction to Relational Algebra

  • Youtube Video

    Dear Students the Youtube Video has been uploaded for the following topics:</br>Introduction to DBMS

  • Assignment

    Assignment topic is Database System Architecture, Components of DBMS and due date is 12-09-2024.

  • Question Bank

    Dear Students the Question Bank has been uploaded for the following topics:</br>Unit 2 2 Marks questions, </br>unit1 16 marks

  • Puzzles

    Dear Students the Puzzles has been uploaded for the following topics:</br>Purpose of Database System , </br>Purpose of Database System , </br>SQL fundamentals

  • Lecture Notes

    Dear Students the Lecture Notes has been uploaded for the following topics:</br>Purpose of Database System , </br>Views of data , </br>Data Models , </br>Relational Algebra , </br>SQL fundamentals , </br>Advanced SQL features, </br>Introduction to relational databases, </br>Relational Model , </br>Embedded SQL, </br>Database System Architecture , </br>Dynamic SQL, </br>Keys