Everyone knows what a simple database is: Telephone directories, mail-order catalogs and dictionaries are all databases of sorts. Databases can be structured or organized in several different ways: as ...

One of the principles within relational theory is that each entity’s row or tuple be uniquely identifiable. This means the defined structure includes some combination of attributes whose populated ...

So, a friend of mine and I are tagging up to learn a little with php and mysql. Php is coming along swimmingly, but the mysql is a bit of a challenge right now. Part of what we're working on now is ...

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we dive ...

If you’ve worked with relational database systems for any length of time, you’ve probably participated in a discussion (argument?) about the topic of this month’s column, surrogate keys. A great ...