Determine the purpose of the database - This helps prepare for the remaining steps. Find and organize the information required - Gather all of the types of information to record in the database, such as product name and order number. Divide the information into tables - Divide information items into major entities or subjects, such as Products or Orders.