Top "Database-normalization" questions

Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency.

Database normalization for Addresses

I am trying to build a database for a limousine company and I got stuck on how much Normalization should …

database-design street-address database-normalization
Same data from different entities in Database - Best Practice - Phone numbers example

Given a database system which deals with Staff, Customers and Suppliers, all of which have multiple possible phone numbers, how …

database-design database-normalization
Decision between storing lookup table id's or pure data

I find this comes up a lot, and I'm not sure the best way to approach it. The question I …

sql database lookup database-normalization
Data normalization and writing queries

I'm a jr. developer (5 months on the job), and I have a question about data normalization. Now, as I understand …

sql database database-normalization
Decomposition that does not preserve functional dependency

When can a BCNF decomposition not preserve functional dependency... I am trying to figure this out for say R=(V,…

relational-database database-normalization functional-dependencies
Method to find candidate key given FD:s?

I'm practicing taking as input a set of functional dependencies and output candidate key(s). Is there an algorithm and …

relational-database database-normalization relational-algebra functional-dependencies
How do you determine how far to normalize a database?

When creating a database structure, what are good guidelines to follow or good ways to determine how far a database …

database-design language-agnostic database-normalization
Database schema normalization checker?

I'm interested in learning about tools that operate like this: Given a database schema and some data, suggest whether the …

database database-normalization genexus