| Entity-Value-Pair vs 3rd Normal Form [message #560495] |
Fri, 13 July 2012 13:30  |
 |
Sanju2012
Messages: 2
Registered: July 2012
|
Junior Member |
|
|
Hi All,
I am strugling in designing the database table for online Portal.
Just to simplify, requirements are to store Customer Id, Customer Name, Date of birth, and 60 flags (0 or 1).
Application team is looking for flexibility in adding the flags as they may need to add flags frequently.
One option is one table with 70 flag columns.
Other option is use Key-Value pair.
Also, these flags will be updated for a customer and expected volume in this table is around 3.5 million records.
Can you please advise what is the best way to design the table? Query performance is main consideration as it is online portal.
Thanks for you help!
Sanju
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
