Repeat Exercises 10.7 and 10.9, but use JDBC with Java 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

Transcribed Image Text:

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