function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Albert CharanAlbert Charan 

Design data model for Schools

Hi all ,


new to salesforce development . I need a basic design for school-student management  . We will have 3 different object as 

1. Student --> containing basic info about student like DOB ,name ,standard,StudnetID  etc....StudentID will be unique . 

2. Marksheet --> This object has field like studentID ,name , marks in every subject ,and many more . we need to send report card to parent . mail will be used from Student object .

3. attendance sheet --> montly attendance sheet which need to be send to parent with remarks . Also StudendID and Student name will be here . 

Now student ID is here unique and we need to send marksheet and attendance sheet everymonth . we will upload csv file for marks and attendance at the end of every month . according to that data we want to send a mail to parent .

my question is how I can relate this student object to rest of two object based on studentID and how I can store data for every month (like if someone wants to check  attendance for the current year ,we should be able show them ). 

Thanks 
GauravendraGauravendra
Hi Albert,

For the student object, I'll say you can utlize the standart Account object.
You can create studentId as unique field. You can create two record types of Account object, one for Student and other for Parent.

Create two objects for Marksheet and AttendenceSheet. Both will have master-detail relationship with Student(Account) object.
For Attendence tracking, you can store weekely attendence for each student in one AttendenceSheet object record.
Under the AttendenceSheet object create a picklist field that will store the months name, to track the month.
Create fields for each week days (Mon,Tue, etc..). Create a date field that mark the start of each week.

In this case, you can store weeks attendence in single record.

Hope this helps!
 
Brodie MatsonBrodie Matson
The expectation is the main thing left in life when you traps in the hover of the dimness. Never be disillusioned throughout everyday life and consistently trust on the site www.toppaperwritingservice.com/review-of-pendrago-com/ to get the best throughout everyday life. I welcome this blog for giving us the daylight of expectation.
Robert Griffin 3Robert Griffin 3
Hello. I think that on this forum you will definitely find help. There are very useful discussions and good users. When I was looking who can write my personal statement  On this forum they recommended to me this site https://www.personalstatementwriter.com/ I followed the recommendation and was satisfied. Good luck to you.
 
ischool connectischool connect
When you're prepared to start your journey for a today's position, your vocation counselor will really want to provide you with pursuit of employment help, that's quite in all overseas education consultants likelihood of the most broadly diagnosed justification for why humans visit a lifelong professional.