I have 2 tables I plan on creating, Employee and Student. Employee and Student tables have some common fields and also some different ones. Is it a good idea to put those same fields in a common table like Person and then relate them?
For example, both Employee and Student have FirstName and LastName fields.