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

leilurhhh · **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?

jsm54321 · **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.