The latest articles on DEV Community by Enock Kipngetich (@enockngeno). https://dev.to/enockngeno https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3508350%2F39337509-284e-43bf-8f19-2a8d7c245686.jpg https://dev.to/enockngeno en Enock Kipngetich Wed, 17 Sep 2025 08:52:14 +0000 https://dev.to/enockngeno/key-concepts-to-know-of-a-schema-in-a-data-base-46m7 https://dev.to/enockngeno/key-concepts-to-know-of-a-schema-in-a-data-base-46m7 <h2> Introduction </h2> <p>Schema is a structural plan of a database defining its tables columns and relationships.</p> <h2> Types of schemas </h2> <h3> 1. Star schema </h3> <p>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.</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fmomffhnk3nnknfut7mun.png" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fmomffhnk3nnknfut7mun.png" alt=" " width="800" height="689"></a></p> <h3> 2. Snowflake Schema </h3> <p>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.</p> <p><a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4zextqlfhridy72q3nh9.jpeg" class="article-body-image-wrapper"><img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F4zextqlfhridy72q3nh9.jpeg" alt=" " width="273" height="184"></a></p> <h2> Conclusion </h2> <p>Is the essential blue print that provides a structured foundation for any data base.</p> webdev schema database