In: Accounting
(Accountinf Information system)
List the three DBMS "languages" and describe who uses each and for what purpose.
Database languages are used for read, update and store data in a database. There are several such languages that can be used for this purpose
1.Data definition language (DDL)
It is used by designers, the purpose of using DDL is to create the database, describes logical view for each user, and specifies record or field security constrains.
2. Data manipulation language (DML)
It is used by programmers, the purpose of using it is to change database content, including data element creations, updates, insertions, and deletions.
3. Data query language (DQL)
It is used by IT users and decision makers, the purpose of using it is to integrate database, contains powerful, easy-to-use commands that enables users to retrieve, sort, order, and display data.