Forums
May 22Classic WTF: DATABASE ABNORMALIZATION 101
by in Feature Articles on 2022-06-13It's that time of year, we're taking a brief little summer break this week, and thus reaching back into the archives for some classics. Enjoy these, and in the meantime, keep those submissions coming! For today, we have a unique way to keep track of when classes start… Original. --Remy
Working as a DBA in academia, Paul received a notice that a certain newly migrated user schema, specifically the one used by the enrollment tracking system, had swelled to 281 tables and was growing. This had struck Paul as being very strange since the tracking system wasn't all that complicated.
When a student is registering for a class, and want to know if there's room left, they need two pieces of information - the Course ID and the Semester Number.