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 (`apxioStudentc`)

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.

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

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

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!