Since most classical music is public domain, the information about the
source music should be separate from the CD track information, since
there can be a many-to-one mapping from the latter to the former (more
than 1 CD can have the same piece of music). Entries for the pieces
should be in a separate table (sorry I don't know the proper DB terms
for these concepts). It would be very convenient to have a common entry
for, say, Beethoven's 9th Symphony, and the entry for each available
recording would link to this entry. This would be more convenient for
people entering discs (except for the first person to enter a given work)
and cut down on discrepencies, typos, etc.
Also nice would be separate keys for conductors, orchestras, and
record companies.
There would be a glitch with CDs that split movements into multiple
tracks or combine multiple movements into one track, but I think this
could be handled.
------------------------------------------------------------------------------
| Kevin Theobald |
| CAPSL -- Computer Architecture and Parallel Systems Laboratory |
| Department of Electrical and Computer Engineering, University of Delaware |
------------------------------------------------------------------------------
| "Microsoft portrays itself as the supreme innovator when just about all |
| the technology that it has was copied off of others' previous work. Think |
| about all the major innovations in CS technology and then count how many |
| of them were developed by Microsoft. I count zero." |
| |
| Kein Mitleid Fuer Microsoft (KMFMS) - http://www.kmfms.com/whatsbad.html |
------------------------------------------------------------------------------