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

AngeliqueG

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

« previous next »
 

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

The toxic levels for lithium carbonate are close to the therapeutic levels. Signs of toxicity include fine hand tremor, polyuria, mild thirst, nausea, general discomfort, diarrhea, vomiting, drowsiness, muscular weakness, lack of coordination, ataxia, giddiness, tinnitus, and blurred vision.

Did you know?

Children with strabismus (crossed eyes) can be treated. They are not able to outgrow this condition on their own, but with help, it can be more easily corrected at a younger age. It is important for infants to have eye examinations as early as possible in their development and then another at age 2 years.

Did you know?

Drying your hands with a paper towel will reduce the bacterial count on your hands by 45–60%.

Did you know?

Drug-induced pharmacodynamic effects manifested in older adults include drug-induced renal toxicity, which can be a major factor when these adults are experiencing other kidney problems.

Concept map of disease and immune system Concept map of disease and immune system
A gasoline direct-injection system injects fuel under high pressure directly into the combustion ... A gasoline direct-injection system injects fuel under high pressure directly into the combustion ...
Conducting system of the heart. Conducting system of the heart.
The urinary system. The urinary system.
Female Reproductive System Female Reproductive System
The Vascular System The Vascular System
Video: Burn Animation

For a complete list of videos, visit our video library