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 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
Suppose that in a later market period, the quantities supplied in the table in Problem 3-1 are unchanged. The quantity demanded, however, has increased by 30 million at e...Apr 02 2020
You are considering purchasing a bond which has a 10 year maturity, 10% coupon, and $1,000 par. If you require a 12% rate of return, what is the most you will pay for thi...Jul 07 2021
Microeconomics: Case Study I.Classification as One of the Four Basic Market ModelsMar 17 2020
For an equilibrium involving gaseous substances, what effect, in general terms, is realized when the volume of the system is decreased?Jun 14 2021
Use the following information to calculate the dollar cost of using a money market hedge to hedge 209,000 pounds of payables due in 180 days. Assume the firm has no exc...Jun 23 2021
In its 2012 Annual Report, Singapore Airlines, which primarily complies with IFRS, reported the following expected future minimum lease payments (in $ million).In its 201...Apr 24 2020
What is the role of demand and supply in price determination?Apr 19 2021
In the thermos shown in Fig. P8.42, the innermost compartment is separated from the middle container by a vacuum. There is a final shell around the thermos. This final sh...Jul 24 2020
Consider a Brayton cycle with air entering at 100 kPa, 300K, at 5 kg/s. The pressure ratio is 10 and the turbine inlet temperature is limited to 1450 K. Assume the compre...May 05 2020
Cecil Usher owned Belize NY, Inc. (Belize), a small construction company doing business in New York City. Belize purchased a commercial general liability insurance policy...Aug 08 2021