11d (edited) • 🎖️CHALLENGES /ASSIGNMENTS HUB
😊 WHO CAN FIX THIS? DATA MODEL EDITION
You have just joined a UK based subscription fitness company that sells monthly gym memberships to both individuals and companies.
Here is the situation.
• One company can have many employees
• One employee can have multiple memberships over time
• Each membership can include multiple add ons like personal training or classes
• Finance wants to report on total membership revenue per company
• Operations wants to see active memberships per employee
• Sales wants to see which companies have the highest number of active members
Right now everything is being stored on Accounts and Opportunities and reporting is completely broken.
As the Salesforce Admin, what is the **best data model design** to support this?
🗳️ Vote below and explain your reasoning.
This one is intentionally tough and tests real world data modelling thinking 👀
Kind regards
Godwin Mbah
🔘 A. Use Account for companies, Contact for employees, Opportunity for memberships, and Products for add ons
🔘 B. Create custom objects for Membership and Add On, relate Membership to Contact and Account using lookups
🔘 C. Create custom objects for Membership and Add On, use a junction object between Contact and Membership, and relate Membership to Account
🔘 D. Use Opportunity as Membership, create a custom Add On object, and relate everything using master detail relationships
7
15 comments
😊 WHO CAN FIX THIS? DATA MODEL EDITION
skool.com/pathway-to-salesforce
A community to help you transition into tech, master Salesforce skills, and unlock career opportunities with hands-on learning and real-world support.
Leaderboard (30-day)
1
+190
2
+108
3
+74
4
+69
5
+67
Powered by