Dana Clark

SQL and Database Design

Working with databases makes me happy. I like designing them and working with them after they're designed.

I've studied, and continue to study, relational database theory and practice. With database design, as in programming, I start with carefull planning. Likewise when I do begin coding, I do so in a well thought out, organized, and highly readable manner. Taking these precautions prevents many frustrations later on as the project progresses. I can, but don't always, construct E-R diagrams. I tend to outline my project textually, aiming to construct a database normalized to at least the Boyce-Codd Normal Form(BCNF) and usually to 4NF. Denormalization takes place afterwards as needed.

To date I've worked lightly with Oracle and MySQl building tables and writing intermediate level queries against them. I've written considerably more complex queries (pivot views), functions,and stored procedures for DB2 for i on the iSeries. Below are some links to SQL scripts that I have written.