ocess, ensuring that this documentation clearly shows the output of eachstage, any tools you have used as part of the process and the thinkingprocesses you used to obtain this output. During this process your group willuse Internet search for solutions (applications) that could be applicable tosolve the problem described in the scenario. Some initial links to suchapplications are provided in the Appendix - the last page of this document.Cover page: The documentation should contain a cover page with theuniversity name, school name, course code, course name, assignment title,the group number (given by your teaching assistant), and the names, andstudent IDs for each student from the group. The cover page shouldalso contain the URL (link) to your presentation video. The cover pageshould also contain Document information including version number,purpose and date.Document Headings: Following the cover page your documentation shouldcontain the following headings: Problem Definition, Problem Analysis,Generating Possible Solutions, Analyzing the Solutions, Selecting the BestSolution, Reflection

Object Oriented Programming - JavaDiv I – Batch 2“Teacher Assessment - College”Note : Marks : 251. Announcement Date: 30-11-2023.2. Due date: 06-12-2023 till 08:00 pm.3. The assignment to be done “individually” or with group of “three students” maximum.4. Assignment must be implemented in “Java” only.5. Assume data types and data, wherever it is required.6. Though viva will be at different times for different students, the submission deadline is same forall.7. No Copying / sharing of code are allowed for this assignment. If any such case identified, theoriginal author and person who has copied both will be “penalized” equally and “zero marks”will be awarded.8. Dates for assignment viva will be announced later.Task :A. Develop a JDBC project for relation “College”. Use PostgreSQL as database.B. Write a “POJO class College” for private attributes given in following table with mentioned “keyconstraints”. Constructor, getters, setters and toString method must be there.C. Create a controller class for following methods. Use SQL query only to perform operations in allmethods. Create relation using SQL query only. Enrollment number must be auto generated seriallyfor all students.1. Create student (student name, division, gender, marks).2. Print student (enrollment no). {Print specific student data.}3. Calculate grade (student name). {Marks = 75 to 100 Grade A, Marks = 60 to 74 Grade B, Marks= 40 to 59 Grade C, Marks = 0 to 39 Grade D}4. Find students by gender (gender). {Print specific data.}5. Add Bonus marks (enrollment no, bonus marks). {Add bonus marks in original marks.}6. Change division (student name). {Change division and print.}7. Print students in range (min marks, max marks). {Print selected data.}D. Create a service class for calling all above methods in “menu driven” pattern.Relation :- CollegeEnrollmentNumber (PK)Student Name(NN) Division (NN) Gender (NN) Marks (NN)… ……Mr. Akhilesh LungeFaculty

Question No. 1Marks : 1.00    Educational or learning group           Informational sharing group           Problem- solving group            Focus group

Build a project called students’ management system which beable to do the tasks below:1. Add students’ information to the Dictionary2. Show all students in the Dictionary3. Search students by stu_id4. Update students’ information5. Delete any students from the DictionaryNote: students have ID, Name, Sex, DOB, Add, ResultDeadline: one week!

t a university, 3 courses are offered: "Programming", "Databases" and "Software Engineering".Each course is offered by a lecturer.Create for each course an instance of type COURSE (=class) using a constructor (parameters: name of the course and the lecturer).The lecturer is stored in a data member of type LECTURER (=class). The class LECTURER should have at least the data member academic_title.The courses have a maximum of 10 and a minimum of 3 course participants.The courses can be attended not only by our own students, but also by students from other universities.The class STUDENT should have at least the following data members: Matriculation numberUniversityStudents from their own university may take any course.Students from other universities may only take one course.The classes LECTURER and STUDENT should derive from the class PERSON.The class PERSON should have at least the following data members:SurnameFirst nameEmailTask: Create a program with a menu that covers the following situation:1. Registration for a course (including querying student data). Each student has a unique email, meaning there can't be two or more students with the same email in the same course.2. Output of one/all courses with data of the participants.    Please note that if there are fewer than 3 participants in a course, an additional message must be displayed - "Course will not take place".3. Output of all courses that are not fully booked yet. The output must include the number of free places, the name of the course and the academic name of the lecturer with its academic title.4. End of program: A message will be displayed stating which participants (=all data members of the class PERSON) have to be notified because your course is not taking place.If necessary (creation, search, and so on), corresponding messages are to be displayed.Permanent storage of the data is not required. The data must only be available at the runtime of the program.Use comments in the source code to document your program.

Student class is defined with public variables name, age, group and reportDefine setDetails() method that sets the student name, age, group and report values.Define getDetails(self) method that prints all the details of the student.Create an instance of class StudentSet the name, age, group and report values of the student by taking the input from the student and call the setDetails() valuesNow print the details of Student by calling the method showDetails()Sample Test Cases