Design: Do I need foreign key? + Trigger vs Foreign Key?
Posted by:
Paul S
Date: September 06, 2005 11:21PM
Hi there,
I am designing a database for school to maintain students records.
It's a relational DB that gots teacher / students/ class tables. I am just wondering:
1) In a design point of view, do I need a foregin key to ensure the referential integrity? Is this necessary at all?
2) The MySQL version I am using doesn't allow me to use InnoDB, but I vaguely remebered that I can use TRIGGER to get around the situation!? Or do I stil need InnoDB for it?
Many thanks.
Paul
Subject
Views
Written By
Posted
Design: Do I need foreign key? + Trigger vs Foreign Key?
2850
September 06, 2005 11:21PM
2059
September 07, 2005 02:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.