I need advice on DB design for an agency model. Should I create many linked tables to keep data clean, or just one big Projects table? My planned structure includes:
Geography: Locations, Regions, and Holiday Calendars.
Workflow: Templates, Milestones, and Master Checklists.
Directory: Contacts ("secret coded" for GDPR), Team, and Venues.
Admin: Task Types, Finance, and Channels.
Is having 15+ linked tables too complex or slow? Or is it better than using dropdowns inside a single table? I want a professional setup that allows for good reporting later. Any advice? I know that AI can help with this, but AI is helpful when you know what you are doing. I’d love to hear your thoughts or if you have any links/guides on professional DB structuring for beginners.
Thank you for your help and answers.