shanemay
asked on
Database Schema
I am developing a database to manage faculty and staff. However, I am having some trouble. Below is a sample schema that I am working on. Any feedback would be greatly appreciated. My concern is that I have an employee table and I have a faculty table, should the two tables be merged even if everyone that is a staff member is not a faculty member.
Thank you.
schema.jpg
Thank you.
schema.jpg
The faculty table seems redundant: wouldn't that "role" table indicate faculty vs other staff types?
ASKER
Right it would indicate the role, however, if they are also faculty member then additional information needs to be gathered (office hours, title, etc...). Information that other staff members will not have or need.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the feedback.