Best Practices: multiple location tables?
My organization (a university), has previously tried to enforce using a single location table, under the presumption that simpler/a single source of truth is better. This has resulted in our location table essentially being a record of room numbers, ...
