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

cam1229

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

« previous next »
 

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

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?

Alcohol acts as a diuretic. Eight ounces of water is needed to metabolize just 1 ounce of alcohol.

The principal components of a spectrophotometer The principal components of a spectrophotometer
Endocrine System - Fish Endocrine System - Fish
The Solar System The Solar System
Jets Created by a Black Hole in a Binary System Jets Created by a Black Hole in a Binary System
Disorders and Diseases of the Endocrine System Disorders and Diseases of the Endocrine System
The urinary system. The urinary system.
Video: Pressure Flow Model Animation

For a complete list of videos, visit our video library