Relational Database Modeling and Database Design

Abstract

Aside from dealing with tables and the queries that are based on them, many DBAs don’t have a detailed understanding of database topics, such as normalization, functional dependency, and entity-relationship modeling. However, a good database is the bedrock on which you can create a good application. The ability to design a database is particularly useful to DBAs working in smaller organizations, where they’ll need to know how to do everything from working with the UNIX file system to resolving networking issues. Even if designing databases isn’t a part of your job description, however, understanding database design will help you when performance tuning the database.