MySQL Forums :: Database Design & Data Modelling :: Subtypes can they be related


Advanced Search

Subtypes can they be related
Posted by: shashidhar anand ()
Date: June 24, 2013 08:01PM

Ok I have two exclusive subtypes and I see a relationship between them .. my question is can I create a 1 to many relationship between them?

For example: Supertype: Person subtypes: doctor, patient and I have a relationship that a doctor is assigned to many patients but one patient is monitored by only one doctor. So can I have relationship between Doctor [1toM] Patient?


The above is only an example cause explaining my situation is a bit difficult.

Thx

Options: ReplyQuote


Subject Written By Posted
Subtypes can they be related shashidhar anand 06/24/2013 08:01PM
Re: Subtypes can they be related Rick James 06/25/2013 10:43PM


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.