Distinguish between the following: Data Description Language (DDL) and Data Manipulation Language (DML)

Data Description Language (DDL): DDL is used to define the various types of data in the data base and their relationship with each other. The basic functions performed by DDL are: Create tables, files, databases and data dictionaries. Specify the storage structure of each table on disk. Integrity constraints on various tables. Security and authorization information of each table. Specify the structure of each table. Overall design of the Database. Examples CREATE - to create a database and its objects like (table, index, views, store procedure, function, and triggers) ALTER - alters the structure of the existing database DROP - delete objects from the database Data Manipulation Language (DML): A language that enables users to access or manipulate data (retrieve, insert, update, delete) as organized by a certain Data Model is called the Data Manipulation Language (DML). A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. It can be of two types: Procedural DML - It describes what data is needed and how to get it. For example: Relational Algebra. Non-Procedural DML - It describes what data is needed without specifying how to get it. For example: Relational calculus. Examples SELECT - retrieve data from a database INSERT - insert data into a table UPDATE - updates existing data within a table DELETE - Delete all records from a database table MERGE - UPSERT operation (insert or update)