Steps for Good Database Design

• Determine Purpose of Database
• Find and Organize Information
• Create Tables for Information
• Establish Table Relationships
• Refine Your Design

https://kingfisherdata.com/5-helpful-database-design-steps/

This one is from Kingfisher and is pretty good summary