As a bit of a sidebar, if this is a typical problem being taught nowadays, then it's no wonder the industry is in a world of hurt when it comes to database design and application performance.
--Jeff Moden
Change is inevitable... Change for the better is not.