Repeat Exercises 10.7 and 10.9, but use SQL/CLI with C as the host language.

Exercise 10.7

Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. Write a program segment to read a student’s name and print his or her grade point average, assuming that A = 4, B = 3, C = 2, and D = 1 points. Use embedded SQL with C as the host language.

Figure 1.2

Figure 2.1

Exercise 10.9

Consider the library relational database schema in Figure 6.6. Write a program segment that retrieves the list of books that became overdue yesterday
and that prints the book title and borrower name for each. Use embedded SQL with C as the host language.

Figure 6.6

STUDENT Name Student_number Class Major COURSE Course_name Course_number Credit_hours Department PREREQUISITE Course_number Prerequisite_number SECTION Section_identifier Course_number Semester Year Instructor GRADE_REPORT Student_number Section_identifier Grade