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 89 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
:D TYSM

DylanD1323

  • Member
  • Posts: 314
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

In most cases, kidneys can recover from almost complete loss of function, such as in acute kidney (renal) failure.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen The functional structure of the peripheral nervous system. (A) Afferent or sensory neurons carry sen
The Autonomic Nervous System and Emotional Responding The Autonomic Nervous System and Emotional Responding
A typical port fuel-injection system squirts fuel into the low pressure (vacuum) of the intake ... A typical port fuel-injection system squirts fuel into the low pressure (vacuum) of the intake ...
Endocrine System Endocrine System
The limbic system is located within the higher brain, or cerebrum. The limbic system is located within the higher brain, or cerebrum.
Overview of the Solar System Overview of the Solar System
Video: Cortisol (protein catabolism, gluconeogenesis, vasoconstriction & anti-inflammation)

For a complete list of videos, visit our video library