School Database - JAVA (Using NetBeans or similar program)

The objective of this work is to develop a application that allows to manage the grades of several subjects in each course (Course -> subject -> grade) . Each course is composed of several subjects. Each subject has a group of editions, one for each year. Each edition has a group of students subscribed to it. Each student can be in several editions from diferente subjects, but can only be in one course. Each subject is linked to one specific course.

Each course has a unique code and a name. Each subject also has a unique code and a name. Each edition has the year of the edition (wich is unique). Each student has a unique code, a name, the age and a course.

The evaluation of each subject can be diferente. For exemple a subject always have a theoric evaluation componente but can or cannot have a practical evaluation.If the subject has no pratical evaluation then the grade is given solely on base of the theoric grade. Otherwise the  pratical evaluation it has a weight of 30% to 70% of the final grade (also having several componentes to it – Reading, writing and others) and the final grade for it is the average of all the componentes. Every grade goes from 0% to 100%.

There are situations where the students want to improve their grade of a certain subject after the semester is over. There are allowed 3 improvements per student and per course. In this situation the student only has to do the theoric evaluation and the old grade will be replaced by the grade of the theoric evaluation. The final grade is only refreshed if the final grade is better than the old one.

The application should allow to:

è  Create a new course:

è  Create a new subject without a pratical evaluation

è  Create a new subject with a pratical evaluation

è  Create a new edition of a subject

è  Create a new student. The student number is randomally generated

è  Insert a student into a course

è  Insert a student into a edition beloging a certain subject

è  Insert a student to be able to do a improvement on a grade

è  Give a theoric evaluation to a student

è  Give a pratical evaluation to a student

è  List all subjects from a certain course. For each subject it’s shown the unique code and the name

è  List all students that are in a edition from a subject. For each student it’s shown the its number, name and age

è  List all students that used to be in a edition from a subject. For each student it’s shown the number, name and if the student passed or not

è  List all students that passed a certain edition from a subject. For each student it’s show the number, name and the final grade

è  List all editions of a subject. For each edition its shown the year, the number of students that were on that edition and the students that were on another edition (another year) that passed but are improving their grade on the next year (edition)

è  Order the students from a certain subject by their grades, showing their grade and year of the edition

è  Exit the application

è  It should be possible to insert the information (courses, subjects, students…) in two ways: trought the keyboard or trough a text file. In the second case, you should create a file with the data from the school that will be delivered next to the work.

You have to have attention to each situation and task, and wich problema might occur and in what situations, creating a exception or/and displaying a texto message for each.

The code must be all commented, and the most important parts explained. It should be coded using NetBeans or a similar program