Normalization refers to transformations which aim to reduce variation of various types of data and thereby allow more consistent processing, searching, sorting, comparison, etc. Courtesy of [SO Normalization tag](http://stackoverflow.com/tags/normalization/info).

learn more… | top users | synonyms

2
votes
4answers
154 views

Normalising a database table with 30+ columns [closed]

I'm in the process of restructuring a database I designed about 2 years ago for an organisation. Now most of these tables have a reasonable amount of columns, however there are a few tables which are ...
2
votes
1answer
35 views

Time attendance module design

I am working on time attendance module and I managed to read the data from the timing machine in the following format: Id CheckIn Type Status 0000142 5/15/2015 6:00 PM 2 OK ...
2
votes
2answers
120 views

Is normalization all that's needed to ensure data integrity and quality reporting?

I've gotten out into the real world recently, and for the first time have had to really think about database design, as I've been developing across the entire Java stack. With that I've realized that ...
7
votes
3answers
177 views

Database Normalization vs dependencies

I am developing 3-4 interdependent programs. Call them foo bar baz and auth. I want them to be independent of each other. Imagine if I were to license out each program to other companies. Some ...
0
votes
0answers
48 views

MySQL Database normalization for a user model

I currently have a MySQL Relational Database with a users table with the following attributes: ID (Primary key) Name Username (Unique) Password Email (Unique) Description Profile Picture File Path ...
1
vote
1answer
88 views

What happens to database design process when ORM tools are used?

I have learned about database design, including normalization during my undergraduate course. When we have to model a database for a system, we can start with an ER model and then convert it to the ...
0
votes
1answer
78 views

Tags DB structure - tags table using one join and GROUP BY, or pivot (join) table using two joins?

I'm implementing tags into my question and answer application. Users will be limited to the tags available by the app, so they can't choose their own. So maybe only 30-50 tags will be available. This ...
2
votes
1answer
141 views

Normalization 3NF and BCNF

If I have the following relation R = (A, B, C, D) And the functional dependencies: A -> B, B -> A, CDB -> A, CDA -> B The candidate keys are CDA and CDB. The third normal form says that ...
5
votes
2answers
273 views

Database Normalisation - stuck with “categories”

Context: I'm working on a database of museums and Categories will be one way the user will be able to search. e.g click on "Music" and a list of music related museums turn up. Pretty simple. ...
3
votes
4answers
765 views

Is this database design sound and fully normalised?

I'm creating a database to store words. The intended usage is to query the database to find a word matching a set of filters. E.g. if I wanted to find a word with < 10 letters, < 3 syllables, ...
1
vote
1answer
47 views

How to represent one special related record

I have two tables, project and photo. photo has ID,projectID,path : each project has multiple photos. Now one of these photos is the one that has to be displayed. The question is how to represent ...
3
votes
2answers
1k views

DDD and the persistence of value objects; must we denormalize?

I've been reading up a lot on Domain-Driven Development, and I came to the question of how to preserve lack of distinct identity with value objects (VOs). While in the DDD world, this is a requirement ...
0
votes
1answer
223 views

How does this normalized example work?

I had the following DB schema: Customer Car Rental ------- ---- ------ Name Name Car_ID ID ID Customer_ID Date This is said to be non normalized ...
7
votes
1answer
399 views

Why normalization improves numerical precision?

I was reading the following article: Polynomial interpolation of GPS satellite coordinates, Milan Horemuz and Johan Vium Andersson 2006 and it states the following: "The estimation procedure of the ...
1
vote
1answer
329 views

Consolidating hotels data from various booking sites with different IDs or reference

In one of my projects, I have data for hotels, and other booking sites are able to book this hotel. For example: Hotel A - Booking (ID = 4002), Expedia (ID = 123), Priceline (ID = 147) The three ...
0
votes
2answers
263 views

Why should a column in a Relational Database have a single purpose?

Consider a table in which a column represents a monetary value in some cases and a link to the value of another record in other cases so that we have the following: TABLE 1 Id Product Composite 1 ...
6
votes
4answers
453 views

Distance calculation and data normalization

I'm designing a system which needs to report basic distance between zip codes. It will use the Google Distance Matrix API but I want to cache the results in the database so that multiple requests for ...
-1
votes
2answers
403 views

How to remove data redundancy in a table? [closed]

F1 F2 F3 C1 C2 C3 ------------------------------------------------ A B C 1 D E F 2 A B C 3 D E F 4 A B C 5 D E F 6 ...
12
votes
6answers
2k 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? ...
0
votes
4answers
456 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, ...
0
votes
1answer
367 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 ...
6
votes
2answers
416 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 ...
1
vote
3answers
230 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 ...
6
votes
12answers
3k 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 ...
7
votes
8answers
949 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 ...