Re: [SQL] Distributed keys

2003-12-24 Thread Chris Travers
indicating whether the employee is a manager, teacher, or sub. Best Wishes, Chris Travers - Original Message - From: "Michael Glaesemann" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 24, 2003 4:42 AM Subject: [SQL] Distributed keys Hell

Re: [SQL] Distributed keys

2003-12-23 Thread Tom Lane
Michael Glaesemann <[EMAIL PROTECTED]> writes: > I'm interested in hearing what others have to say, especially along the > lines of implementation. I haven't seen much discussion of distributed > keys on the lists (other than Josh Berkus), so perhaps there isn't much > interest. Would there be a

[SQL] Distributed keys

2003-12-23 Thread Michael Glaesemann
Hello all! An area of the relational database model that is not included in the SQL standard are distributed keys and distributed foreign keys. A quick example (Case 1): employees (id, name); schools (name, location); teachers (employee_id, school_name); subs (employee_id); managers (employee_i