A casting agency manages castings for clients. Each casting has a code (CC), name (NC), contract date (FC), client (NN), budget (P), and agent (AG). Each casting has multiple phases (NF) with start dates (FI), and each phase has multiple individual tests (NP) with date (FR), start time (HI), end time (HF), and room (S). Castings have profiles (CP) with attributes (AP). Candidates (CM) have a name (M), address (D), and a single profile. Candidates can participate in tests, receiving a result (RP) of "apto" or "no apto", with constraints on eligibility.
No deben existir grupos repetitivos o columnas con listas de valores. Se debe definir una clave primaria clara. Segunda Forma Normal (2FN) Debe estar en 1FN.
Si el Nombre_Ciudad depende del Código_Postal , y este no es la PK, mueve ambos a una tabla de "Ciudades". ✅ Tutoriales en Video (Ejercicios Paso a Paso) Si prefieres ver el proceso visualmente: Ejercicio de Clínica Médica (1FN a 3FN) 5 Ejercicios prácticos resueltos A casting agency manages castings for clients
| | Nombre_Cliente | | --- | --- | | 1 | Juan Pérez | | 2 | María Gómez |
This guide will provide exactly that: a curated collection of solved normalization exercises found in various PDFs and textbooks, complete with detailed solutions to help you master this essential database design skill. We will explore normal forms, functional dependencies, and decomposition techniques, all while referencing the most valuable resources available online. Castings have profiles (CP) with attributes (AP)
This exercise involves finding a minimal cover of the FDs (removing extraneous attributes and redundant dependencies) and then decomposing into 3NF or BCNF. The full solution would involve multiple steps and is too lengthy for this article, but it demonstrates how theoretical concepts apply to complex, real-world systems.
A continuación, te presento algunos ejercicios resueltos de normalización de base de datos: No deben existir grupos repetitivos o columnas con
: Se deben eliminar las dependencias parciales. Esto significa que si una tabla tiene una clave compuesta, cada columna debe depender de toda la clave, no solo de una parte. 3FN (Tercera Forma Normal)
Analizando las dependencias funcionales, observamos que existen dependencias parciales:
Una empresa de logística utiliza el siguiente esquema para registrar los productos que recibe de distintos proveedores: