help with simple db design
Posted by:
H Yowza
Date: April 02, 2006 05:02AM
Currently i am using a single table name called Members. Inside this table i have the fields NAME, EMAIL, HOBBIES. I have the hobbies as follows:
Fishing, Dancing, Skating
I have found it to be really unreliable even after getting around it using a programming approach. You see i have a form where the members register them selves and they select their hobbies. After each selection(hobbie) i add a commer and write it to the database. Now initially i had a web interface this approach worked perfectly. However recently i've been converting my app to mobile based. The mobile based adds a semi colon instead and when it is written in semi colon form after each hobbie retrieival is a problem when retrieving.
My question was what would be a better design rather than having many hobbies as one value so retrieving it won't be an issue?
Subject
Written By
Posted
help with simple db design
April 02, 2006 05:02AM
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.