Dimension tables contain descriptive information about a subject or matter.
Dimension tables contain hierarchies of attributes that aid in summarization.
For example,
A "Student" dimension table contains descriptive information about Student -> (Name, Age, Gender, Address, Phone_No etc.)
A class dimension table contains descriptive information about class -> (Class_Name)
and a Subject dimension table contains detail information about subject -> (Subject_Name).
Note: Dimension tables contain attributes that describe fact records in the fact table.
Fact table contain summarized data to provide useful information to the analyst.
The fact data is a relation/ Referential integration between various Dimention(Subject) Table data.
Here we can see it is a collection of only ids of other dimension Tables and forms useful information to the analyst.
So, from this table we understood following details given below:
- Pritam Das is studying in class "Spoken English" and "Hindi" with subject "ABC Tutor" and "Hindi Tutor".
- Rina Das is studying in class "Hindi" with subject "Hindi Tutor"
- Ramaprasad Das is studying in class "Spoken English" and "Bengali" with subject "ABC Tutor" and "Bengali Tutor".
No comments:
Post a Comment