fact table and dimension table

<p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">FACT TABLE</p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">A fact table is a central table that stores quantitative data for analysis. It typically contains facts (measurements or metrics) and foreign keys to dimension tables (will be explained later).</p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">In simpler terms, a fact table is like a special baking board you own where you keep track of the number of cookies you bake, when you baked them, and the cookies everyone loves the most. It helps you be a super organised cookie baker especially if your aim is to make sales.</p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">DIMENSION TABLE</p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">A dimension table is a table in a database that stores descriptive information about the data in a fact table. It's a form of dictionary that provides context and meaning to the numbers and measurements in the fact table.</p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt;">In a very simple term, a dimension table is like a special board where you keep important details about all the ingredients you use for baking cookies. It helps you stay organised and makes baking your favourite treats easier and more fun for you.</p>