Data Design
Define all the entities to be dealt with and the relationships between them
Transform the conceptual design into logical design wherein all the views are combined and all the resulting data elements are defined and the data structure is syntactically and semantically determined
Normalize this logical design for mathematically minimized redundancy and maximized integrity
Transform this logical design to a physical design where the underlying RDBMS, hardware, and use patterns are taken into account
Develop the SQL DDL code specific to each RDBMS vendor’s product is generated