Relational Database Schema 1.0

Hi there! I’ve gotten to the point where I’ve created a tentative schema for the HIRED database.

Database schema - constructive criticism welcome!
Database schema – constructive criticism welcome!

I faced a number of challenges when constructing this web of tables. How do we treat students who are jointly advised by two professors? What about professors with appointments in multiple departments or who have been poached? How can we account for similar departments with different names at each institution? I expect that the format of the database will change, but hopefully this is a good enough starting point for now. Please take a look – feedback is much appreciated!

My next steps will be to manually enter some data from a few young research groups, and practice joining these tables into meaningful queries to see what sort of interesting patterns we might find. If you have a research group suggestion, please add it in the “Contribute” tab! To start off, I’d like to stick with professors relatively early in their careers (5-10 years).

Thanks for reading, and I look forward to hearing from you!

Leave a Reply

Your email address will not be published. Required fields are marked *