Database Reference
In-Depth Information
Year Full
Name,
Semester Name
Department
Code
Year Code,
Semester Code
Code
Semester
Sequence
Number
Student
Count
Number
Scholarship Indicator, Graduation Indicator, University Applica-
tion Indicator, High School Application Indicator, Financial Aid
Indicator
Indicator
And now we will fill in the Property Characteristics Template for each of these properties.
To save space, I am only going to fill this in for the measure
Student Count
from the Prop-
erty Template above, but on an actual project, you would complete this for all attributes:
Student Attrition Application Property Characteristics
Sample
Values
Property
Definition
Format
Length
Source
Transformations
The number of people currently enrolled
in a program (both degree and non-de-
gree).
Student
Reg
App
Derived when loading
data from the data ware-
house.
Student
Count
50
Num
8
STEP 2: NORMALIZE AND ABSTRACT (RELATIONAL ONLY)
Normalization and abstraction are techniques for properly assigning data elements to entit-
ies on the relational data model. Normalization is a mandatory technique, and abstraction
is an optional technique.
Normalization
