[Solved] CSC22100 Assignment 4

5/5 – (2 votes)

Consider the Student database schema below.

Students(empID, firstName, lastName, email, gender) Courses(courseID, courseTitle, department) Classes(courseID, studentID, sectionNo, year, semester, grade)

The underlined attributes are the primary keys of their corresponding tables. The value of attribute gender may only be F, M, or U, respectively for female, male, or unknown. The only letter grades allowed in the database are A, B, C, D, F, and W.

Your tasks are to:

1. Use the data provided in file scheduleSpring2021.txt to populate the Courses andClasses tables. The grades are initially set to NULL.
2. Build and test a Java application that [1] connects to the database, [2] creates, [3] populates, and [4] updates the Students, Courses, and Classes Tables. Explicitly specify all the classes imported and used in your Java application. Your application should utilize PreparedStatement objects for the execution of DDL statements and SQL queries.
3. Utilize the update functionality in the code to update the student grades, as required.
4. Calculate and display the number of students for each letter grade in CSc 22100 [Software Design Laboratory] in the Spring 2021 semester.
5. Utilize the Java classes in Assignment 3 to build and display a pie chart showing the proportion of students for each grade. In the pie chart:

In-person demonstration of your application is required. The demonstration is scheduled on Thursday, 13 May 2021 during regular class time 2:00 3:15 pm.

6. Each segment has a different color;
7. Each segment has a legend showing the corresponding grades and number ofstudents;
8. The segments for the grades are displayed in alphabetical order.
9. The report should show sample input tables and output table for the stated query and corresponding pie chart for a sufficient amount of input data.
10. You may only use JavaFX graphics and your own classes and methods for the operations included. Further,
    1. The code is applicable to canvases of variable height and width;
    2. The size of the pie chart is proportional to the smallest dimension of the canvas;
    3. The segments of the pie chart are filled with different colors of your choice,specified through a MyColor enum reference type.
11. You may use any Relational Database Management System (RDBMS) of yourchoice.