Tell me what are the different design schemas in Data Modelling? Explain with the example?
Submitted by: MuhammadThere are two different kinds of schemas in data modeling
Star Schema
Snowflake Schema
Now I will be explaining each of these schemas one by one.
The simplest of the schemas is star schema where we have a fact table in the center which references multiple dimension tables around it.
All the dimension tables are connected to the fact table. The primary key in all dimension tables acts as a foreign key in the fact table.
Submitted by: Muhammad
Star Schema
Snowflake Schema
Now I will be explaining each of these schemas one by one.
The simplest of the schemas is star schema where we have a fact table in the center which references multiple dimension tables around it.
All the dimension tables are connected to the fact table. The primary key in all dimension tables acts as a foreign key in the fact table.
Submitted by: Muhammad
Read Online Data Architect Job Interview Questions And Answers
Top Data Architect Questions
| ☺ | Tell me do you know why Data Warehouse is used? |
| ☺ | Explain me what do you understand by data mart? |
| ☺ | What are conformed dimensions? |
| ☺ | Tell me what is a fact & a fact table? |
| ☺ | Tell me the physical data model? |
Top Data Structure Categories
| ☺ | Data Center Manager Interview Questions. |
| ☺ | Sort And Searching Interview Questions. |
| ☺ | Creative UI/UX Designers Interview Questions. |
| ☺ | Data Structure Linked list Interview Questions. |
| ☺ | Data Structure Arrays Interview Questions. |
