News for hackers. Stuff that matters.
Re:A Simple Guide to Five Normal Forms in Relational Databas... by nradov on Monday August 02, 2010 @02:41AM (#1567044)
The HL7 RIM actually allows for this. A Person can have multiple roles including Patient and LicensedEntity (doctor). http://www.hl7.org/v3ballot/html/infrastructure/rim/rim.htm
Re:A Simple Guide to Five Normal Forms in Relational Databas... by Confusion on Monday August 02, 2010 @02:59AM (#1567067)
True, this example of doctors and patients is just the wrong sort of example, because that world has already been standardized into oblivion. However, in general, for your relatively small app for company X, you wouldn't go this far. In general, the fact that a supplier can sometimes also be a client is usually not very interesting.