Understanding the data model.
All right.
Now let's understand the data model that we are going to work with for this particular section that
we are going to understand the in-depth concepts of custom objects and the various object relationships
and sales force.
I have taken an example of a data model that applies in the field of education as we all know in the
past a few decades education institutions have really started using ERP systems for integrating and
optimizing their business processes.
One main reason for me to choose this data model is that I felt all of us can relate ourselves to this
data model because all of us are learning sensible as we all in the learning curve.
So I thought like it is more applicable to us.
The other main reason is that as this particular data model is pretty simple straightforward the structure
is very easy to understand so that we can directly jump into the technical part of it.
From the technical perspective and then we think about this education platform or the learning platform
let's first think about the major entities that comes to mind.
You know whenever I like.
Begin I think of our educational institutions so what what all the major entities that comes to our
mind are definitely courses because every single education institution has got numerous courses to offer
and students definitely know there has to be takers so there will be a number of students that are associated
with that education institution and instructors of course yes for teaching those courses and then there
are many other optional entities also say for example extra curricular activities that is optional right.
So these are some of the major entities that comes to our mind when we think of that education platform
so constantly all these I have designed a simple data model with these major entities to help us understand
our technical concepts.
So the entities that I have chosen are courses students instructors departments extracurricular activities
and enrollments however definitely there are no limitations.
So please feel free to choose as many entities as you want.
The more entities you choose you will end up creating more objects in the application so that you still
enhance your learning and Salesforce.
So yeah please go ahead and choose as many entities as you want but for this particular section for
the section of custom objects and application I have chosen these major entities and off as you can
see here for every entity here for example courses.
These are the various fields that I have chosen that is applicable to courses and for students instructors
departments extracurricular activities and for enrollments.
So every entity order and Salesforce.com every object has got numerous fields that the field type marked
against it.
So when we talk about field types we know Salesforce offers many different types of field types.
So make sure that you mark every single field type at least to one off the field in one off the entity
thereby you will get to know the characteristic of that field type.
How that works for that particular entity even tried to choose the.
The uncommon ones for example geo location you do not see geo location in every single entity or every
single prior a project right.
So choose your location just text area text area long or rich.
This is a good opportunity for us to understand more about that particular field type because in advanced
admin certification and even in exams that are more likely chances for you to Encounter about these
uncommon field types.
So this is a good learning opportunity for us.
So at least one single field type chosen anyone off the entity you know say for example like text area
text area rich even text encrypted you know so like this for example here text encrypted text area rich
text area long you know you worry every single field type try to map every single field type possible
to at any one off the field at least one of the fields in one of the entities that you have created
and similarly with relationships also both look up and master data try to work the relationship between
the objects and then have to have created both look up and the master detailed relationships like the
field and the field types the relationships is also very important.
You know try to mark the master detailed relationships and then look up relationships try to understand
the relationship between two entities and decide whether it has to be a master detail Order up.
So based on that I have created a small relationship diagram that could help us understand more about
the relationship between all these six entities.
So this is the high level relationship diagram between the entities that we have chosen.
And as you know the red relationship that is a master detail relationship which in turn says that it's
mandatory and the blue ones are the look of relationship in fact like these color coding or is the generalized
the color coding standard sales full color coding even in schema builder when you when you open up by
the schema building and see the relationship between objects like you know you will see something similar
but they're like you'll have all the fields instead all but just that like I've given boxes up here.
But otherwise it is pretty similar.
You have all the entities out here and all the relationship between the entities these ones are that
the red ones are the master detail and the blue ones are the lookup relationship perfect now that we
know what all the entities that are to be created what are all the fields that are associated with every
single entity.
What will be their field type and what are all the different relationships between the entities whether
it does a mandatory or a master data relationship audit is a loosely binding look up relationship.
So then we have decided upon all these.
What's the next step.
Of course we have to go and create them in the sense what is application so now let's go ahead and create
all these entities the fields and the relationships and sales force that will form the basis for us
to understand the technical concepts behind it.