I mentioned the other day that I’m teaching a college course at the University of Washington, and as part of that we’re doing a complete database project from requirements gathering to a completed database with all its objects. The students have done a great job on the requirements “probing questions” section, and it brought up a design question. How much should the database designer know about the business to guide them in helping design the database?
There is a school of thought that says the Business or the Business Analyst should know what the organization does and the technical staff should focus on the technology, not the business side of things. That may be fine for some groups, but for the data tier I disagree. I think the database designer should learn as much as time permits about the business and process flow through tthe company. If they don’t, they have to live with the design changes later anyway. It just makes for a smoother process for the technical staff to “reach out” a little to the business.
Hey – us DBAs don’t have enough to do anyway, correct? 🙂