Skip to content

Instantly share code, notes, and snippets.

@maujood
Last active January 13, 2024 06:09
Show Gist options
  • Save maujood/9bca1e95a9fe39b1cb881a116873d83e to your computer and use it in GitHub Desktop.
Save maujood/9bca1e95a9fe39b1cb881a116873d83e to your computer and use it in GitHub Desktop.
ApexSandbox.io Practice Data Model

Interplanetary School of Programming

This is a work-in-progress for the practice data model for an Interplanetary School of Programming.

This data model is used for practice problems on ApexSandbox.io. Click here for a Schema Builder ERD of the data model, or continue below to the detailed data dictionary.

Student (apxio__Student__c)

Represents a student that can be enrolled in classes.

Field Type Additional Info
Name Text Standard Name field. Should contain student's full name.
apxio__Phone__c Phone
apxio__Email__c Email
apxio__Registration_Number__c Autonumber Autonumber assigned after record is created.
apxio__Home_Planet__c Picklist Remember that we're far off into the future. Valid values include Earth, Mars, Neptune, Saturn, Uranus.
apxio__Cumulative_GPA__c Number Allows one digit before and two digits after decimal point.

Course (apxio__Course__c)

Represents a course that may be offered as a class as part of a semester.

Field Type Additional Info
Name Text Standard Name field. Should contain a descriptive name of the course
apxio__Course_Details__c Rich Text Area Free-form description of the course.
apxio__Credits__c Picklist Valid values include 0, 1, 2, 3, and 4
apxio__Active__c Checkbox

Class (apxio__Class__c)

A class record is a course that is being offered for registration at a campus as part of a semester. Students can be enrolled in classes.

Field Type Additional Info
Name Text Standard Name field
apxio__Course__c Master-detail The course (apxio__Course__c) that is being offered as a class
apxio__Description__c Text Area Free-form description
apxio__Max_Enrollment__c Number Maximum number of students allowed to enroll in a class
apxio__Offered_Semester__c Lookup The offered semester (apxio__Offered_Semester__c) this class is being offered in
apxio__Primary_Teacher__c Lookup The primary teacher (apxio__Teacher__c) assigned to this course

Class Enrollment (apxio__Class_Enrollment__c)

An enrollment is a junction between Student and Class representing that the given student is/was enrolled in the class.

Field Type Additional Info
Name Auto Number Auto-generated. Does not need to filled out
apxio__Offered_Class__c Master-detail The class (apxio__Class__c) that the student is enrolled in
apxio__Student__c Master-detail The student (apxio__Student__c) enrolled in the class
apxio__Final_Grade__c Picklist Valid values include 4.00, 3.67, 3.33, 3.00, 2.67, 2.33, 2.00, 1.67, 1.33, 1.00, 0.67, 0.33, and 0.00
apxio__Grade_Change_Reason__c Text Area Text that should be filled out if the grade is changed
apxio__Pass_Fail__c Formula (Text) Reads Pass if the final grade is 2.00 or above, Fail if it is 0.67 or below, and blank if the final grade is blank
apxio__Tuition_Rate__c Picklist Valid values include In-planet and Out-of-planet. Remember that we're in the future! Predatory price-gouging by educational institutions is no longer based on state and country lines, but on planetary boundaries!
@pankajvit
Copy link

It was a fantastic resource for practicing apex coding. Thanks for it

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment