By now, you must have a fair idea about star schemas, constraints and ERDs. Now, we will go through an example of a star schema and understand how it makes database designing simpler and more intuitive. So, let’s watch the upcoming video to learn more about it from our expert.
So, as you learnt in the video, the market star schema consists of five tables: 1 central fact table and 4 dimension tables, which describe the fact table. This structure of one fact table with multiple dimension tables makes data analysis easier because it reduces the number of joins required for querying data. When you learn about joins later in this module, you will better understand the reason why Professor Ramanathan insists that you design a star schema during the database creation phase.
In this way, you have completed the session on database design. let’s summarise the session in the next session.