top of page
`Zip File includes Netbeans Java Solution of Given Project1- Problem: Consider the following entities describing Texas A&M University-Kingsville alongwith their major characteristics.• The university is organized into departments. Each department is identified by a uniquename (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 acourse-id, title, dept_name, and credits, and may also have associated prerequisites.• Instructors are identified by their unique ID. Each instructor has name, associateddepartment (dept_name), and salary.• Students are identified by their unique ID. Each student has a name, an associated majordepartment (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 identifiedby 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, thesections 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 alongwith its main attributes. Also, a diagram showing the relationships among them is given below.All entitiesClassroom (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)2Student (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)Diagram1. 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 programminglanguage, to answer the following questions by the user:- Find the titles of courses in the Electrical Engineering and Computer ScienceDepartment 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, theinstructor’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 withthe same salary).3- Find the enrollment of each section that was offered in a certain semester (forinstance, 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 (forinstance, Fall 2019).- Increase the salary of each instructor in a certain department (for instance, ElectricalEngineering and Computer Science Department) by 10%.- Delete all courses that have never been offered. In other words, they do not occur inthe Section class.- Insert every student whose tot_cred attribute is greater than a certain number (forinstance, 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 ina report explaining all the object-oriented design decisions. Also, your object-oriented codeshould be commented appropriately for readability and understanding. More precisely, a reportshould include the problem statement, proposed approach/solution along with a detaileddiscussion, algorithms programs, diagrams, tests, and lessons learned from such an objectorienteddesign and implementation of Texas A&M University-Kingsville database.Grading Scheme1. Texas A&M University-Kingsville design 50%2. Texas A&M University-Kingsville implementation 25%3. Report 25%Good Luck!`

# CSEN 5303 Object-Oriented Design and Programming Project

\$80.00 Regular Price
\$76.00Sale Price
• Project: Problem Analysis and Object-Oriented Design and Implementation
Due Date: Nov. 25, 2019
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)