Key concepts to know of a schema in data base



This content originally appeared on DEV Community and was authored by Asha

Introduction

Schema is a structural of a database its tables columns and relationship.

Types of a schema

1. star schema

A star schema is a widely used data modeling technique in data warehousing that organizes data into a central fact table surrounded by multiple dimension tables

Example of a star schema

Conclusion

We can use schema to structure most of our database to know what to place in our databases.


This content originally appeared on DEV Community and was authored by Asha