151 reputation
18
bio website ScoreDonkey.com
location London, United Kingdom
age 33
visits member for 1 year
seen Dec 20 '13 at 10:43

Web Application Developer MCPD 4.0 in Web Development

T: @ChrisDev80


Sep
5
comment A network-related or instance-specific error occurred
This may help: stackoverflow.com/questions/6987709/…
May
21
awarded  Caucus
May
21
awarded  Constituent
Apr
16
awarded  Editor
Apr
16
revised Database design: Dividing multiple identical tables, good or bad?
added 7 characters in body
Apr
16
comment Database design: Dividing multiple identical tables, good or bad?
This is where the ref integrity of the second table would come into play though, the data entry people would not be ble to enter a value unless it existed in the areas table? I'm just interested in your perspective, since you definitely have more DB experience than I do :)
Apr
15
comment Database design: Dividing multiple identical tables, good or bad?
@Mike Sherrill 'Catcall', out of interest, with this design, if an additional area was added 'E', they would need to midify the seats table to accommodate? So, this soution is best if we know for certain the area would not change, but 2 tables if the areas need to be flexible?
Apr
14
awarded  Supporter
Apr
14
comment Database design: Dividing multiple identical tables, good or bad?
Very nice answer :)
Apr
14
awarded  Analytical
Apr
14
awarded  Autobiographer
Apr
14
awarded  Custodian
Apr
14
awarded  Teacher
Apr
14
reviewed No Action Needed Is there a tool to check if my database is normalized to the third normal form?
Apr
14
reviewed No Action Needed Can a production Oracle DB server also have a dataguard active standby for a different production database?
Apr
14
answered Database design: Dividing multiple identical tables, good or bad?