relational databases
From: wombat <wendy.cox2_at_ntlworld.com>
Date: 12 Feb 2003 02:00:15 -0800
Message-ID: <f12b00a0.0302120200.20c6db40_at_posting.google.com>
I have a database assignment that seems to product a relation with one composite primary key and no other attributes. It does not link two relations, but just extends off of one. Is this legal? The relation contains three attributes; ProductID, ProductName and ProductType. The ProductType contains repeating groups and is not sustained by the primary key (productid), so has been removed along with a copy of the primary key to a new relation, but this creates a table with only a primary key and no other relations. It does solve the problem of some redundancy, but not much. Is this correct?
Date: 12 Feb 2003 02:00:15 -0800
Message-ID: <f12b00a0.0302120200.20c6db40_at_posting.google.com>
I have a database assignment that seems to product a relation with one composite primary key and no other attributes. It does not link two relations, but just extends off of one. Is this legal? The relation contains three attributes; ProductID, ProductName and ProductType. The ProductType contains repeating groups and is not sustained by the primary key (productid), so has been removed along with a copy of the primary key to a new relation, but this creates a table with only a primary key and no other relations. It does solve the problem of some redundancy, but not much. Is this correct?
Thank you Received on Wed Feb 12 2003 - 11:00:15 CET