What functions are common to most database management system

Assignment Help Civil Engineering
Reference no: EM131395143

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: EM131395143

Questions Cloud

Form of argumentation - the great pyramid at giza : Determine whether each argument is cogent or uncogent.- Constructing the great pyramid at Giza required lifting massive stone blocks to great heights.
How is a file processing approach different from database : Data in a database also can be more vulnerable than data in file processing systems.
Explain the approaches that you can take as the hr manager : You are the HR manager for a small retail company that sells a high volume of products over the Internet. Your company is growing rapidly due to increased Internet sales. Your company prides itself on providing high-quality products and services...
Form of argumentation - listening to rock and roll music : Determine whether each is strong or weak, and note the relationship between your answer and the truth or falsity of the premise(s) and conclusion.- People have been listening to rock and roll music for over a hundred years.
What functions are common to most database management system : Continuous backup is a backup plan in which all data is backed up whenever a change is made.
Represent the equilibrium quantity of gasoline : Let QMARKET represent the equilibrium quantity of gasoline, and let QOPTIMUM represent the socially optimal quantity of gasoline. Which of the following inequalities is correct?
Determine whether given argument is cogent or uncogent : Determine whether each argument is cogent or uncogent.- Paleontologists have unearthed the fossilized bones of huge reptiles, which we have named dinosaurs.
Why may a geo agree to work for a salary of dollar one : EGO 499- Why may a GEO agree to work for a salary of $1? Do you expect GEO‘s pay-performance sensitivity to increase or decrease with the volatility of the firm‘s stock returns. Explain.
What are characteristics of relational database : One application that uses multi dimensional databases is a data warehouse, which is a huge database that stores and manages the data required to analyze historical and current transactions. A smaller version of a data warehouse is the data mart, w..

Reviews

Write a Review

Civil Engineering Questions & Answers

  Engineering ethics and ethical issue

what is the engineering ethics course where to write about any engineering ethical case and discuss the ethical issue?

  Engineering ethics and concept and cases

what is the engineering ethics case related to civil engineering with reference and discuss all the engineering ethics issues which covered the "Engineering etics concepte and cases?

  Transportation and management

In the construction management, there is a lot of procurement route that are necessary and suitable for the construction industry.

  Supporting Investment Promotion: ERNST & YOUNG

Ernst & young is currently providing support to various sectors. In this regards it was felt that if this report is able to document good practices currently being adopted or planned in ceramic sector.

  Personalized Cancer Therapy-A step forward

Cancer is the uncontrolled growth of abnormal cells in the body resulting in tumours that can be benign or malignant (cancerous cells). A proper treatment is necessary to fight with this serious disease.

  Discuss the different environmental companies

Discuss the different agencies, institutes, centers, different environmental companies that are active in UAE.

  Develop a simple urban constructed wetland design

Develop a simple urban constructed wetland design.

  Evaluate company performance in relation to GRI standards

Evaluate company performance in relation to GRI standards and comment on Stigler's theory.

  Water system design

Determine the corresponding error in the computed discharge

  Hydraulic behaviour in open channel

Describe how test flumes and associated equipment are used to assess and confirm hydraulic behaviour in open channel

  Write a paper on steel sustainability

Write a paper on steel sustainability.

  Writing case study about bridge collapse

Writing case study about bridge collapse

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