Faculty: A Faculty is a person who has occupied affiliations, achieved accomplishments, attained degrees, and has an employment status. Faculty members teach classes, advise graduate students, and serve on committees for the UMBC Graduate School.

Affiliation/Other: An Affiliation is a job or other position held by a Faculty member.

Education: An Education is a degree or course taken and completed by a Faculty member.

Accomplishment: An Accomplishment is an outstanding skill or achievement possessed by a Faculty.

Status_Lookup: A Status Lookup is a listing of possible statuses that a Faculty can hold or be requesting.

Attains: Faculty are able to hold multiple degrees and Educations at the same time, therefore it is a 1 to many (optional) relationship.

Occupies: Faculty each have a different history of Affiliations and occupied positions, with no limit to the number, so the relationship must be 1 to many (optional).

Achieves: Faculty achieve and Accomplish many different things, so the relationship must be 1 to many (optional).

References: Each Current_Status and Requested_Status for a Faculty is a corresponding letter code, and can be referenced to the corresponding Status_Lookup of actual values.