In summary, this report discusses the steps involved in transitioning from the old, simple, and dysfunctional Excel file system to a new one for the student union. The complex structure was made more understandable and less confusing by converting it to a 0NF (0N) form. This also made the system less prone to errors. Furthermore, the different functional modules in the application were examined, and different technologies were suggested for each. For example, while ORDBMS was useful for complex tasks, NoSQL technology, such as live chat, was recommended for tasks requiring higher speed. Finally, the denormalization process was explained as a solution for slow-loading screens; although it increased speed, it also increased data repetition, thus increasing costs, but it was a risk worth taking. By optimizing everything, we designed Bilgifesti as a robust system that runs very quickly and doesn't crash.