Re: relational databases

On Wed, 12 Feb 2003, wombat wrote:

> 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?

Some redundancy? Just a little is annoying. Could you please post the DDL for the tables in question. It would make it much easier to visualize you problem.

Alan Gutierrez - ajglist_at_izzy.net Received on Wed Feb 12 2003 - 08:50:16 CST