Skip to Main Content
After 13 years of collaboration, MindSumo will be winding down its platform operations and closing December 31st, 2025. We are sincerely grateful to our solvers and clients for their contributions and partnership. If you have any questions, please contact us at [email protected].
How would you revamp our database architecture?
Challenge Type: computer science
See more like this check out our active challenges
$600
top 6
19
submissions
20
solutions max

We are revamping our entire database architecture and we'd like your help! We are an insurance provider, and we deal primarily with 3 sets of users: Hospitals, Doctors and Policyholders.

Deliverables

Keeping in mind that this application will be written in C#, please write up a design document based on object oriented design principles that will allow us to keep track of Hospitals, Doctors and Policyholders.

Think carefully about how you will structure these classes. Provide at least 3 methods or attributes per class, and make sure you are using inheritance as needed.

Also include a description of how your classes relate to one another (e.g. "Each Hospital has many Doctors" and "Each Policyholder has one Hospital"). Please make sure to discuss your reasoning in making these design decisions.

    Submissions will be graded on the following criteria:
  • Meets Deliverables
  • Creativity
  • Clarity
Reward Tiers
3 Winners
will receive $150 each
3 Honorable Mentions
will receive $50 each
Leaderboard
$150.00 Kevin Matesi Northern Illinois University
$150.00 Jyothi Karthik Nagarajan Arizona State University
$150.00 Priyanka Neelakrishnan San Jose State University
$50.00 Timothy Mendez California Polytechnic State University
$50.00 Colin Cummings University of Michigan
$50.00 mjhennes California Polytechnic State University
Submission questions


0 characters Average: 1674 characters
Your solution must be at least 200 characters long