Create an Account

Already have account?

Forgot Your Password ?

Home / Questions / How does one create a database and its structures? 8) Describe the functions of a databas

How does one create a database and its structures? 8) Describe the functions of a databas

How does one create a database and its structures?

8) Describe the functions of a database management system.

a. 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 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.

b. The second function of the DBMS is to process the database. Applications use the DBMS for four operations: to read, insert, modify, or delete data. The applications call upon the DBMS in different ways. 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 an application program, the program calls the DBMS directly to make the change.

c. A 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.

d. 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.

Dec 07 2019 View more View Less

Answer (UnSolved)

question Get Solution

Related Questions