Handle relational databases using standard Structured Query Language (SQL)

1.1 Selected DBMS Installed and Setup What is a DBMS? A Database Management System (DBMS) is software used to store, manage, and retrieve data from a database. Common DBMS examples: MySQL (Open source) Microsoft SQL Server Oracle DB PostgreSQL Steps to Install a DBMS (e.g., MySQL) Download Installer Go to the official MySQL website and download the installer. Run Installer Follow the wizard to install the MySQL server. Set Root Password During installation, you will set the admin (root) password. Start the DBMS Service Use MySQL Workbench or Command Line Client to connect. Verify Installation Run a simple SQL query like: SELECT VERSION(); 1.2 User Logged into DBMS as per SOP What is SOP? SOP = Standard Operating Procedure . It is the step-by-step instruction followed to log in securely. 2.1 Database Created as Required To create a new data...