3NF

zipadd(zipid, zip*, state)

zipstate(zip, state)

streetdesig(desid, description)

jurisdiction(jurisid, jurisname, lastname, firstname, middlei, street, zipid*, phone, email)

usage(usageid, usage)

type(typeid, type)

contaminants(contid, description)

zoning(zoneid, code, description, jurisid*)

broker(brokerid, lastname, firstname, middleim, phone, email, street, zipid*)

Owner(ownerid,lastname, firstname, middleim, phone, email, street, zipid*)

Employee(employeeid,lastname, firstname, middleim, phone, email, street, zipid*, ssn)

Developer(developerid,lastname, firstname, middleim, phone, email, street, zipid*)

Property(PropID,Sold, Phase1, Phase2, Phase3, RailAccess, MapCoords, PropSize, AssesNum, sitename, GPD, devpot, incentives, Comments, streetaddress, zipid*, desid*, zoneid*, ownerid*)

Envstat(PropID*, contlevel, contamination)

Usageitem(propid*, typeid*, usageid*)

Contitem(contid*, propid*)

Devsearchresult(devsearchid, searchdate, developerid*, propid*)

Taxinfo(taxid, taxyear, assessed, percentage, taxamount, status, tra, exempt, improvement, landamount, propid*)

Fininfo(finid, buyer, seller, lender, lastrans, saledate, saleamnt, firsttd, addl, docno, dolsqft, loantype, prevdate, prevamnt, propid*)

Empactivity(actid, actdate, employeeid, propid*)