Re: normalization

From: <ravi.ven_at_gmail.com>
Date: 1 Apr 2006 23:46:48 -0800
Message-ID: <1143964008.499891.66020@e56g2000cwe.googlegroups.com>

I think the Original Poster (OP) has not expressed his concerns clearly.

As stated by Malcolm, replacing DBMS by "1", etc., achieves nothing. If your sw_type table has columns called (type, description, ...) and the rows stored are like:

Row 1: DBMS, Database Management System
Row 2: WS, Web Server

etc.

Now, by using the only the type from this table in the first table, what you have ensured is that the non-key columns depend only on the primary key and thus the table is in 2nd Normal Form, at least.

Ravi Received on Sun Apr 02 2006 - 01:46:48 CST