-
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