Which approach is better?
Posted by: weitat chok
Date: November 07, 2006 02:55AM

hi, i hv a situation, a table called campaigns, and each campaign may hv diff setting, or with default setting
let say, i hv 5 setting, s1, s2, s3, s4, s5, where s1 to s5 mayb string or any possible integer

Note: not every camp need those setting, some may hv s1...s5 to NULL

there should be two approach for the table

Case 1:
table A
camp_id, camp_name, s1, s2, s3, s4, s5

Case 2:
table A
camp_id, camp_name

table s1
id, camp_id, s1
table s2
id, camp_id, s2
table s3
id, camp_id, s3
table s4
id, camp_id, s4
table s5
id, camp_id, s5

then come back, i wonder which one should be best approach.
Coz once the sys running, i mayb come accross a case to check whether camp_id=5 hv setting s3 or not, to continue the script operation

Can some one tell me which would be system and programming viser?

Options: ReplyQuote


Subject
Written By
Posted
Which approach is better?
November 07, 2006 02:55AM
November 08, 2006 06:19PM
November 09, 2006 08:59PM
November 09, 2006 09:17PM
November 09, 2006 10:52PM
November 16, 2006 09:34PM
November 16, 2006 09:51PM
November 16, 2006 10:14PM
November 17, 2006 12:18AM
November 19, 2006 09:33PM


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.