The difficult I do immediately, the impossible takes a little bit longer.
Data Model ~ Damage Investigations...
This data model was designed to handle damage investigations for mishaps to utility infrastructures. (Note, there only tables included in this database the balance is up to you! Some tables contain sample data.) To download the Data Model click here.
Data Models
Business Rules...
Damage Investigations...
...may need to send more than one person
...will interact with Responders and Excavators
...will determine what happened
Main Entities...
Excavators
Damage Investigations
...will need to use equipment
...determine Root Cause
Excavators...
Responders
Responders...
...will interact with Excavators
...will contact an Investigator