Needed: A Relational Database for Normal People
Opinion: Is David Coursey's request for a simple database that encompasses many-to-many relationships really that unreasonable?One of my big unanswered software questions is why no one has managed to make relational databases simple enough for normalas opposed to normalizedpeople to use. I cant be the only person on the planet who needs to create a database that encompasses many-to-many relationships, but isnt a professional database designer. Yet, I have not found anything that makes building such an application terribly easy for people like me. For example, when I organize a conference I do a database of the speakers and the sessions. Id like to be able to connect them, showing which speakers are presenting at which sessions. This shouldnt be so hardwhen I tell you what I need you understand it immediately. I need a database that can link speakers to sessions and vice versa, allowing each change in one to show up in the other.
Now this is merely difficult if each speaker is only presenting at a single session. Sadly, thats never the case at my events. Linking speakers to multiple sessions has thus far proven more trouble that its worth.