Database Management System(DBMS)

• A Database Management System(DBMS) is a collection of computer programs for organizing the information in a database.
• A DBMS supports the structure of the database in a standard format and provides tools for data input, verification, storage, retrieval, query and manipulation.

Types 

• The most popular relational DBMS for home us is Microsoft Access
• Enterprise relational DBMS's include DB2, Oracle, SQL Server and MySQL.

Schema 

• A schema is the logical and physical design of a database
• A sub-schema is a description of a subset of the database. Normally only programmers and managers need access to a sub-schema. 

Creating/Modifying

• Schema and sub-schema's are entered into the DBMS via a data definition language(DDL).
• Databases are manipulated using a data manipulation language(DML).