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

TheNamesImani

  • Member
  • Posts: 334
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

About 100 new prescription or over-the-counter drugs come into the U.S. market every year.

Did you know?

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

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?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

GI conditions that will keep you out of the U.S. armed services include ulcers, varices, fistulas, esophagitis, gastritis, congenital abnormalities, inflammatory bowel disease, enteritis, colitis, proctitis, duodenal diverticula, malabsorption syndromes, hepatitis, cirrhosis, cysts, abscesses, pancreatitis, polyps, certain hemorrhoids, splenomegaly, hernias, recent abdominal surgery, GI bypass or stomach stapling, and artificial GI openings.

The nurse is using Standard Precautions to draw blood. The nurse is using Standard Precautions to draw blood.
Standard Medical Record and Types of Reports Found in Record Standard Medical Record and Types of Reports Found in Record
A standard employment application form may be used. A standard employment application form may be used.
Three standard sizes of cuffs: a small cuff for a child or frail adult; a normal-sized adult cuff; ... Three standard sizes of cuffs: a small cuff for a child or frail adult; a normal-sized adult cuff; ...
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.
A karyotype arranges the chromosomes in a standard format A karyotype arranges the chromosomes in a standard format
Video: Hyperglycemia Animation

For a complete list of videos, visit our video library