You have been hired by an environmental consulting company (CC) that specializes
ID: 3545639 • Letter: Y
Question
You have been hired by an environmental consulting company (CC) that specializes in creating environmental impact statement (EIS) for large projects. It needs a database to track the progress of each EIS. The company is particularly concerned about tracking public comments, questions from state and federal officials and the response to all these comments. All comments are scanned and stored as digital files.
Create a data model of the database based on following report.
EIC project #:
Date initiated:
Date ECC involved
Date ECC finished
Client
Principle contact: Billing:
Phone: Phone:
Contact address Billing address
City, state, zip City, State, Zip
Site location: latitude longitude
Site address : city state zip
Site description
Proposed development description
Proposed activities (standard list)
Drain wetlands
Fill
Build road
Store waste
Comments and response
Date received Category Source File Response date Person title
...
....
EIC project #:
Date initiated:
Date ECC involved
Date ECC finished
Client
Principle contact: Billing:
Phone: Phone:
Contact address Billing address
City, state, zip City, State, Zip
Site location: latitude longitude
Site address : city state zip
Site description
Proposed development description
Proposed activities (standard list)
Drain wetlands
Fill
Build road
Store waste
Comments and response
Date received Category Source File Response date Person title
...
....
.... ....Explanation / Answer
Please increase the time
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.