What are the main steps involved in the design of a database Explain each of this?

Typical design has to define entities first. Then relationships, primary keys has to be fixed. Normalization should be done. Fields of different entities should be created. Redundant data should be removed . Integrity of the data should be focused on.