Pdf 19 Work — Ejercicios Resueltos De Normalizacion De Base De Datos

Tabla: Factura (NroFactura, Cliente, CP, Ciudad, Fecha)
Clave: NroFactura
DF: CP → Ciudad

Solución:
Transitiva: NroFactura → CP → Ciudad → 3FN violada.
Descomposición:
Factura (NroFactura, Cliente, CP, Fecha)
CodigoPostal (CP, Ciudad)

(... Ejercicios 10 al 14 para 3FN)

Tabla: PedidosDetalle (ID_Pedido, ID_Producto, Cantidad, NombreProducto, PrecioUnitario)
Clave primaria: (ID_Pedido, ID_Producto)
DF: ID_Producto → NombreProducto, PrecioUnitario

Solución:
Está en 1FN pero viola 2FN (dependencia parcial).
Descomposición:
PedidoDetalle (ID_Pedido, ID_Producto, Cantidad)
Producto (ID_Producto, NombreProducto, PrecioUnitario) ✅ General rule :

If you can’t find the PDF, here is the classic set of 19 problems (common in courses). I’ll describe each exercise type and give the solution pattern.

| # | Problem description | Normal form target | Key solution | |---|--------------------|--------------------|----------------| | 1 | Student (ID, name, course, instructor) | 2NF | Remove partial dependency: course→instructor | | 2 | Orders (order#, product#, product desc, qty, price) | 3NF | Product#→desc, price (transitive) | | 3 | Employee (empID, dept, dept_head, project, hours) | BCNF | Split into Emp_Dept and Emp_Project | | 4 | Library (bookID, author, author_nationality, publisher) | 3NF | Author→nationality (transitive) | | 5 | Sales (store, product, date, qty, store_region) | 2NF | Store→region (partial dep on PK) | | 6 | Hospital (patient, doctor, doctor_specialty, date) | BCNF | Separate Doctor_Specialty | | 7 | University (student, subject, professor, professor_office) | 3NF | Professor→office | | 8 | Flights (flight, date, pilot, plane, pilot_license) | BCNF | Pilot→license | | 9 | Invoice (inv#, cust#, cust_addr, item#, desc, price) | 2NF | Split customer and item details | | 10 | Enrollment (student, course, instructor, instructor_rank) | 3NF | Instructor→rank | | 11 | Rental (rentalID, movie, customer, cust_phone, days) | 2NF | Customer→phone | | 12 | Product warehouse (warehouse, product, qty, warehouse_city) | 3NF | Warehouse→city | | 13 | Exam (student, exam, date, room, room_capacity) | BCNF | Room→capacity | | 14 | Project (proj#, emp#, hours, emp_dept, dept_mgr) | 3NF | Emp#→dept, dept→mgr | | 15 | Bank account (account#, cust#, cust_name, branch, branch_city) | 2NF | Cust#→name, branch→city | | 16 | Conference (paperID, author, author_affil, reviewer) | 3NF | Author→affil | | 17 | Sports team (team, player, player_pos, coach) | BCNF | Player→pos (multiple players per pos) | | 18 | Restaurant (order#, item, price, table#, server) | 3NF | Item→price, table→server | | 19 | Hotel booking (bookingID, guest, room, room_type, price_per_night) | 2NF → 3NF | Room→type, type→price |

✅ General rule:

That exact phrase appears in academic materials from Latin American universities (e.g., UNAM, UTPL, UNAL). Try these searches on Google: and certification candidates.

Known sources (free, legal):

⚠️ Avoid sites that require login for “19 work” – that phrase sometimes points to a specific workbook from a technical institute.

Concept: A specialized interactive module within an educational app or advanced PDF viewer designed specifically for the "19 Work" dataset. It bridges the gap between static PDF study guides and interactive learning.

Target Audience: Database students, SQL beginners, and certification candidates. Known sources (free

Título del Recurso: Ejercicios Resueltos de Normalización de Base de Datos (Colección de 19 Casos) Categoría: Educación / Bases de Datos / Ingeniería de Software Nivel: Intermedio - Avanzado

Puntos Fuertes:

Áreas de Mejora Comunes en este tipo de PDFs: