Case: University Classes

This scenario models the courses, students, professors, departments, and the like at a single university in a single semester. Each student enrolls in a certain number of courses in the semester. At most one professor teaches each course. Each student receives a grade in each course he/she is enrolled in. In turn, each student evaluates the professor teaching the course. Each student has a name, a SID, and an address. A professor has a PID, a name and belongs to a department. The age of a professor can be one of young, going strong, old, very old, and still alive. Each course has a name, a number, an offering department, a classroom, a maximum enrollment, and an actual enrollment. The actual enrollment must be at most the maximum enrollment. (This university has not invented the concept of CRNs.) A student can TA a course but not a course he/she is enrolled in. Each department has a unique name. Each department has at most one chairperson who is its head (there are times when a department may not have a chairperson). Each chairperson can be the head of at most one department. Professors advise students on what courses to enroll in. Each student can have at most one advisor and must have at least one advisor. A course can have multiple pre-requisites. A course can be a pre-requisites for multiple courses. A course cannot be a pre-requisite for itself! A student enrolled in a course must have enrolled in all its pre-requisites.

At this university, more than one professor can teach a course. Students continue to get a single grade for each course. However, each student must provide an evaluation to each professor teaching a course the student is enrolled in.

6 |Assignment1 Dr. Razi CIS 6300 - Fall 2019

University Employees

All employees have a unique ID. In addition to professors, universities also employ staff. The university pays all its employees a salary. Professors join as one of the three appointee types: 9-month appointees, calendar year appointees, or research professor appointees. Each 9-month appointee and research professor has a grant that pays part of the employee's salary. Calendar year and 9-month professors teach classes while research professors do not.

University Students

Students enrolled in a university can be either undergraduates or graduates. Graduate students can be enrolled either in a Master's program or a Ph.D. program. Each graduate student must submit a thesis. The thesis can be uniquely identified by its Thesis ID, Each thesis must also have a title. Each student can be a TA for at most one course. Furthermore, a course can have at most one graduate student as a TA (it may have multiple undergraduate TAs).

How many entities are there in this case