1. Only then (the president became) (aware) of the serious (financial) situation the company (was facing).
2. Transit Authorities (have been compiled) a database of over 4,000 research faculty to provide the best qualified researchers to support the project. 여기서는 have compiled가 답이라는데 단수라서 has compiled 아닌지...명쾌한 해설 부탁드려요