Re: Question about modeling

>> As I have said each contract can be associated with one or more
departments, but I want that all those departments belongs to the same client. In other words, departments can share contracts, but clients can not. <<

It sounds like a client should be modeled as an attribute of a contract.

CREATE TABLE Contracts
(contract_id INTEGER NOT NULL PRIMARY KEY, client_id INTEGER NOT NULL
REFERENCES Clients(client_id)
ON DELETE CASCADE
    ON UPDATE CASCADE,
..); Received on Tue Jan 25 2005 - 13:31:10 CST