first we discus Guidelines for good relational design and Then we discuss formal concepts of functional dependencies and normal forms
- 1NF (First Normal Form)
- 2NF (Second Normal Form)
- 3NF (Third Normal Form)
In Oracle (and relational databases in general), an insertion anomaly happens when you can't record a specific piece of data because the table's structure requires you to provide other, unrelated data that you don't have yet. This is almost always a symptom of poor database design or a lack of Normalization all of that are discussed in Arabic Language في اللغة العربيه