====== Entity Relationship Diagram ======
{{projects:faculty:erdiagram0.3.png}}

====== Entity and Relationship Definitions ======

===== Entities =====
  - **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.

===== Relationships =====
  - **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.