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 43 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
Thanks for the timely response, appreciate it

at

  • Member
  • Posts: 359
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

Adults are resistant to the bacterium that causes Botulism. These bacteria thrive in honey – therefore, honey should never be given to infants since their immune systems are not yet resistant.

Did you know?

Patients who have undergone chemotherapy for the treatment of cancer often complain of a lack of mental focus; memory loss; and a general diminution in abilities such as multitasking, attention span, and general mental agility.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh In this 1900 cartoon, oil baron John D. Rockefeller holds the White House in the palm of his hand wh
Cumulative Standard Normal Distribution Cumulative Standard Normal Distribution
How to fully analyze the standard and factored form of a quadratic equation (Question 1) How to fully analyze the standard and factored form of a quadratic equation (Question 1)
Some Standard Shapes of Greek Vessels Some Standard Shapes of Greek Vessels
The Standard Rain Gauge The Standard Rain Gauge
Standard base-pairing relationships Standard base-pairing relationships
Video: Body plan of euglena Animation

For a complete list of videos, visit our video library