Conduct a site research on a specific property using the concepts discussed during this week.

You can use the following websites to select a property or utilize any other resource.

Choose either a wetland or a floodplain.

? For the wetland search: go to www.fws.gov, click on wetlands, than wetlands mapper quick launch.

? For the floodplain search: go to www.msc.fema.gov.

Using the property information, take it through each of the Sustainable Sites

prerequisites and credits and assess the properties ability to satisfy them.

Please provide screenshots of the important information used from the online

resources.

The result of combining the both tables is:

Employee(EmployeeNum, LastName, FirstName, WageRate, SocSecNum, DepartmentNum, Street, City, State, PostalCode)

Explanation:

Since the EmployeeNum is the primary and it is available in both tables, what happens is that, it will not list the primary key column twice. It will list the primary key first then all the other attribute in the first table followed by the attribute in the second table. And it will take note so as not to repeat attribute that already occur in the first table.

For instance; in this case, besides EmployeeNum, LastName and FirstName also appear in the both tables but only one instance of them were listed in the resulting table.