2- Concepts of DBMS,RDBMS ,SQL and DBMS vs RDBMS
What is DBMS? Database Management Systems (DBMS) refer to the technology solution used to optimize and manage the storage and retrieval of data from databases. DBMS was designed to solve the fundamental problems associated with storing, managing, accessing, securing, and auditing data in traditional file systems. DBMS offers a systematic approach to manage databases via an interface for users as well as workloads accessing the databases via apps. The management responsibilities for DBMS encompass: --> Information within the databases --> The processes applied to databases, such as access and modification --> The database’s logic structure Benefits of DBMS Introducing DBMS software to manage databases results in the following benefits: Data security - DBMS allows organizations to enforce policies that enable compliance and security. Data sharing - Fast and efficient collaboration between users. Data integration - Instead of operating island of database ...