Category Software Related Stories Handling Data with SQL -- 11/17/98 Next: Static and Dynamic SQL

Continued from Relational Model Basics

Now that you know a little about the relational model, we're going to ask you to forget about it. Well, not really, but at this point we should explain that even though SQL is based on Codd's relational model, it is not a full or faithful implementation of it. (That's one reason the SQL-92 standard doesn't mention relations.) For example, a SQL table is not exactly the same as a relation, because among other things, a SQL table allows duplicate rows and relations don't have duplicate tuples. Also, SQL doesn't support relational domains, although it does support data types to some extent. (Several prominent relational advocates are lobbying to include relational domains in a future SQL standard, however.)

Unfortunately, the disparity between SQL and the relational model has caused a lot of confusion and debate over the years. Since the focus of this article is to teach you about SQL, not relational theory, we won't discuss all of the discrepancies here. For now, you just need to know that because there are differences, relational terms and SQL terms are not always interchangeable. From now on, we'll only use SQL terminology. Instead of relations, attributes, and tuples, we'll refer to their SQL counterparts: tables, columns, and rows.

Next: Static and Dynamic SQL

Published as PC Tech Feature in the 11/3/98 issue of PC Magazine.

Elsewhere on ZDNet
• Learn SQL Online -- ZD University
• Business Software: Databases -- ZD Products