This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Given the tableCUSTOMER(CustID, Name, PhoneNum, AcctBalance)what is the standard SQL query phrase to ... (Read 40 times)

leilurhhh

  • Hero Member
  • *****
  • Posts: 560
on: Jul 7, 2018
Given the tableCUSTOMER(CustID, Name, PhoneNum, AcctBalance)what is the standard SQL query phrase to retrieve data for customers with an account balance greater than 50?
 
  A) WHERE CUSTOMER-AcctBalance > 50
  B) WHERE (CUSTOMER-AcctBalance > 50)
  C) WHERE AcctBalance > 50
  D) WHERE (AcctBalance > 50)
  E) HAVING AcctBalance > 50

Question 2

Briefly describe the four components of a database system.
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

jsm54321

  • Sr. Member
  • ****
  • Posts: 328
Reply #1 on: Jul 7, 2018
Answer to Question 1

C

Answer to Question 2

The components of a database system are: (1 ) the users, (2 ) the application programs, (3 ) the DBMS, and (4 ) the database. The users are the people that will employ the system to input new data, modify existing data, and delete data in order to perform their jobs. The application programs are computer programs that act as intermediaries between the users and the DBMS. The application programs produce forms, reports, and queries; they also translate user actions into data management requests for the DBMS. The DBMS manipulates the database. It receives data management requests from the computer applications and translates them into read and write commands for the database. The database contains the actual user data that the users need to perform their jobs.


leilurhhh

  • Member
  • Posts: 560
Reply 2 on: Jul 7, 2018
Gracias!

TheDev123

  • Member
  • Posts: 332
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

Adult head lice are gray, about ? inch long, and often have a tiny dot on their backs. A female can lay between 50 and 150 eggs within the several weeks that she is alive. They feed on human blood.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

Though Candida and Aspergillus species are the most common fungal pathogens causing invasive fungal disease in the immunocompromised, infections due to previously uncommon hyaline and dematiaceous filamentous fungi are occurring more often today. Rare fungal infections, once accurately diagnosed, may require surgical debridement, immunotherapy, and newer antifungals used singly or in combination with older antifungals, on a case-by-case basis.

Did you know?

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

Did you know?

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

CycleBeads help women use the Standard Days Method. CycleBeads help women use the Standard Days Method.
Urinalysis. During a simple urinalysis, a stick with colored blocks is dipped into a urine specimen. Urinalysis. During a simple urinalysis, a stick with colored blocks is dipped into a urine specimen.
Standard Model of Elementary Particles Standard Model of Elementary Particles
A standard employment application form may be used. A standard employment application form may be used.
How to write a quadratic equation in standard form when a graph is given How to write a quadratic equation in standard form when a graph is given
How to fully analyze the standard and factored form of a quadratic equation (Question 2) How to fully analyze the standard and factored form of a quadratic equation (Question 2)
Video: Coronary Heart Disease

For a complete list of videos, visit our video library