Category Archives: Tutorials

Instructional articles

Opening CSV files in Excel

CSV (Comma Separated Values) is a useful file format for tabular data that I often use. But every time I want to load a CSV file into Excel it does not seem to recognize the files. Usually it just loads … Continue reading

Posted in Tutorials | Tagged , , , , , , | 5 Comments

Method for normalizing a relation to BCNF based on functional dependencies

In the previous post I showed the method I use to determine the candidate keys and highest normal form of a relation. Now let’s break these large relations into smaller ones to make sure we achieve Boyce-Codd Normal Form (BCNF)! … Continue reading

Posted in Tutorials | Tagged , , , | 5 Comments

Method for determining candidate keys and highest normal form of a relation based on functional dependencies

For my advanced database systems course I needed to learn how to take a given relation and functional dependencies, tell the highest normal form and then normalize it up to BCNF. It’s actually not that hard, but there are a … Continue reading

Posted in Tutorials | Tagged , , , , | 64 Comments

Getting right click menus to work in 64-bit Windows Explorer

Shells extensions are components that extend the functionality of Windows. The most common type is contextual menus that appear when you right click on items in Windows Explorer. For example, an archive utility can add itself to the menu to … Continue reading

Posted in Tutorials | Tagged , , , , | Leave a comment

How to enable (or improve) two finger scrolling on your Windows laptop

This is a small guide on to how to get two finger scrolling and other multi touch gestures on your Windows laptop. Even if your laptop is already capable of scrolling using two fingers, this guide can still be worth … Continue reading

Posted in Tutorials | Tagged , , , , , , , , , , , | 28 Comments