O cenário
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.
O que há neste desenho
Entenda as decisões por trás dele.
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.