1. Grading Database Expansion: Expand on the grading database from prior exercises. Construct and execute an SQL query that calculates your cumulative grade in this course as of the present date. Your query should display:

• Student details.
• Count of each type of deliverable submitted.
• Average grade for each deliverable type.
• Points allocated for each deliverable contributing to your final grade.

Execute the SQL command to validate its functionality. Provide both the SQL code and a screenshot depicting the result. If the SQL command is flawed, include the error message screenshot. Note: Submissions lacking evidence of code execution will not be evaluated.

2. SQL Exercises from Database Concepts Book: Respond to questions 3.49 - 3.53 from the "Exercises" section at the conclusion of Chapter 3 in the Database Concepts book (located on page 258 of the 10th edition). For each query:

a. Question: Reproduce the question verbatim (highlighted in bold).

b. Response: Present your SQL code, followed by a screenshot showcasing the result. If there's a mistake in the SQL, offer the error message screenshot. Note: Responses missing proof of code execution will not be assessed.

c. Utilize the database referenced on page 15. Refer to the accompanying image below for clarity.

d. For the book question you do not have to use MS Access - SQLITE compiler will also be accepted.

For the first Portion my grade in this class are Quiz 1:90%, Quiz2: 85%, and Quiz3: 95%,

The Book questions are:

Exercises

The following is a set of tables for the Art Course database shown in Figure 1-12. For the data for these tables, use the data shown in Figure 1-12.

CUSTOMER (CustomerNumber, CustomerLastName, CustomerFirstName, Phone)

COURSE (CourseNumber, Course, CourseDate, Fee)

ENROLLMENT (CustomerNumber, CourseNumber, AmountPaid)

where:

CustomerNumber in ENROLLMENT must exist in CustomerNumber in CUSTOMER

CourseNumber in ENROLLMENT must exist in CourseNumber in COURSE

CustomerNumber and CourseNumber are surrogate keys. Therefore, these numbers will never be modified, and there is no need for cascading updates. No customer data are ever deleted, so there is no need to cascade deletions. Courses can be deleted. If there are enrollment entries for a deleted class, they should also be deleted.

These tables, referential integrity constraints, and data are used as the basis for the SQL statements you will create in the exercises that follow. If possible, run these statements in an actual DBMS, as appropriate, to obtain results. Name your database ART_COURSE_ DATABASE. For each SQL statement you write, show the results based on these data. Use data types consistent with the DBMS you are using. If you are not using an actual DBMS, consistently represent data types using either the MySQL, Microsoft SQL Server, or Oracle Database data types shown in Figure 3-5.

3.49: Write and run the SQL statements necessary to create the tables and their referential integrity Constraints

3.50Populate the tables with the data in Figure 1-12.

3.51Write and run an SQL query to list all occurrences of Adv Pastels in the COURSE table. Include all associated data for each occurrence of the class.

3.52Write and run an SQL query to list all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerLastName, CustomerFirstName, Phone, CourseNumber, and AmountPaid.

3.53Write and run an SQL query to list all students registered in Adv Pastels starting on October 1, 2023. Include, in this order, Course, CourseDate, Fee, CustomerLastName, CustomerFirstName, and Phone.