4) List and Describe three main capabilities or tools of a DBMS.
Answer: A data definition capability to specify the Structure of the content of the database. This capability would be used to Create database tables and to define the characteristics of the fields in each Table.
A Data dictionary to store definitions of data elements in the database and their Characteristics. In large corporate databases, the data dictionary may capture Additional information, such as usage; ownership; authorization; security; and The individuals, business functions, programs, and reports that use each data Element.
A Data manipulation language, such as SQL, that is used to add, change, delete, And retrieve the data in the database. This language contains commands that Permit end users and programming specialists to extract data from the database To satisfy information requests and develop applications.