There are 10 questions listed below. Based on the content in the M07 Readings, answer each question. Essay questions should be answered in this document. After completing, save and execute your scripts in Oracle Application Express. Upload this completed document and a copy of each of your scripts to IvyLearn.
• M07_LastNameFirstName_Functions
• M07_LastNameFirstName_View
*Note: For your statements to work, you will need to execute the scripts provided with the M06 Lab Assignment. To help with identifying tables that are needed, the ERD of the Academic Database has been included on the very last page of this activity.

(2 points each) Create the SQL statements for displaying the results for each of the following scenarios in the Academic Database. Save these statements in a script called M07_LastNameFirstName_Functions (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. Based on data in the Academic Database, complete the following:
1. Display the number of students that are eligible for exams.
2. Display the number of students that had a grade of 70 or above.
3. Display the highest exam score that Nina received.
4. Display the least number of days off.
5. Display the average exam grade received by each student.
6. Display the average exam grade for the OOAD course.
(4 points) Create the SQL statements for displaying the results for the following scenarios in the Academic Database. Save these statements in a script called M07_LastNameFirstName_Views (where LastName is your last name and FirstName is your first name). Run/execute these commands in Oracle Application Express. Based on data in the Academic Database, complete the following:
7. Create an SQL view called ParentInfoView to display the names of the parents for each student in the Academic Database. Run/execute these commands in Oracle Application Express.
In each script created above, include the following comments:
• At the beginning of the script include your name, the date, and the name of the script and a summary of what the script will do.
• Throughout the script, include comments to describe briefly what each section of script will do.

8. (8 points) What is the difference between a stored procedure and a user-defined function? Based on the Academic Database, identify and describe a scenario where it would be necessary to use a stored procedure or a user-defined function. Your answer should be addressed in 100 to 150 words.

ANSWER:

9. (8 points) Give your definition of a trigger. Based on the Academic Database, identify and describe a scenario where it would be necessary to use a trigger. Your answer should be addressed in 100 to 150 words.

ANSWER:

10. (8 points) Give your definition of a view. Based on the Academic Database, identify and describe a scenario where it would be necessary to use a view. Your answer should be addressed in 100 to 150 words.

ANSWER:

For fields that are marked as *, these are required/mandatory fields.
For fields that are marked as °, these are optional fields.
Primary key and foreign key fields have been labelled accordingly.

WeCreativez WhatsApp Support
Stuck with your assignment? When is it due? Chat with us.
👋 Hi, how can I help?