DR. PANKAJ DADHICH

SQL IN MYSQL PART-I

Desktop Publishing for Beginner By Dr. Pankaj Dadhich

Desktop Publishing for Beginner By Dr. Pankaj Dadhich :

COMPLETE SYLLABUS NOTES OF DBMS (B.A/B.COM/B.Sc PART-1) {COMPUTER APPICATION PAPER-2}

PDF HERE

Introduction of WAMP

Introduction of WAMP  Web Application Messaging Protocol (WAMP) ·          WAMP is a  high-level messaging routed protocol for distributed applications where the application components are distributed on multiple nodes and communicate with messages . ·          It was a subprotocol of websocket. ·          Provides two messaging patterns: Publish &am…

Overview of database recovery techniques in DBMS

Overview of database recovery techniques   ·          Database Recovery  is a process of recovering or restoring data in the database when a data loss occurs or data gets deleted by system crash, hacking, errors in the transaction, damage occurred coincidentally, by viruses, sudden terrible failure, commands incorrect implementation, etc ·          Reco…

Functional Dependency in DBMS

Functional Dependency in DBMS Functional Dependency is also known as “FDs” or a relationship. A relationship:- An attribute can determine other attributes functionally. The first attribute does not use for computing or calculating the value of the second attribute but it searches the value of the tuple corresponding to the first a…