Design an employee directory with reporting queries
Company: Expedia
Role: Software Engineer
Category: System Design
Difficulty: hard
Interview Round: Onsite
Overview: This question evaluates system design competence with emphasis on hierarchical data modeling, concurrent data consistency, API and schema design, and efficient reporting-line queries within an employee management system.