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 37 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
YES! Correct, THANKS for helping me on my review

nguyenhoanhat

  • Member
  • Posts: 332
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Did you know?

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

Did you know?

Methicillin-resistant Staphylococcus aureus or MRSA was discovered in 1961 in the United Kingdom. It if often referred to as a superbug. MRSA infections cause more deaths in the United States every year than AIDS.

Methicilli ...
Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

In women, pharmacodynamic differences include increased sensitivity to (and increased effectiveness of) beta-blockers, opioids, selective serotonin reuptake inhibitors, and typical antipsychotics.

The nervous system. The nervous system.
The endocrine system. The endocrine system.
Using a water-based cleaning system helps reduce the hazards from using strong chemicals. Using a water-based cleaning system helps reduce the hazards from using strong chemicals.
A waste-spark system fires one cylinder while its piston is on the compression stroke and into ... A waste-spark system fires one cylinder while its piston is on the compression stroke and into ...
RAA system RAA system
Sympathetic and Parasympathetic Nervous System Sympathetic and Parasympathetic Nervous System
Video: Molecules, Membrane Permeability and Structure

For a complete list of videos, visit our video library