-
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:DeadlockLocking protocolACID 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 DBMSE/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