24.10.2018, 08:55
https://en.wikipedia.org/wiki/Database_normalization
Every schema can be expressed in the third normal form. Such a schema will be a well-designed schema most of the times. An easy way to start would be to merge all the relations into one and write down the functional dependencies on paper and then slowly split them into separate relations to satisfy 2NF and then 3NF.
Every schema can be expressed in the third normal form. Such a schema will be a well-designed schema most of the times. An easy way to start would be to merge all the relations into one and write down the functional dependencies on paper and then slowly split them into separate relations to satisfy 2NF and then 3NF.