Re: Table structure for multiple names
Depends on how commonly "artists" have multiple names &c. The one-child-table solution will be an EAV variant, OK if queries ont it are neither frequent nor complex, a nightmare otherwise.
year_died,month_died, day-died should be just date_of_death date, ditto for DOB.
I do not understand how a `sorting` column would be useful.
Subject
Written By
Posted
Re: Table structure for multiple names
April 09, 2013 04:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.