maujood/ApexSandboxPracticeDataModel.MD

## ApexSandboxPracticeDataModel.MD

      
    Raw
  

              ApexSandboxPracticeDataModel.MD
            
          
    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!
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.
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
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
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!