How would you design a data model to accommodate an Account Hierarchy?
Account Hierarchy Data Model Design:
How would you design a data model to accommodate an Account Hierarchy? There are many ways to do this - all that have various implications. Pick one and indicate why you chose this design over other designs. Please also do this in PowerPoint.
Here is an example of an account hierarchy:
- Hospital System - Kaiser
- Hospital - Kaiser South San Francisco
- Department - Cardiology
- Doctor - Dr. Smith
- Doctor - Dr. Kallman
- Doctor...
- Nurse...
- Nurse...
- Receptionist...
Note that healthcare providers can belong to multiple locations. For example, some may work out of Kaiser at South San Francisco on some days, and San Mateo on others. Some might have private practices on the side, so there can be different levels of the hierarchy.
You'll get access to over 3,000 product manager interview questions and answers
Recommended by over 100k members
Top Veeva interview questions
- Design a kid-friendly Swiggy experience for 10-16 year olds.0 answers | 178 views
- See Veeva PM Interview Questions
Top Product Design interview questions
- How would you design a bicycle renting app for tourists?62 answers | 82.5k views
- Build a product to buy and sell antiques.54 answers | 66.8k views
- How would you design a web search engine for children below 14 years old?36 answers | 42.9k views
- See Product Design PM Interview Questions
Top Product Design interview questions
- Design a library for the future.25 answers | 23.5k views
- How would you design a consumer application for a scooter sharing business?21 answers | 18.6k views
- Build a product to solve the dog poop problem.13 answers | 9.4k views
- See Product Design PM Interview Questions