Database Directed Work
Résumé de section
-
To understand and address the challenges associated with traditional File Management Systems (FMS), and to explore the fundamentals of Databases (DB) and Database Management Systems (DBMS), including their objectives, levels of data description, and core functions.
-
Identify the different types of keys and their uses in a relation.
-
The objective is to explore functional dependencies, Armstrong’s axioms, elementary functional dependencies, transitive closure, attribute closure, keys, covers, and minimal covers.
-
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.
-
This exercise aims to develop students' understanding of relational algebra by practicing the formulation of precise queries over a given relational schema. It reinforces core database concepts such as selection, projection, join, union, and difference, while enhancing logical reasoning and query-building skills. Through real-world scenarios—like managing geopolitical data or tracking meals and guest preferences—students learn how to model data relationships, interpret schema constraints, and translate everyday information needs into formal database operations, preparing them for practical database use and theoretical comprehension alike.