Zip File includes Netbeans Java Solution of Given Project1- 
Problem: Consider the following entities describing Texas A&M University-Kingsville along
with their major characteristics.
• The university is organized into departments. Each department is identified by a unique
name (dept_name), is located in a particular building, and has a budget.
• Each department has a list of courses it offers. Each course has associated with it a
course-id, title, dept_name, and credits, and may also have associated prerequisites.
• Instructors are identified by their unique ID. Each instructor has name, associated
department (dept_name), and salary.
• Students are identified by their unique ID. Each student has a name, an associated major
department (dept_name), and tot_cred (total credit hours the student earned thus far).
• The university maintains a list of classrooms, specifying the name of the building,
room_number, and room capacity.
• The university maintains a list of all classes (sections) taught. Each section is identified
by a course_id, sec_id, year, and semester, and has associated with it a semester, year,
building, room_number, and time_slot _id (the time slot when the class meets).
• The department has a list of teaching assignments specifying, for each instructor, the
sections the instructor is teaching.
• The university has a list of all student course registrations, specifying, for each student,
the courses and the associated sections that the student has taken (registered for).
Hint: All the entities associated with Texas A&M University-Kingsville are given below along
with its main attributes. Also, a diagram showing the relationships among them is given below.
All entities
Classroom (building, room_number, capacity)
Department (dep_name, building, buget)
Course (course_id, title,dept_name, credits)
Instructor (i_id, iname, dept_name, salary)
Section (course_id, sec_id, semester, year, building, room_number, time_slot_id)
Teaches (i_id, course_id, sec_id, semester, year)
2
Student (s_id, sname, dept_name, tot_cred)
Takes (s_id, course_id, sec_id, semester, year, grade)
Advisor (s_id, i_id)
Time_slot (time_slot_id, day, start_time, end_time)
Prereq (course_id, prereq_id)
Diagram
1. Identify all the classes of Texas A&M University-Kingsville database.
2. Specify each class of Texas A&M University-Kingsville database.
3. Give a diagram of the class structure for Texas A&M University-Kingsville database.
4. Create reasonable instances of the above classes.
5. Design algorithms and write their corresponding programs, in your favorite programming
language, to answer the following questions by the user:
- Find the titles of courses in the Electrical Engineering and Computer Science
Department that have a certain number of credit hours credits (for example, 3, etc.).
- Find the IDs of all students who were taught by a given Instructor. For instance, the
instructor’s name could be Einstein. Make sure there are no duplicates in the result.
- Find the highest salary of any instructor.
- Find all instructors earning the highest salary (Hint: There may be more than one with
the same salary).
3
- Find the enrollment of each section that was offered in a certain semester (for
instance, Fall 2019).
- Find the maximum enrollment, across all sections, in a certain semester (for instance,
Fall 2019).
- Find the sections that had the maximum enrollment in a certain semester (for
instance, Fall 2019).
- Increase the salary of each instructor in a certain department (for instance, Electrical
Engineering and Computer Science Department) by 10%.
- Delete all courses that have never been offered. In other words, they do not occur in
the Section class.
- Insert every student whose tot_cred attribute is greater than a certain number (for
instance, 100) as an instructor in the same department, with a salary of a certain value
(for instance, $25,000).
Deliverables: Students may choose to work in teams of up to three members. You should turn in
a report explaining all the object-oriented design decisions. Also, your object-oriented code
should be commented appropriately for readability and understanding. More precisely, a report
should include the problem statement, proposed approach/solution along with a detailed
discussion, algorithms programs, diagrams, tests, and lessons learned from such an objectoriented
design and implementation of Texas A&M University-Kingsville database.
Grading Scheme
1. Texas A&M University-Kingsville design 50%
2. Texas A&M University-Kingsville implementation 25%
3. Report 25%
Good Luck!