The university has approached you about building a database forthe university. The database consists of three types of UnivesityAffiliates (represented as Abstract classes) – Faculty, Students,and Staff. They have the following attributes:
Affiliates: name, age, address, phone number, year came toUniversity
Faculty: faculty id, department, yearly salary, number ofpapers
Students: student id, major, minor, class standing
Staff: staff id, title, building
There are 3 types of faculty members: Assistant Professors,Associate Professors, and Full Professors. They have the followingattributes:
Assistant: years until tenure.
Associate: years since tenure.
Full: years until retirement.
There are 2 types of students: Graduate and Undergraduate
Graduate: numbers of papers published, thesis advisor.
Undergrad: number of courses taken,