Crear tabla para A, E → F R2(A, E, F) con clave (A,E).
Academic resources from the University of Granada and the National University of Tucumán provide comprehensive PDF guides for database normalization, covering 1NF, 2NF, 3NF, and BCNF. These materials focus on practical application, including functional dependency graphs and, in some cases, specific business scenarios such as library systems. Access the University of Granada's guide for detailed solutions, including functional dependency graphs, at Normalization Exercise Solution Universidad Nacional de Tucumán (UNT) Catedra de Base de Datos Crear tabla para A, E → F R2(A, E, F) con clave (A,E)
Los atributos no clave solo deben depender de la clave primaria, no de otros atributos. Access the University of Granada's guide for detailed
Acción: Separamos los productos del pedido 1001 en filas distintas. Asignamos una clave primaria compuesta ( Num_Pedido + Producto ). including functional dependency graphs