DSDeon Slabbertinbecomingaprogrammer.hashnode.dev·Dec 4, 2023 · 6 min readDatabase Naming ConventionsNaming conventions are critical in programming and database design as it prevent early death, either by a co-worker or self-inflicted. Giving the necessary attention to naming things appropriately will save you major headaches when it comes to unders...00
DSDeon Slabbertinbecomingaprogrammer.hashnode.dev·Dec 4, 2023 · 7 min readTables & KeysNow that we know about data design and how data in different containers relate to each other via foreign keys, let's look at relational databases and start calling things by their correct names. Please note that everything you will learn here applies...00
DSDeon Slabbertinbecomingaprogrammer.hashnode.dev·Nov 29, 2023 · 10 min readEntities & RelationshipsWe now know what data is and what a database is. We used a spreadsheet to build a rudimentary employee database. and then improved the database structure by addressing the insert, update and delete anomalies. Then I said, we will now move on to real ...00
DSDeon Slabbertinbecomingaprogrammer.hashnode.dev·Nov 28, 2023 · 10 min readDatabase Design Gone BetterIn the previous article, we created a spreadsheet acting as a database. This poorly designed database invited insert, update and delete anomalies. We also looked at the problems that null values can cause. In this article, we will attempt to remedy s...00
DSDeon Slabbertinbecomingaprogrammer.hashnode.dev·Nov 27, 2023 · 8 min readDatabase Design Gone BadIt is important that you understand the contents of this article. Together with the next article, it forms the knowledge you need to do good database designs. So, please make sure you understand the things discussed here before you proceed. Data Redu...00