MySQL Forums
Forum List  »  Newbie

Re: Table design questions?
Posted by: AtinLango
Date: March 23, 2006 05:48AM

There are many issues involved here. I will highlight only one without touching NORMALIZATION, etc.

In option 1, for every new record that you add, you have the NULL hence wasted space. Imagine if you have several thousands of records.

For option 2, although initially you are creating many tables, in the long run you are not wasting space (in NULLs) because every new record just fits. Infact in option2, i would have 4 tables (persons, books, songs and movies). The last three would be related to persons table.

Options: ReplyQuote

Written By
March 22, 2006 05:55PM
Re: Table design questions?
March 23, 2006 05:48AM

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.