What are the major steps in a database design?

Conceptual database design, logical database design and physical database design.

Explanation:

-Conceptual database design: Refers to build a model of the data and identify realationships, attributes and entities.

-Logical database design: Is how to put the conceptual design in a logical structure.

-Physical database design: Refers to how the logical structure is implemented physically.