الخطوط العريضة للقسم

  • The objective of this directed work is to help students understand and apply the principles of database normalization, including First Normal Form (1NF), Second Normal Form (2NF), Third Normal Form (3NF), and Boyce-Codd Normal Form (BCNF). Students will learn how to identify functional dependencies and candidate keys, eliminate redundancy and anomalies, and decompose relations into well-structured forms. Through practical exercises, they will be able to transform complex database schemas into normalized forms by removing repeating groups, partial dependencies, and transitive dependencies, while ensuring data consistency and integrity.