1. Create a new database user with the following credentials and grant ALL privileges to the Gradebook database.

• Username: gradebook-admin
• Password: Grad3B00k!

2. Create triggers to automatically update theFinal_Grade attribute in ENROLLMENT table based on the Total_Points attribute value and the grade scale (A_Min, B_Min, C_Min, D_Min) for corresponding course. (30 points)

3. Create a Java program that connects to the Gradebook database using the above-created user and perform the following actions based on the input parameter provided when executing the program. (55 points)

Option # 1: View Specific Section's Enrollment and grades

Input Parameter : Section ID (Ex. 2000)

Output: List of students enrolled in specified section and their corresponding grade

Student_Id, Name, Final Grade, Points

Option # 2: View Specific Student's Grades:

Input Parameter : Student ID (Ex. 6083809)

Output: List of sections in which the specified student is enrolled and the corresponding grades

Section,Course_ID,Course_Name,Final Grade, Points

Input parameter should be passed through the main ( args[] ) method.

If the input parameter is not a valid section or a valid student, display message in console " [input parameter] is not a valid section or student"

If an input parameter is not provided, display message " Please provided a valid section or student"

Deliverables:

• SQL Script file with commands to create user and triggers (1 and 2)
• Java Program (Runnable Jar File)

Extra Credit (20 points): Implement an Option # 3 to retrieve the list of sections and corresponding semesters for a specified course:

Input Parameter: Course_ID (Ex. ACG4101)

Output: List of sections associated to the course with corresponding semester and schedule (DaysTime)

Section,Semester,Schedule

Extra credit points count only toward assignments, not quizzes or exams.

Deliverables:

• SQL Script file with commands to create user and triggers (1 and 2)
• Java Program (Runnable Jar File)
• Archive File (Program's Source Code)