Hospital appointment database schema and class hierarchy
Filed under Deloitte
The question
Design table structures and relations for a hospital scenario where a patient wants to schedule an appointment with a doctor at a particular time (hospital -> department -> doctors -> patient), along with the corresponding class hierarchy and relations.
No write-up yet. Related questions below have one.
Related Deloitte questions
Collected from public candidate posts and coding forums. Updated Nov 2026.