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 - 04:00:15 CST
