|
|
Re: sancutary ERD diagram
|
Posted: Nov 13, 2006 9:37 PM
|
|
This is an interesting concept.
Sactuary is the top object that encompasses everything. I would not put it in the ERD because everthing describes or is related to the sanctuary.
A manager is an employee and volunteers although they may not be paid are actually unpaid employees. So where are the Elephants? It is hard to understand.
However consider everyone a person. An Employee is a person that is paid. A manager is paid so he is an employee. The term Staff might work better for everyone that works for the organization. Staff is everyone with some job at your organization. Employee is a key that indicates an HR system that pays people.
Manager works for Person
Manager supervises Person (Both Paid and unpaid Staff)
could be
person or staff works for person
person or staff supervises person
person or staff manages animals
person or staff manages fixed assets
person or staff controls supplies.
Everyone is a person however, maybe some visitors may also do work like researchers.
Think of some other things like
Sanctuary has animals
Sanctuary has employees
Sanctuary has fixed assets
sanctuary has staff
sancutary has boundaries
In this case sactuary is an object so maybe the manager manages the sanctuary or does he work for the sanctuary or both. Maybe the manager works for an external agency. I work for a community college and Funding can come from many sources. Federal, State, County, Internal fundraising, Alumni, Donations, grants, etc.
If everyone was in a person table then there would be a circular relationship from supervisor to supervised. Even volunteers have to be supervised to some extent.
On a high level model try describing all of the characteristics, including the hidden characteristics, and then try to make a model to statisfy all of the characteristics or business rules.
|
|
Previous Topic
