becomingaprogrammer.hashnode.devDatabase 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...Dec 4, 2023·6 min read
becomingaprogrammer.hashnode.devTables & 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...Dec 4, 2023·7 min read
becomingaprogrammer.hashnode.devEntities & 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 ...Nov 29, 2023·10 min read
becomingaprogrammer.hashnode.devDatabase 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...Nov 28, 2023·10 min read
becomingaprogrammer.hashnode.devDatabase 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...Nov 27, 2023·8 min read