Ejercicios Resueltos De Normalizacion De Base De Datos Pdf 19 Work Access
The 19th exercise is likely a full case study. Look for:
. While the exact "19 work" PDF is typically associated with legacy software "fix" sites, the core content involves standard Database Normalization exercises. Calgary Catholic School District
Below is a breakdown of the typical normalization steps found in these types of solved exercise guides (covering 1NF, 2NF, and 3NF
) to help you work through your own problems or understand a similar PDF. Core Normalization Steps First Normal Form (1NF) : Eliminate repeating groups and ensure atomicity.
: Every column must contain only one value (no lists or sets), and each row must be unique. The 19th exercise is likely a full case study
: You usually split many-to-many data into separate rows or tables. Second Normal Form (2NF) : Remove partial dependencies. Requirement : The table must already be in 1NF. : No non-key attribute can depend on only
of a composite primary key. If an attribute depends only on one part of the key, move it to a new table with that part of the key as its primary key. Third Normal Form (3NF) : Remove transitive dependencies. Requirement : The table must already be in 2NF.
: Attributes should only depend on the primary key, not on other non-key attributes. If Column B depends on Column A, and Column A is not the primary key, Column B must move to a new table where A is the key. UNAM | Portal UNAM Recommended Free Solved Resources
If you are looking for high-quality solved exercises (similar to what that specific PDF likely contained), these academic repositories provide structured PDF guides: University of Granada (UGR) If you have a PDF titled "Ejercicios Resueltos
: Detailed solutions showing functional dependencies and BCNF decomposition. National University of Salta (UNSa)
: Practical guides for 1NF through 3NF with step-by-step table transformations. Scribd - Normalization Guide
: A comprehensive Q&A guide covering lossless decomposition and candidate keys. Universidad Nacional de Salta Normalización de Bases de Datos - UNAM
Based on your request, I have designed a comprehensive feature specification for a digital product (like an app or an interactive PDF platform) centered around the theme of database normalization exercises. Tabla: Clientes (ID_Cliente
Here is a proposal for a feature called "The Norma-Log: 19-Step Interactive Solver."
If you have a PDF titled "Ejercicios Resueltos de Normalización de Bases de Datos" containing 19 worked examples, you are looking at a structured set of problems designed to take you from basic to advanced normalization concepts (1NF, 2NF, 3NF, and BCNF). Here is how to analyze and learn from those 19 exercises systematically.
| N° | Tema principal | Forma normal alcanzada | |----|----------------|------------------------| | 1 | Atributos multivalor | 1FN | | 2 | Dependencia parcial | 2FN | | 3 | Dos dependencias parciales | 2FN | | 4 | Clave primaria simple con redundancia | 2FN | | 5 | Empleados y proyectos | 2FN | | 6 | Matrícula de alumnos | 2FN | | 7 | Inventario por tienda | 2FN | | 8 | Transitiva profesor→departamento | 3FN | | 9 | Transitiva CP→ciudad | 3FN | | 10 | Dependencia transitiva múltiple | 3FN | | 11 | Pedidos con descuento por cliente | 3FN | | 12 | Notas de estudiantes con profesor | 3FN | | 13 | Alquiler de películas | 3FN | | 14 | Historial médico | 3FN | | 15 | Horarios y aulas | FNBC | | 16 | Roles en proyectos | FNBC | | 17 | Calificaciones con DF solapadas | FNBC | | 18 | Vuelos y asientos | FNBC | | 19 | Base hospitalaria completa | FNBC |
Tabla: Clientes (ID_Cliente, Nombre, Teléfonos)
Teléfonos contiene valores como "111-222,333-444"
Solución:
Violación de 1FN (atributo multivalorado).
Normalización:
Cliente (ID_Cliente, Nombre)
TelefonosCliente (ID_Cliente, Telefono) → Clave primaria compuesta.
