🎓 Step 1: Get Certified!
Paste the link to your newly earned Data Engineer Associate Certification here
https://drive.google.com/file/d/16E6lhwm5ty01-f8Er08NvyEKiXAY5BAJ/view?usp=sharing
📝 Step 2: Explain your choice of metrics
Now the project is over, you are reviewing how the project went with some of your colleagues. One of your colleagues is discussing the data model that you are using and in particular the star schema. After the meeting the intern on the team sends you a message and asks what a star schema is.
In no more than 200 words, explain the different data models that you can use to the intern.
Conceptual Schema: Think of the conceptual schema as a big-picture view of the whole database. It gives you an overview of what data will be stored and how various pieces of data are connected. It's like a blueprint for a house that shows the main components without extra details.
Logical Schema is basically a more detailed version . It's like having a floor plan that shows where each room is without all the construction details. In other words, it specifies how the data will be organized within the database. Think of it as the blueprint that lays out the structure and organization of the data.
Physical Schema: The physical schema is the technical side of things. It's all about how we actually store the data. Think of it like a construction plan for a house – it shows us the exact materials and methods we'll use.
For our EasyLoan project, we decided to use a star schema for our data model. The star schema consists of a central fact table, which in our case is the loan transactions, connected to different dimension tables like clients, contracts, and repayments. It's kind of like organizing a library with different sections.