文章

顯示從 3月, 2020 起發佈的文章

FIFA World Cup Access database

圖片
Yes, I am talking about MS Access. In the year of 2020. But why can't I? Okay, this is indeed a very geeky thing to do. I created a World Cup database that can let user input the countries, teams, tournaments, etc. into the database, then most importantly, automatically compute all the group results and show the corresponding team presence during the knockout stage just by entering results of each match (including yellow/red cards which might be used during group ties). Notwithstanding the torture of fixing numerous trivial bugs, this is also a very interesting undertaking. To translate the finest FIFA World Cup group stage promoting rules into execution, and do it as succinct as possible, is no easy task. A similar case holds for the knockout stage. You need to compute what team names and their corresponding flags to show up at the right place without having much redundancy - I initially made too many layers of queries and rendered the chart non-executable. But the m