2. Any social activity generates social norms that suggest how people should behave, and science is no exception.

Here the "that" clause is a relative clause because it describes what kind of norms are generated. Namely, they are "norms that suggest how people should behave."

Also, the "how people should behave" is a noun clause that is nested within the relative clause.