Relating Data in a Database
Posted on July 19, 2017
If you have ever worked with relational databases then you probably know the importance of normalizing data. However, as a Database consultant I have come across end- users who have data in a database (such as Access) but the tables are not related. In essence, they’ve created a “database” that consist of disparate tables that are non-relational and, of course, do not utilize normalization. Summarily, they have an Excel spreadsheet in Access.
Often this is not what was intended. The result typically arise out of a quick way to query their “database” or simply from a of lack of knowledge on how to design a relational database.
In the next article I will discuss the basic rules of normalization and how it could make you life easier when dealing with your data.