Faculty
PK Faculty_Id : int
FK (FacultyType PK) : string
FK (People PK) : string
FacultyType
PK name : string
Office
FK (Faculty PK) : int
FK (Locations PK) : string
Locations
PK -> room + (Buildings PK)
room : string
FK (Buildings PK) : string
FacultyCourses
FK (Faculty PK) : int
FK (Courses PK) : int
Courses
PK Course_Id : int
name : string
unique : int
number : string
FK (Semesters PK) : int
Semesters
PK -> year + FK
year : int
FK (Seasons PK) : string
Seasons (enumerated list)
PK Season : string
Buildings
PK abbreviation : string
name : string
address : string
Faculty Award
date : date
FK (Faculty PK) : int
FK (Awards PK) : string
Awards
PK -> name + FK
name : string
FK (AwardTypes PK) : string
AwardTypes
PK name : string
FacultyResearch
FK (Faculty PK) : int
FK (ResearchAreas PK) : string
ResearchAreas
PK name : string
Degrees
PK -> date + (Faculty PK)
date : date
FK (Faculty PK) : string
FK (DegreeTypes PK) : string
FK (Fields PK) : string
FK (Institutions PK) : string
Institutions
PK name : string
Field
PK name : string
DegreeTypes (enumerated list)
PK name : string
FacultyJournalEntries
FK (Faculty PK) : string
FK (JournalEntries PK) : string
JournalEntries
PK article_title : string
date : date
FK (Journals PK) : string
Journals
PK name : string
FacultyPublishings
FK (Faculty PK) : string
FK (Publishings PK) : string
Publishings
PK -> book_title + date
book_title : string
date : date
FK (Publishers PK) : string
Publishers
PK name : string
Presentations
PK -> presentation_title + (Faculty PK)
presentation_title : string
date : date
FK (Faculty PK) : string
FK (Conference PK) : string
Conferences
PK -> name + location
name : string
location : string
People
PK username : string
first_name : string
last_name : string
GradStudents
theses : string
date : date
FK (StudentTypes PK) : string
FK (People PK) : string
StudentTypes (enumerated list)
PK name : string
Phones
PK phone_number : string
FK (PhoneTypes PK) : string
FK (People PK) : string
PhoneTypes
PK name : string
Emails
PK email_address : string
FK (People PK) : string
Websites
PK address : string
FK (People PK) : string
OfficeHours
PK OfficeHours_Id : int
start : string
end : string
day : string
FK (Location PK) : string
FK (People PK) : string