List the different types of locks used by DBMS systems and explain how they differ from each other. Additionally, suggest the suitable scenario for each of them.
400 to 500 words, at least 4 references with one website reference (All must be Harvard referencing style).