This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What are the four components of a database system? What will be an ideal ... (Read 80 times)

Mimi

  • Hero Member
  • *****
  • Posts: 542
on: Jul 7, 2018
What are the four components of a database system?
 
  What will be an ideal response?

Question 2

In an SQL query, which built-in function is used to compute the average value of numeric columns?
 
  A) AVG
  B) MEAN
  C) MAX
  D) SUM


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

adammoses97

  • Sr. Member
  • ****
  • Posts: 337
Reply #1 on: Jul 7, 2018
Answer to Question 1

The four components in a database system are: the user, the database application, the database management system (DBMS) and the database. The user interacts with the database application, which interacts with the DBMS, which controls the database. The functions of the database application include creating and processing forms, creating and transmitting queries and creating and processing reports. The DBMS creates databases, tables and supporting structures, manages database data, enforces rules and provides security. The database stores the user data, the database metadata, indexes, triggers, stored procedures and application metadata.

Answer to Question 2

A


Mimi

  • Member
  • Posts: 542
Reply 2 on: Jul 7, 2018
Excellent

phuda

  • Member
  • Posts: 348
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

The highest suicide rate in the United States is among people ages 65 years and older. Almost 15% of people in this age group commit suicide every year.

Did you know?

When Gabriel Fahrenheit invented the first mercury thermometer, he called "zero degrees" the lowest temperature he was able to attain with a mixture of ice and salt. For the upper point of his scale, he used 96°, which he measured as normal human body temperature (we know it to be 98.6° today because of more accurate thermometers).

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

There are more sensory neurons in the tongue than in any other part of the body.

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

Renin Angiotensi​n Aldosteron​e System Renin Angiotensi​n Aldosteron​e System
Urinary System Urinary System
Procedures and Diagnostic Tests Related to the Cardiovascular System Procedures and Diagnostic Tests Related to the Cardiovascular System
With input from sensory neurons, activation of the reticular activating system causes arousal of the ... With input from sensory neurons, activation of the reticular activating system causes arousal of the ...
Components of Weight Gain during Pregnancy Components of Weight Gain during Pregnancy
Male Reproductive System - Semen Male Reproductive System - Semen
Video: Proteins Defined, Hierarchy & Composition of Cells

For a complete list of videos, visit our video library