Database Design and the Hellenistic Greek Lexicon

Over the last few days I have had some interesting conversations with people who design databases (including my eldest son) regarding what would be involved in designing a database to allow lexical information for Ancient Greek to be presented in an extremely flexible manner so that the user of the lexicon could use any form of a given Greek word as the lemma under which to organize the lexicon.

If you are familiar with database design, I would love to hear your comments on this issue. If you are not, I’d be glad to address any questions I’m competent to answer.

How do you think the database should be structured to support the kind of lexicon I have proposed?