AccessMyLibrary provides FREE access to over 30 million articles from top publications available through your library.
Create a link to this page
Copy and paste this link tag into your Web page or blog:
Byline: Mark Whitehorn
What not to store
The database solution to a copyright conundrum explained
James Rufton wrote in with an apparently simple question. He is a publisher who acquires song copyrights (sounds like an interesting job). Often he buys the worldwide copyright, but some copyrights are acquired for a specific country or countries. He needs to track, for each song, the countries for which he owns the copyright.
The solution (so far) is easy. We need a table for the songs, another for the countries and a junction table that spells out, for each song, the appropriate countries (see screen 1). From these we can see that we own ...