[Solved] CSC22100 Exercise4

1. Consider the Student database and Listing 25.2 in Chapter 25 of the textbook. Your tasks are:
2. Amend the database to include the following Tables:

Students(studentID, firstName, lastName, email, sex)

Courses(courseID, courseTitle, department)

Classes(courseID, studentID, section, year, semester, GPA)

The underlined attributes are the primary keys of theirs corresponding tables. The value of attribute sex may be either F or M. The Only GPAs allowed in the database are A, B, C, D, F, and W.

25. Amend Listing 25.2 to build and test a Java application that connects to the amended database, creates and populates the Students, Courses, and Classes Tables.
26. Amend Listing 25.2 to return and display the number of students enrolled in CSc 22100 in the Spring 2020 semester for each letter grade.
27. Utilize the Java class PieChart in Exercise 3 to build and display a pie chart showing the proportion of students for each GPA. In the pie chart:

1. Each segment has a different color;
2. Each segment has a legend showing the corresponding GPA and number of students;

• The segments for the GPAs are displayed in alphabetical order.

2. Your report should include the full Java code including all DDL and SQL statements used. In addition, the report should have all DDL and SQL scripts used in a separate section with appropriate heading.
3. The report should show the output tables of the given query and corresponding pie chart for a sufficient amount of input data.
4. Your application should utilize JavaFX graphics and PreparedStatement objects for the execution of SQL statements/queries.
5. You may use any Relational Database Management System (RDBMS) of your choice.