Knowee
Questions
Features
Study Tools

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

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

...expand
🧐 Not the exact question you are looking for?Go ask a question

Solution

Sure, I will answer the question step by step.

Step 1: Read the given task and understand the requirements.

Step 2: Develop a JDBC project for the "College" relation using PostgreSQL as the database. This project will involve creating tables, inserting data, and performing various operations on the data.

Step 3: Write a "POJO class College" with private attributes mentioned in the given table. The key constraints should be implemented. The class should have a constructor, getters, setters, and a toString method.

Step 4: Create a controller class that will contain methods to perform various operations on the College data. These methods should use SQL queries to interact with the database. The methods should include:

  1. Create student: This method will take student name, division, gender, and marks as input and insert a new student record into the database. The enrollment number should be auto-generated serially for all students.

  2. Print student: This method will take the enrollment number as input and print the specific student's data.

  3. Calculate grade: This method will take the student name as input and calculate the grade based on the marks. The grade will be determined as follows: 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: This method will take the gender as input and print the specific data of students with that gender.

  5. Add Bonus marks: This method will take the enrollment number and bonus marks as input and add the bonus marks to the original marks of the student.

  6. Change division: This method will take the student name as input and change the division of the student. It will then print the updated data.

  7. Print students in range: This method will take the minimum marks and maximum marks as input and print the data of students whose marks fall within that range.

Step 5: Create a service class that will call all the above methods in a "menu-driven" pattern. This class will provide a user interface to interact with the College data and perform operations based on user input.

Step 6: Implement the necessary SQL queries to create the College relation and perform operations on the data.

Step 7: Test the project by running the service class and verifying that all the operations are working correctly.

That's it! By following these steps, you will be able to complete the given task of developing a JDBC project for the College relation using Java and PostgreSQL.

This problem has been solved

Similar Questions

You have been assigned to develop a Course Enrollment and Grade Management System in Java for a university. The system should provide functionality to enroll students in courses, assign grades to students, and calculate overall course grades for each student. The project should demonstrate the effective utilization of static methods and variables to keep track of enrollment and grade-related information across multiple instances of the Student and Course classes. It should also showcase your ability to manipulate object state and define behavior through instance methods.Requirements:Student Class:The Student class should have private instance variables to store student information such as name, ID, and enrolled courses.Implement appropriate access modifiers and provide public getter and setter methods for accessing and updating student information.Design a method to enroll students in courses. It should accept a Course object as a parameter and add the course to the student's enrolled courses.Implement a method to assign grades to students. It should accept a Course object and a grade for the student and update the student's grade for that course. Course Class:The Course class should have private instance variables to store course information such as course code, name, and maximum capacity.Use appropriate access modifiers and provide public getter methods for accessing course information.Implement a static variable to keep track of the total number of enrolled students across all instances of the Course class.Design a static method to retrieve the total number of enrolled students.CourseManagement Class:The CourseManagement class should have private static variables to store a list of courses and the overall course grades for each student.Use appropriate access modifiers to control access to the variables.Implement static methods to add new courses, enroll students, assign grades, and calculate overall course grades for each student.The addCourse method should accept parameters for course information and create a new Course object. It should add the course to the list of courses.The enrollStudent method should accept a Student object and a Course object. It should enroll the student in the course by calling the appropriate method in the Student class.The assignGrade method should accept a Student object, a Course object, and a grade. It should assign the grade to the student for that course by calling the appropriate method in the Student class.The calculateOverallGrade method should accept a Student object and calculate the overall course grade for that student based on the grades assigned to them.Administrator Interface:Develop an interactive command-line interface for administrators to interact with the Course Enrollment and Grade Management System.Display a menu with options to add a new course, enroll students, assign grades, and calculate overall course grades.Prompt the administrator for necessary inputs and call the appropriate methods in the CourseManagement and Student classes to perform the requested operations.Implement error handling to handle cases where invalid inputs are provided or when enrolling students in courses that have reached their maximum capacity.Documentation:Provide comprehensive documentation for the project, explaining the purpose and usage of each class, method, and variable.Describe how static methods and variables are utilized to track enrollment and grade-related information across multiple instances of the Student and Course classes.Include instructions for running the program and interacting with the administrator interface.

CS304 – Object Oriented Programming Assignment No.1 (Graded) Maximum Marks: 20 Instructions Due Date: 29 April 2024 The purpose of this assignment is to give you hands-on practice. It is expected that students will solve the assignment themselves. The following rules will apply during the evaluation of the assignment. ● Cheating from any source will result in zero marks in the assignment. ● The submitted assignment does NOT open or the file is corrupted. ● No assignment after the due date will be accepted. ● Students can submit HTML, Images & Plain text only in this inline Mode. You may also insert an image file/table. ● DOC/pdf File uploading option will not be available) in inline assignment submission. Uploading Assignment Instruction Follow the given instructions to submit an inline assignment. ● You can use MS Visio/ MS Paint for drawing the Class Diagram etc. ● Students can insert the images in the following formats. ● Images and tables can be inserted using the following highlighted option in the interface. Objective & Learning Outcome Objectives: The objectives of this assignment are to: • Identify the main objects (entities). • Find the necessary attributes and functions associated with each object. • Identify the relationships among objects. • Construct a comprehensive class diagram. Learning Outcomes: After completing this assignment, students will be able to: • Develop a UML class diagram. Question (20 Marks ) Scenario: A freelance marketplace is an online platform that connects freelancers with clients who need specific projects/jobs completed. These platforms serve as intermediaries that help both parties find each other, and ensure the secure exchange of services and payments. On the freelance marketplace, there can be two types of users: one is a client who posts the jobs or projects, and the other is a freelancer who bids to complete those projects. After winning the project, freelancers complete the project and submit it. After evaluating the project, the client approves the project, and then payment is released to the freelancer. Based on the above scenario there are the following key features of a freelancing platform: 1. Freelancers create profiles that include their skills, experience, and portfolio of work. 2. Clients post projects or job descriptions, mentioning the skills required, project timelines and budget etc. Freelancers can then decide if they wish to apply or bid for the project. 3. A freelancer can bid on the project. Clients then review these bids and select a freelancer based on factors such as price, experience, and previous reviews etc. 4. Payment may be released to the freelancer only after the client approves the

Develop a Student Record Management System in Java for a university. The system should enable administrators to effectively manage student records, including adding new students, updating student information, and viewing student details.Requirements:Student Class:Create a Student class with private instance variables for storing student information such as name, ID, age, and grade.Student Management Class:Create a StudentManagement class with private static variables to store a list of students and the total number of students.Administrator Interface:Display a menu with options to add a new student, update student information, and view student details.Prompt the administrator for necessary inputs and perform the requested operations using the StudentManagement class.Error Handling:Implement error handling to handle cases where the student ID is not found or invalid inputs are provided.Documentation:Provide comprehensive documentationInclude instructions for running the program and interacting with the administrator interface.Remember to use appropriate variable names and follow coding best practices.

Develop a java application to implement the following:Create a class named " MarkSheet" and declare two variables Name ,CGPA. And also Define two methods Readdata(), Displaydata().Your program shoud read data for three students and display the values using array of objects. Sample outputNithin9.6Amrith8.9Sonu

using the while loop, and scenner draft a java code that grades students when they enter makes it grades it with A,B+,B,C,C+ and F grades

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.