What is data description language (DDL)? Explain in brief basic functions of DDL.

Data Description Language (DDL) is used to define the various types of data in the database and their relationship with each other. Basic functions performed by DDL are given as under:- To create tables, files, databases and data dictionaries; To specify the storage structure of each table on disk; To enforce Integrity constraints on various tables; To provide security and authorization information of each table; To specify the structure of each table; and To make overall design of the Database.