15% off membership for Easter! Learn more. Close

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. 

Asked at Veeva
348 views
Answers (1)
crownAccess expert answers by becoming a member

You'll get access to over 3,000 product manager interview questions and answers

badge Silver PM
Access expert answers by becoming a member
0 likes   |  
Get unlimited access for $12/month
Get access to 2,346 pm interview questions and answers to give yourself a strong edge against other candidates that are interviewing for the same position
Get access to over 238 hours of video material containing an interview prep course, recorded mock interviews by expert PMs, group practice sessions, and QAs with expert PMs
Boost your confidence in PM interviews by attending peer to peer mock interview practices, group practices, and QA sessions with expert PMs
Get unlimited access for $12/month
Get access to 2,346 pm interview questions and answers to give yourself a strong edge against other candidates that are interviewing for the same position
Get access to over 238 hours of video material containing an interview prep course, recorded mock interviews by expert PMs, group practice sessions, and QAs with expert PMs
Boost your confidence in PM interviews by attending peer to peer mock interview practices, group practices, and QA sessions with expert PMs