Using joins to create code from E- ER relationships

[Morten Gulbrandsen]

Hello,

starting from some software database spesification,
defined in some Enhanced entity relationship diagram,

resulting in all kinds of
relationships,
1:1
1:Many
Many:1
Many : many

And last but not least:
Subclass/superclass relationship

This seems to be a small problem for me,
With the current version of MySQL.
How can I use joins to code in SQL syntax an arbitrary model of
An Entity relationship diagram ?

With all constraints correctly implemented,
Without any foreign keys ?

Without any "on delete set default",
I hope this can be implemented also without
Combining MySQL to PHP, Perl or C.
Yours sincerely

Morten Gulbrandsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***************@bp.com
__________________________________________________ ______________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
__________________________________________________ ______________________

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw