Re: how to code an 'IS - A' relationship ?

2003-09-02 Thread Stephen Fromm
Morten, I'd like to help you with actual code, but I can't, because the version of MySQL I use doesn't implement foreign key constraints. In my own code (written in the C API), I plan on checking these constraints myself. But I can't implement them in the tables themselves. Best, Steve Fromm

how to code an 'IS - A' relationship ?

2003-08-28 Thread Morten Gulbrandsen
Hello MySQL programmers, suppose we have an Enhanced ER diagram, with entities as classes/ subclasses connected through some IS-A relationship. How can this be Coded in MySQL Please? My prerequisites are the basic database texts from http://www-db.stanford.edu/~ullman/dscb.html

Re: how to code an 'IS - A' relationship ?

2003-08-28 Thread Stephen Fromm
Hello MySQL programmers, suppose we have an Enhanced ER diagram, with entities as classes/ subclasses connected through some IS-A relationship. How can this be Coded in MySQL Please? My prerequisites are the basic database texts from http://www-db.stanford.edu/~ullman/dscb.html

how to code an IS - a relationship ?

2003-07-09 Thread Morten Gulbrandsen
Hello MySQL programmers, suppose we have an Enhanced ER diagram, with entities as classes/ subclasses connected through some IS-A relationship. How can this be Coded in MySQL Please? My prerequisites are the basic database texts from http://www-db.stanford.edu/~ullman/dscb.html