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 49 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
Thanks for the timely response, appreciate it

atrochim

  • Member
  • Posts: 331
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

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?

After 5 years of being diagnosed with rheumatoid arthritis, one every three patients will no longer be able to work.

Did you know?

According to the FDA, adverse drug events harmed or killed approximately 1,200,000 people in the United States in the year 2015.

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?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Tracheal Tube Respiratory System as diagrammed in a generalized insect Tracheal Tube Respiratory System as diagrammed in a generalized insect
Concept map of disease and immune system Concept map of disease and immune system
Procedures and Diagnostic Tests Related to the Male Reproductive System Procedures and Diagnostic Tests Related to the Male Reproductive 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 ...
A typical electric cooling fan assembly showing the radiator and related components. A typical electric cooling fan assembly showing the radiator and related components.
The experimental system that permits observation of rotation in the F1 component of F1F0 ATP (b) The experimental system that permits observation of rotation in the F1 component of F1F0 ATP (b)
Video: Prone Position

For a complete list of videos, visit our video library