Tables

I have a vague memory from undergrad about a rule that said table names should be pluralized in transactional systems. In a data warehouse, that does not really make sense. Dimensions usually hold records describing singular objects like a person place or thing.

There is a weaker argument to extend this convention to fact tables, however, I do it anyway to satisfy my OCD.

Last updated