Proper way to model
0 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Michael_Lock
Posted On:   Tuesday, November 18, 2008 03:02 PM

Hi. What is the proper way to model a relationship between a company and a regulatory license that they hold to conduct operations at a particular location (a mine site)? The scenario is; A company (mining company) must have a permit to prepare(construct roads, buildings, waste dumps etc.) a mine site (a specific geographic region within which deveopment is permitted) to the the point of the commencement of commercial operation. I've tried a ternary relationship but I'm not sure that's right. I've tried a 1-1 relationship between a permit and a mine but then how does the company fit in? I've tried a 1-1 relationship between the company and t   More>>

Hi.

What is the proper way to model a relationship between a company and a regulatory license that they hold to conduct operations at a particular location (a mine site)?

The scenario is;

A company (mining company) must have a permit to prepare(construct roads, buildings, waste dumps etc.) a mine site (a specific geographic region within which deveopment is permitted) to the the point of the commencement of commercial operation.

I've tried a ternary relationship but I'm not sure that's right.

I've tried a 1-1 relationship between a permit and a mine but then how does the company fit in?

I've tried a 1-1 relationship between the company and the mine but then how does the permit fit in?

I've tried the license as an attribute class of the relationship between a company and a mine. Not sure if that's right either. This might be right except that there are instances where a company might not have a permit for a mine (this is certainly the case for legacy data)

I've tried the company as an attribute class of the relationship between a mine and a permit. That doesn't make sense to me becuase that would mean the company would only exist if the relationship between the mine and the permit existed.

Anyone with any ideas?

   <<Less
About | Sitemap | Contact