mysql - Relating authors real names to pen names in database -

i'm kicking around small database project (sqlite or mysql) learning purposes... figured i'd work on cataloging of many books ;)

thought had of tables , relationships worked out, until started going thru , populating sample data particular book series. 1 of authors writes under pen name in series/genre, under different name genre, , 'actual' name else entirely. add fun reader (me) may not aware authors name on cover is pen name or not.

any ideas or suggestions how deal sort of thing in practice?

tia,

monte

the answers @adam , @mellamokb not take account of other complications:

1. pen names can used authors
2. an author may have zero-many pen names
3. a pen name can belong author
4. a pen name can house (publisher) pen name, used zero-many authors
5. a pen name adopted, when author starts collaborating 1 or more other authors, collaboration.
6. as say, not obvious name pen name, have make assumption name real unless know otherwise.

obviously, dealing these cases worth while if number of books large - before disposed of book collection (approx 15,000) contemplating making shift sort of solution, because of pen names, , because of edited anthologies , article series.

if wish go down route, place start martin fowler's analysis patterns or ieee standards author descriptions own publications.