🧠 WHO CAN FIX THIS DATA MODEL EDITION, TRY YOUR LUCK TEAM GAMM & ALPHA 😊
You have just joined a UK based training company called SkillBridge Academy Ltd as a Salesforce Admin.
📌 The Situation
SkillBridge runs professional training programs.
Here is how their business works:
• A Student can enrol in multiple Courses
• A Course can have many Students
• Each enrolment must track:
• Enrolment Date
• Completion Status
• Score
⚠️ Current Setup
The previous admin designed the system like this:
• Students and Courses are two separate objects
• Courses are stored as a multi select picklist on Student
• Completion Status and Score are also stored on the Student record
🚨 The Problem
This setup is causing issues:
• No proper way to track each individual enrolment
• Reporting is inaccurate
• Cannot track different scores for different courses
• Data is messy and not scalable
🎯 What the Business Wants
They want:
• Clear tracking of which Student enrolled in which Course
• Ability to store enrolment specific data
• Accurate reporting
❓ As the Salesforce Admin, what is the BEST data model design?
🔘 A Create a Lookup relationship from Student to Course, and add Completion Status and Score fields on the Student object.
🔘 B Keep Courses as a multi select picklist on Student, and create additional fields to track completion and score for each course.
🔘 C Create a Master Detail relationship from Course to Student, and store Completion Status and Score on the Course object.
🔘 D Create a junction object called Enrolment, and relate it to both Student and Course, storing Completion Status, Score, and Enrolment Date on the Enrolment object.
17
1 comment
🧠 WHO CAN FIX THIS DATA MODEL EDITION, TRY YOUR LUCK TEAM GAMM & ALPHA 😊
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
+261
2
+211
3
+98
4
+93
5
+85
Powered by