Reputation
396
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 5
Newest
 Nice Answer
Impact
~69k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Apr
21
awarded  Nice Answer
Apr
5
awarded  Critic
Apr
5
comment What are changes made to a database schema that is already in 4NF that would break applications?
I'm confused. You are treating normalization like a goal or grade. It is not. It is a measure. A table with one key and one non-key column could have a very high normal form. It's not a contest to "get to xNF". Schemas don't have normalization levels. Relations (tables) do. Since normalization is based on meaning and the key, only relations have normal levels.
Apr
5
comment What are changes made to a database schema that is already in 4NF that would break applications?
I'm guessing this question is a hypothetical or thought experiment, as it doesn't seem to have much of a real world bent to it. I guess it could also be a job interview question to see if people understood normalization or theory. I'm trying to understand the useful, real-life situation where this question has any meaning other than what I have guessed here. So learning is good, but that's not what Stack is supposed to be used for.
Mar
28
comment What problems are solved by splitting street addresses into individual columns?
Just as a snarky comment - tell your modelers they are missing about 35 possible post mail fields. If they are going to do this, they should be doing it right. :)
Mar
28
answered What problems are solved by splitting street addresses into individual columns?
Jul
29
comment Ways to Reduce Database Size and possibly improve performace. Untouched enviroment.
You might want to provide some of the important additional information that you have provided over on Twitter, too. Like the fact that these databases are for customer websites and you likely can't make changes to their data or databases, if that's true.
Mar
13
comment What alternatives exist when a table requires too many foreign keys?
I've done many designs in this area - pricing, product management, product specifications. Even in highly normalized designs, I've never come close to that many FKs on the same table. Are you perhaps doing some sort of data partitioning strategy (by client or time or something like that) that caused you to design in this direction? It's difficult to provide an answer without some more information about your design and design goals.
Feb
20
comment How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
David, I just did a test by modifying the sample macro to add 4 "audit" like columns. It seems to do what you are asking for. And all I have to do is select the entities, then do ALT+S and run the macro.
Feb
20
comment How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
David, I did mean manually creating a template entity, then copying it everytime you want to create a new dimension. I would most likely create a macro for that, though, so that I could use a hotkey to do that instead of copy and paste.
Feb
19
awarded  Editor
Feb
19
revised How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
Added new ideas
Feb
19
awarded  Supporter
Feb
19
answered How do I get ER Studio Data Architect to automatically add SCD Fields to my Dimensions?
Jan
28
awarded  Necromancer
Jan
16
awarded  Yearling
Jan
17
awarded  Necromancer
Jan
16
answered Should I split a single table with an AUTO_INCREMENT PRIMARY KEY into two tables that can be joined on that PRIMARY KEY?
Jan
16
answered Am I violating any NF rule on my database design?
Jan
16
answered How do you document your databases?