A database management system (DBMS) is
specialized software that is used to create, access, control,
and manage the database. The core of the DBMS is a
database engine.
• A data definition language (DDL) is that part of the engine used
to physically define tables, fields, and structural relationships.
• A data manipulation language (DML) is that part of the engine
used to create, read, update, and delete records in the database,
and navigate between different files (tables) in the database.