The scenario
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.
What is in this drawing
Read the decisions behind it.
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.
More like this