Introduction
Schema is a structural plan of a database defining its tables columns and relationships.
Types of schemas
1. Star schema
Is a data modeling approach with a central fact table containing quantitative data, surrounded by multiple dimension tables that provide descriptive context, resembling a star's shape.
2. Snowflake Schema
Is a multidimensional database arrangement where fact tables are connected to normalized dimension tables, which in turn can be linked to further sub-dimension tables, resembling a snowflake's branches.
Conclusion
Is the essential blue print that provides a structured foundation for any data base.
Top comments (0)