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 2020You 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 2021Microeconomics: Case Study I.Classification as One of the Four Basic Market Models
Mar 17 2020For an equilibrium involving gaseous substances, what effect, in general terms, is realized when the volume of the system is decreased?
Jun 14 2021Use 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 2021In 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 2020What is the role of demand and supply in price determination?
Apr 19 2021In 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 2020Consider 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 2020Cecil 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