Dear Students the Lecture Notes has been uploaded for the following topics:Database Design Process, ER Diagrams - Entities, Attributes, Relationships, Constraints, keys, extended ER features, Generalization, Specialization, Aggregation, Conceptual design with the E-R model, Dependencies and Normal forms , E-R Issues- weak entity set, code rules, Normalizations: 1NF,2NF,3NF, BCNF,4NF,5NF.
Dear Students the Lecture Notes has been uploaded for the following topics:Transaction Concepts – ACID Properties , serializability and its types 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. , Concurrency control, lock based protocols, multiple granularity. Recovery system, failure classification, storage structure, recovery and atomicity, log- based recovery, shadow paging, buffer management, failure with loss of non-volatile storage, advanced recovery techniques, remote backup systems.
Dear Students the Lecture Notes has been uploaded for the following topics:basics of SQL,DLL,DML, DCL, structure – creation, alteration, defining constraints – Primary key, foreign key, unique, not null, check, IN operator, Functions - aggregate functions, Built-in functions – numeric, date, string functions, set operations, sub-queries, correlated sub-queries, transaction control commands – Commit, Rollback, stored procedures, Triggers
Dear Students the Youtube Video has been uploaded for the following topics:DBMS INTRODUCTION
Assignment topic is DATABASE DESIGN FOR E-COMMERCE PLATFORM and due date is .
Dear Students the Question Bank has been uploaded for the following topics:ALL FIVE UNITS
Dear Students the Lecture Notes has been uploaded for the following topics:introduction to database systems , purpose of database system , views of data, data models , data base management system -building blocks , evaluation of data model , three schema architecture of DBMS, components of DBMS
