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 81 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

gcook

  • Member
  • Posts: 343
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

Did you know?

Medication errors are more common among seriously ill patients than with those with minor conditions.

Did you know?

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

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

Nursing process as a system Nursing process as a system
Color monitor for a computer system. Color monitor for a computer system.
Diseases and Disorders of the Respiratory System Diseases and Disorders of the Respiratory System
How to solve a linear system with three unknowns using substitution (Question 2 of 2) How to solve a linear system with three unknowns using substitution (Question 2 of 2)
Microbiology with Diseases by Body System, 3e (Bauman) Microbiology with Diseases by Body System, 3e (Bauman)
The components of vector B are Bx = -3.5 and By = -4.7, and the components of vector C are Cx = ... The components of vector B are Bx = -3.5 and By = -4.7, and the components of vector C are Cx = ...
Video: Hershey Chase Experiments

For a complete list of videos, visit our video library