情境
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.
這張圖裡有什麼
看懂背後的決策。
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.