I am a college student who DESPERATELY needs help on an assignment, i need it done as soon as possible. Please include the very soonest you could complete the program. The course is a database programming class using java, jdbc, and SQL. The Project is to create a Student Registration database system. There should be some sort of intro screen where you can sign on as a student or faculty. Then there is a log in screen where
they type in their id and password. Then on the Student screen should be the options to modify their address, modify their password, add classes for next semester(subject to prerequisites **they must earn at least a C in the prerequisite course** for the course and seats left in the class), drop classes for next semester or the current semester, display their schedule for current semester or next semester **the current semester will be Fall 2004 and next semester will be Spring 2005**, display their transcript(academic record), and find open sections of classes for the current or next semester. On the Faculty screen should be the options to modify their address, modify their password, add a new section of a class for next semester(there must be a room available), drop a section of a class for next semester, assign a grade to a student in a class, find rooms with a particular seating capacity at a particular time that are available for the current semester, add a new course, add a new prerequisite( the prerequisite is effective in the next semester.
There should mostly be prepared sql statements that use specific information that the user types in.
Another integrity constraintis the student cannot be registered for more than 20 credits in a given semester
When a student registers for a class they enter the course number of the course they want to add. When they
drop a class they enter the course number of the course they want to drop. The transcript should include the
student name and id number, list of course completed with grade and instructor and grouped by semester.
When a teacher assigns a grade they enter student id number, course number, semester, and grade.