โ† Deloitte questions

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.