Quote:
Originally Posted by unboggling
Even if there were a way to enter author-level data just once per author rather than on each of that author's books, I would still want to see at least some of that data at book level.
So the issue is: is there enough need for seeing data at author-level, not book level? To me, without giving it a whole lot of thought, it doesn't seem worth it to have to switch between tables of book level and author level. I'd rather have it all at book level. Storage space is cheap enough that data redundancy isn't a big problem.
|
It is not redundant data. It is the maintenance of the data.
Authors: Andre Norton
Pseudonym: Andrew North
If it was linked at the authors level, I would only have 1 Author (type pseudonym): Andrew North which would be cross linked to the '(Real) Author' : Andre Norton
Show 'All' books by Andre Norton would include all her pseudonyms: (Alice Mary Norton, Andre Norton, Andrew North and Allen Weston)
Show 'only' would work as it now does: Andre Norton
Doing (and maintaining) this axillary info at the title level is awkward.