Update the credit hours and classification

Assignment Help Computer Engineering

Reference no: EM132092902

-Person (Name, ID, Address, DOB

- Instructor (InstructorID, Rank, Salary)

- Student (StudentID, Classification, GPA, MentorID, CreditHours)

-Course (CourseCode, CourseName, PreReq)

-Offering (CourseCode, SectionNo, InstructorID)

- Enrollment (CourseCode, SectionNo, StudentID, Grade)

Write a JDBC program P3.java.

For each student, update the credit hours, classification, and the GPA, taking into account the current GPA and grades in the courses the student is currently enrolled in.

All the courses are 3 credit courses.

The classification should be updated according to the following criteria:

Freshman: 0-29; Sophomore: 30-59; Junior: 60-89; and Senior: 90 and higher.

The grades are usual letter grades and the points assigned to the grade are as follows:

A = 4.00; A- = 3.66; B+ = 3.33; B = 3.00; B- = 2.66; C+ = 2.33; C = 2.00; C- = 1.66; D+ = 1.33; D = 1.00; F = 0.00

As an example, suppose that the current GPA of a student is 3.5, she is a freshman, has taken 27 credit hours, currently she is enrolled in two courses, and has A and B+ in those courses.

Then the new credit hours is 27 + 3 + 3 = 33. Her new classification is Sophomore. The new GPA is ((3.5 * 27) + (3 * 4.00) + (3 * 3.33)) /33 = 3.53.

You should calculate and store GPA as a float. Note that rounding of GPA must be done only for printing.

Reference no: EM132092902

Questions Cloud

Which computer and compiler would you purchase : Which computer and compiler would you purchase if all other criteria were identical, including cost.

Find two ways to change the mac address on your computer : Perform a little research to find two ways to change the MAC address on your computer. Clearly explain why this is valuable knowledge to have.

Create a coin toss simulation program : A no-arg constructor, which randomly determines the side of the coin, that is facing up ("heads" or "tails") and initializes the sideUp field accordingly.

How frequently should the key be changed : What attack is more likely to succeed if a key has been used frequently? How frequently should the key be changed?

Update the credit hours and classification : Update the credit hours, classification, and the GPA, taking into account the current GPA and grades in the courses the student is currently enrolled in.

Insert at least five sample rows of data into the employee : The database should have a table named Employee , with columns for employee ID, name, position, and hourly pay rate.

Describe data structure you will use to store opt value : Describe data structure you will use to store OPT value for the subproblems and the order in which you will fill out the entries in your data structure.

Write an algorithm for the following input two numeric value : If the second is larger than the first, perform a real division. Otherwise, perform an integer division.

How do you call a subroutine called myprogram : Write the code to assign "Dean", "Sam", "Castiel", "Bobby", and "Charlie" to the Perl equivalent of an array.

User Account

All Pages