Question

You are working for an environmental consulting company that specializes in creating environmental impact statements (EIS) for large project developments in a region. EIS needs a database to track the information needed for EIS. EIS reports particularly public comments related to project developments in the region. A project development may involve multiple sites. Some activities in a site may raise environmental concerns and inquiries that EIS needs to know. EIS also needs to track the responses from the project developers related to these concerns/comments/inquiries. All comments and related responses are scanned and stored as digital files.

Create a data model (E/R model) for the database based on following paper form that reflects information needed by EIS. Note, each form is for only one site of a project that may have several sites of development. An EIS report may include many forms like this because there may be multiple ongoing projects in the region.

EIS project #: Project Description Date initiated: Date project started Date project finished				Project Developer Name Principle contact person Phone: Contact Email Address: City, state, zip
Project 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
Title of Comment/inquery	Date-received	Comment-category	comment-scaned file (link)		Response date	Response-scaned file (link)	Responsor-name
....	....	....	…
…..	….	….	….

Answer 1

HERE IS THE DATA MODEL IN ER DIAGRAM...IF YOU HAVE ANY QUERY PLEASE COMMENT

PLEASE GIVE AN UPVOTE