Exploring the Essential Functions of Database Management Systems (DBMS)

  A. XML XML (Extensible Markup Language) is a flexible, structured format used for storing and transporting data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. XML allows users to create their own customized tags, making it versatile for representing complex data structures in a wide range of applications, from web services to configuration files. B. JSON JSON (JavaScript Object Notation) is a lightweight data interchange format that is easy for humans to read and write and easy for machines to parse and generate. JSON uses a simple syntax of key-value pairs and arrays, making it an ideal format for transmitting data between a server and a web application, as well as for configuration files and data storage in a wide variety of applications.  C. AJAX AJAX (Asynchronous JavaScript and XML) is a technique used in web development to create interactive and dynamic web applications. It allows web pages to be updated ...

 WHAT IS SQL? SQL (Structured Query Language)  is a standardized programming language used for managing and manipulating relational databases. It allows users to create, read, update, and delete (CRUD) data within a database, as well as define and manage database schema. SQL includes components for data definition (DDL), data manipulation (DML), data control (DCL), and transaction control (TCL), making it a comprehensive tool for database management.

### Definitions: **A. Data Definition Language (DDL)** - **Definition**: Data Definition Language (DDL) is a subset of SQL used to define, modify, and manage database schema objects, such as tables, indexes, and constraints. - **Examples of DDL Commands**:   - `CREATE`: Used to create database objects like tables, views, and indexes.   - `ALTER`: Used to modify existing database objects.   - `DROP`: Used to delete database objects.   - `TRUNCATE`: Used to remove all records from a table, while keeping the table structure. **B. Interactive Data Manipulation Language (IDML)** - **Definition**: Interactive Data Manipulation Language (IDML) refers to SQL commands used interactively to query and modify data in a database. These commands are typically executed in a database management system (DBMS) interface or through SQL clients. - **Examples of IDML Commands**:   - `SELECT`: Used to retrieve data from one or more tables.   - `INSERT`: Used to add new records t...