The normalization tag has no wiki summary.
12
votes
6answers
1k views
Do You Still Need Indexing After Database Normalization
After you have done a good normalization, do you still need to index the table? How is this going to affect the performance? Will it even affect the performance in some way after a good normalization? ...
7
votes
9answers
702 views
When did developers start making normalized relational databases?
I work on a pretty old application which was converted from DOS and flat files for storing information to Paradox tables using the BDE then to MySQL relational database.
The older devs say that the ...
6
votes
2answers
284 views
What does this point about first normal form mean?
I'm reading the Wikipedia page on first normal form, and am confused about the last bullet point:
5) All columns are regular [i.e. rows have no hidden components such as row IDs, object IDs, or ...
5
votes
11answers
1k views
Over normalization in database
Currently I am working on creating a new database schema as part of a major new product. Our previous customer address records (in a previous product) look something like this in our current schema ...
1
vote
4answers
255 views
Is data integrity possible without normalization?
I am working on an application that requires the storage of location information such as city, state, zip code, latitude, and longitude. I would like to ensure:
Location data is accurate
Detroit, ...
1
vote
3answers
191 views
Should I structure my DBs based on the data's true form, or how I plan to use that data?
This is mostly a hypothetical question, but it's something I've been tossing around and I wondered what other people though. Here's a contrived example to illustrate: Let's say I'm building an app ...
0
votes
1answer
141 views
RDBMS same type of optional data for multiple tables
I have an embedded database (SQLite), it stores information about events and page views, its purpose is to track the user journey inside my application. I need to provide support for optional custom ...
