RonKyle (6/27/2016)
Personally, I always thought database design belongs in the developer's hands.
It depends on the developer, but in most cases no. When I was a developer, it was okay, because as I would later discover, I could design a database. But I started with Access, where you had to be able to do both. That's not the case anymore. From my own observations I'd have to say that most developers can't grasp the fundamentals. I'm unsure why this is the case as I've done both and seen those who can do both. On the other hand, I'm not as good at the finer administrative skills. Someone else might find that unexplainable as they can easily do both.
So I would advise caution on this point.
That only shows developers need training. I come from an Access background too, so you're probably right that Access requires learning both skill sets.
The basics of good database design have never been complex, just DRY in a data context. Perhaps Steve has a point and it would be a good series for this site to create.
Might spare DBAs a few ulcers! :hehe: