So, sometime last month I read a book called “Show Your Work” by Austin Kleon and I had promised that my next article will be a review of this book. With that being said, I am going to use a book review template that was recommended by Ali Abdaal. How…

So, one day I decided I needed to get back to my productivity routine — I’ve been slacking a bit since school started. One way that I wanted to do this was to go back to writing short articles, but I didn’t know where to start. …

Almost everybody has some kind of a digital device these days — it could be your smart phone, tablet, or even your personal computer. Unfortunately, these devices have been exacerbating the old traditional crimes. Crimes committed through digital devices are called computer crimes, referred to as cybercrimes hereafter. One of…

It is highly unlikely that we all have not heard the words 'authentication' and ‘authorization’. I will try and use a common real life example to explain the difference between the two. Remember the day you went to the store to purchase your favorite cheese? You got to the point…

In this short article, I will take you guys through printing a basic triangle pattern in SQL. Before we start, remember that SQL syntax may differ depending on the Database Management System (DBMS) that you are using. We will use MS SQL Server syntax in this article. This article was…

In the previous section we discussed how to convert to 2NF. Now let’s look at converting to 3NF: Converting to 3NF This is about removing the transitive dependencies by identifying the determinant of each transitive dependency, which then becomes a primary key of a new table and then assigning the…

In the previous section we discussed how to convert to the first normal form. Now let’s look at converting to 2NF. Converting to the 2NF involves removing the partial dependencies by: Identifying the determinants for each partial dependency and assigning the corresponding attributes. Writing out the entire composite primary key…

In the previous section, we discussed some basic knowledge regarding normalization in databases. To efficiently convert a table to 1NF, you need to identify a Primary Key that when used, it should be able to return only one record from the table. …

Normalization is essentially breaking up a table into new related tables and assigning attributes to these new tables. This is done in order to MINIMIZE data redundancies/repetitions of attribute values and to ultimately avoid anomalies (note the term minimize. This is because we sometimes deliberately repeat data in order to…