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 21 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
Wow, this really help

debra928

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

« previous next »
 

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

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?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Standard Schnauzer Standard Schnauzer
Standard precaution guidelines. Additional guidelines/protocols may be utilized depending on the ... Standard precaution guidelines. Additional guidelines/protocols may be utilized depending on the ...
a) Standard PCR machine used for genotyping and (b) agarose gel to detect DNA fragments. a) Standard PCR machine used for genotyping and (b) agarose gel to detect DNA fragments.
How to sketch a quadratic equation that is in standard form (Question 2) How to sketch a quadratic equation that is in standard form (Question 2)
A blade and assorted plates for a standard grinder A blade and assorted plates for a standard grinder
Write the following in standard form Write the following in standard form
Video: Cataract

For a complete list of videos, visit our video library