Tagged Questions
0
votes
2answers
43 views
Column partially determining accepted values of another column, should be somehow normalized?
I have a table that describes a set of properties (yes it's metadata, in this case there's a valid reason to have it in the database); among other things I tell the type of the data that can be ...
7
votes
1answer
452 views
Is DB Normalization done purely based on the primary key or is it done based on all the candidate keys?
I have come across two flavours of the normalization procedure while referring the internet and textbooks. viz.
Type 1. Normal forms based only on the primary key.
In this type,
-> 2NF disallows ...