Describe the functions of a database management system (DBMS)

What will be an ideal response?

A database management system (DBMS) is a program used to create, process, and
administer a database.
1. Database developers use the DBMS to create tables, relationships, and other structures in the
database. To create a new table, the developer just fills out a new table's metadata into a form. To
modify an existing table–for example, to add a new column–the developer opens the metadata
form for that table and adds a new row of metadata.
2. The second function of the DBMS is to process the database. The DBMS provides
applications for four processing operations: to read, insert, modify, or delete data. These
operations are requested in application calls upon the DBMS. From a form, when the user enters
new or changed data, a computer program that processes the form calls the DBMS to make the
necessary database changes. From a Web application, a program on the client or on the server
application program calls the DBMS directly to make the change.
3. The third DBMS function is to provide tools to assist in the administration of the database.
Database administration involves a wide variety of activities. For example, the DBMS can be
used to set up a security system involving user accounts, passwords, permissions, and limits for
processing the database. In addition to security, DBMS administrative functions include backing
up database data, adding structures to improve the performance of database applications,
removing data that are no longer wanted or needed and similar tasks.

Business

You might also like to view...

One of the main benefits of the sale-leaseback transaction would be:

A. you can get a deposit back with no objection B. you have the option to lease the property back after the termination of the lease C. the ability of the seller to deduct all of his future rent payments as business expenditures D. the ability to maintain the book value of the new buyer

Business

If Herman, a real estate broker, signs an exclusive listing with Otto, a home owner, and before the house is sold it burns to the ground, how did the employment relationship terminate, if it did?

a) operation of law b) revocation of authority c) none of the above

Business