Identify the entities
List the attributes for each entity
Choose the primary key for each entity
Identify relationships between entities
Determine relationship cardinality
Determine relationship optionality
Identify foreign keys
Resolve many-to-many...
Define the purpose of the database
Identify the data you need to store
List the tables or collections required
Define the fields for each table or collection
Choose...