Database Management course
Data definition and Data manipulation
language
Individual Assignment
Name – Eliroe Elias
Section – CS4
Id – UUR00185/17
Submission Date- 9-May-2025
Introduction to Database languages
Database languages are special types of computer languages used to create, manage, and
interact with databases. They are essential tools for working with a Database Management
System (DBMS), allowing users to define database structures, insert and update data, retrieve
information, and control access.
Data Definition Language (DDL)
Data Definition Language (DDL) consists of SQL commands that establish a database's
framework. It is responsible for setting up structures such as tables and schemas, modifying their
design, and removing them when they are no longer needed. DDL provides the foundation for
database organization by defining structures, enforcing constraints, and allowing modifications
as data needs evolve. By creating and managing tables, indexes, and relationships, it ensures
databases remain structured, scalable, and efficient.
Data Definition Language (DDL) plays a crucial role in which help maintain accurate and valid
data. DDL also supports schema evolution, allowing changes to the database structure—such as
adding columns or altering data types—without losing existing data. Additionally, it contributes
to performance optimization by enabling the creation of indexes and partitioning, which improve
data access efficiency.
Data Manipulation Language (DML)
Data Manipulation Language (DML) is a component of SQL used to insert, retrieve, modify, and
delete records within a database structure. Unlike DDL, which defines database objects
like tables and indexes, DML manages data within those structures. DML also helps maintain
data consistency by working alongside constraints and triggers, which automatically enforce
business rules during data operations. In modern systems, DML queries can be optimized for
performance, and they often interact with APIs and applications, making them the core of
dynamic, data-driven software.
Key similarity of DDL and DML
Similarities Between DDL and DML:
1. Part of SQL:
Both DDL and DML are components of SQL, the standard language used to interact with
relational databases.
2. Used in Database Management:
Both are used to manage and interact with the database — DDL defines and modifies the
structure of database objects, while DML handles the data within those structures.
3. Executed Using SQL Commands:
Both involve the use of SQL commands like CREATE, INSERT, SELECT, etc… though they
serve different purposes.
4. Processed by the DBMS:
Both are interpreted and executed by a Database Management System (DBMS), such as
MySQL, PostgreSQL, or Oracle.
5. Can Be Used in Scripts or Programs:
Both DDL and DML statements can be embedded in scripts or application code for
automation and interaction with databases.
Key difference of DDL and DML
Aspect DDL DML
Purpose Defines and Works with the actual data stored in database tables.
manages the
database structure,
schema, and
objects.
Command CREATE, INSERT, UPDATE, DELETE, SELECT, MERGE
s ALTER, DROP,
TRUNCATE,
COMMENT,
RENAME
Impact Modifies the Modifies or retrieves data within existing tables without
database structure changing the structure.
(e.g., adding or
removing tables,
columns, indexes).
