What functions are common to most database management system

Assignment Help Civil Engineering
Reference no: EM131395180

What Functions Are Common to Most Database Management Systems? Database management systems (DBMSs) are available for many sizes and types of computers. Whether designed for a small or large computer, most DBMSs perform common functions. A data dictionary, sometimes called a repository, contains data about each fi le in the database and each field in those fi les. A DBMS offers several methods to retrieve and maintain data in the database, such as query languages, query by example, forms, and report generators. A query language consists of simple, English-like statements that allow users to specify the data to display, print, or store. Query by example (QBE) has a graphical user interface that assists users with retrieving data. A form, sometimes called a data entry form, is a window on the screen that provides areas for entering or modifying data in a database. A report generator, also called a report writer, allows users to design a report on the screen, retrieve data into the report design, and then display or print the report. To supply security, most DBMSs can identify different levels of access privileges that define the actions a specific user or group of users can perform for each fi eld in a database. If a database is damaged or destroyed, a DBMS provides techniques to return the database to a usable form. A backup is a copy of the database. A log is a listing of activities that modify the contents of the database. A recovery utility uses the logs and/or backups to restore the database using roll forward or rollback techniques. In a roll forward, also called forward recovery, the DBMS uses the log to reenter changes made to the database since the last save or backup. In a rollback, also called backward recovery, the DBMS uses the log to undo any changes made to the database during a certain period. Continuous backup is a backup plan in which all data is backed up whenever a change is made.

Reference no: EM131395180

Questions Cloud

Discuss about the ethernet switches : Since switches are generally used within the local network configuration, why would a network administrator configure port security on a switch? Can you think of a reason based on your study this week? Don't just give the answer from the materials..
What are file maintenance techniques and validation : Types of validity checks include an alphabetic check, a numeric check, a range check, a consistency check, a completeness check, and a check digit.
Discuss factors that drive global airline supply and demand : MBAA 523- Discuss the factors that drive global airline supply and demand. An airline loses money on one of its routes but has decided to continue to provide service. Could this decision be economically rational in short-run? In the long-run?
Paper on the standing knowledge of the chosen question : Choose a problem faced by clients in your practice area that you think is important ans would like to learn more about. Write a five (5) page literature review paper on the standing knowledge of the chosen question
What functions are common to most database management system : In a rollback, also called backward recovery, the DBMS uses the log to undo any changes made to the database during a certain period. Continuous backup is a backup plan in which all data is backed up whenever a change is made.
Pick one of your favorite websites and find its ip address : Your friend is having a hard time studying TCP/IP addressing for the exam. Pick one of your favorite websites and find its IP address (you can open the command prompt in your computer and ping the website URL to get the IP address), then analyze t..
What is katrinas and gooeys dominant strategy : ECO 550- What is Katrina's Dominant Strategy? What is Gooey's Dominant Strategy? What Cell (A, B, C, D) represents the solution? What would the consequence be for Katrina's if they had not accurately predicted their rival's pricing strategy?
Describe three different policies : Describe three different policies that could be used to increase the growth rate of the potential GDP. Identify whether each policy is aimed at technology, capital formation, or labor supply.
Maximum amount of steel or aluminum : GIVEN: The maximum amount of steel or aluminum that Canada and France can produce if they fully use all the factors of production at their disposal with the best technology available to them is shown here: Canada had 500 in steel(tons), France has..

Reviews

Write a Review

 

Civil Engineering Questions & Answers

  Find probability that in sample of bulbs will be defective

Find the probability that in a sample of 100 bulbs, (a) 0 bulbs will be defective (b) 1 bulbs will be defective (c) 2 bulbs will be defective (d) 3 bulbs will be defective (e) 4 bulbs will be defective (f) 5 bulbs will be defective

  What is the dimension of a strip footing

Based on given soil data. Soil is a loam with grain the #200sieve. The Liquid Limit = 29, Plastic Limit = 24, friction angleφ = 25 degree, cohesion c = 0.21 tons/sf, unit weight γ=124lb/ft3.

  What is the minimum radius of curvature for a curve such

The coefficient of friction between a car’s tires and the road is such that the car can generate a maximum deceleration of 1.1g without experiencing slip. What is the minimum radius of curvature

  A fitness club in virginia is planning a building addition

A fitness club in Virginia is planning a building addition for an indoor pool. An architact has recomeded using ACQ pressure treated Eastern white pine No. 1 joists hung from glulam beams with galvanived fasteners/connectors

  Determine the cross-sectional area of the concrete

determine the cross-sectional area of the concrete and steel and the stresses in each if the column deforms .01 inch while carrying 100 K load. The cross sectional area is 15 inch and column height is 10 feet.

  Determine the horizontal distance the shot travels from the

When the athlete releases the shot, it is 1.88 above the ground and its initial velocity is = 13.6 . The angle of the release is 30 degrees. Determine the horizontal distance the shot travels from the point of release to the point where it hits the g..

  What is distinction in the middle of dependability

What is distinction in the middle of dependability and validities (identified with likelihood and factual)?

  What would the gram molecular weight of a gas of 1.0 micron

If aerosol particles were considered to be extremely large gas molecules, what would the gram molecular weight of a gas of 1.0 micron diameter particles having a density of 1000 kg/cubic meter.

  Determine the most economical and safe design

Determine the most economical and safe design- An axial load P is supported by a short W8 X 40 column of a cross-sectional area A = 11.7 in2 (inches squared) and is distributed to a concrete foundation by a square plate as shown

  Determine the braking efficiency of car

Two cars are traveling on level terrain at 60 mi/h on a road with a coefficient of adhesion of 0.8. The driver of car 1 has a 2.5-s perception/reaction time and the driver of car 2 has a 2.0-s perception/reaction time

  Find mach number and the stagnation temperature on the nose

A jet plane flies at an altitude of 40 000 ft where the air is at -40 F, 6.5 psia, with a velocity of 625 mi/h. Find the Mach number and the stagnation temperature on the nose.

  Compute its negative eigenvalue and associated eigenvector

Construct the phase diagram for the system, and compute its negative eigenvalue and the associated eigenvector.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd