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
Problem 3. (25 points) Suppose f(x) = h(g(x)k(x)). If g(1) = 5, k(1) = 0, h(1) = -1, g'(1) = 7, k'(1) = -8, h'(1) = 2, and h'(0) = 6, find f'(1). Answer: f'(1) =
Apr 27 2021The path length of a tree T is the sum of the depths of all positions in T. Describe a linear-time method for computing the path length of a tree T.2. Define the internal...
Jun 13 2020On March 9, 2009, the Dow Jones Industrial Average reached a new low. The index closed at 6,547.05, which was down 79.89 that day. What was the return (in percent) of the...
May 10 2020Interest rates on 4-year Treasury securities are currently5.15%, while 6-year Treasury securities yield 7.3%. If the pureexpectations theory is correct, what does the mar...
Dec 04 2019Which of the following does not correctly characterize modern economic growth?A. It spread slowly across the globe, with some societies not having experienced it yet.B. I...
Jun 01 2021Explain David Ricardo's theory of comparative advantage. How does comparative advantage differ from absolute advantage? What is the relationship between comparative advan...
Aug 22 20216.8 Buried Verbs (Obj. 2) Your Task. Revise the following to unbury the verbs. a. Ms. Nelson gave an appraisal of the home’s value. b. Web-based customer service cause...
Jul 31 2020What is class invariant?
Aug 12 2021Insert necessary commas. In the space provided, indicate briefly the reason for each comma. For example, write series, parenthetical, direct address, date, address, essen...
Jul 10 2021what is the molar mass of zinc(II) oxide?
Jun 28 2021