By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,853 Members | 936 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,853 IT Pros & Developers. It's quick & easy.

Using joins to create code from E- ER relationships

P: n/a
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

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.