Explain the fact table and the dimension table?

Fact table:
They are the measurable quantities or the numeric metrics of the data which can be analyzed by dimension table.
Facts are stored in the fact table and contain foreign keys that uniquely refer to the associated dimension tables.
The fact table is compatible to store the data at the atomic level and thus, it allows a large number of records to be inserted at once.
For instance, a sales category fact table can have a product key, customer key, and promotion key referring to a specific event.
Dimension table:
They are the descriptive attribute values for various dimensions of each attribute which define multiple characteristics.
A dimension table referring to a product key from the fact table can consist of a product name, product type, color, size, and description.