Briefly describe the function of an application program in a ...

[james9437]

Briefly describe the function of an application program in a database system.
 
  What will be an ideal response?

Question 2

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to change the value of the Advisor field to 'Smith' for all rows in the STUDENT table?
 
  A) UPDATE STUDENT SET Advisor = 'Smith';
  B) MODIFY STUDENT SET Advisor = 'Smith';
  C) MODIFY Advisor SET STUDENT = 'Smith';
  D) UPDATE Advisor = 'Smith';
  E) SET STUDENT Advisor = 'Smith';

[raili21]

Answer to Question 1

The application program is responsible for creating and processing forms. The application displays the form to the user, allows the user to complete the data entry, evaluates the form to determine which data management tasks need to be performed, and transmits the appropriate requests to the DBMS. The application creates and transmits queries. The queries are requests for data that are created in a language like SQL, and transmitted to the DBMS to have the requested data returned to the application program. The application also creates and processes reports. The query to retrieve the necessary data for the report is sent to the DBMS. When the DBMS returns the needed data, the application manipulates it as necessary to create the requested report. The application program also applies application logic to control the manipulation of data in accordance with the business rules. Finally, the application program is responsible for providing control. Control must be exercised to allow the users to make choices for functions and tasks as appropriate for their jobs. Also, control must be exercised to manage the activities of the DBMS.

Answer to Question 2

A

[james9437]

TY

[raili21]

Happy to Help