El escenario
A company needs to track IT assets, log maintenance tickets, assign technicians, manage repair tasks, and maintain a parts inventory. This ERD models the core entities and their relationships.
Qué hay en este dibujo
Lee las decisiones que hay detrás.
01
Separate Employee table for both reporters and assigned technicians using two foreign keys
02
UsedPart junction to support many-to-many between RepairTask and Part with quantity used
03
Asset serial_number as unique key for hardware identification
Use when designing a database for help desk or IT asset management with repair workflows and parts tracking.