A well thought out logical design is as critical as a well analyzed business model is and lays the solid foundation
for physical implementation of databases. Logical database design focuses on the how a particular segment of
enterprise data can be represented to derive the maximum integrity benefits due to the underlying data model, the
relational model.
Here is an overview of the articles on this section:
- Common Lookup Tables
In many typical SQL shops, data oriented business applications are sometimes developed with less emphasis on data
integrity for a variety of reasons. Database developers often wear several hats to fit roles starting from system
analyst to data modeler/database designer. In the midst of satisfying the client's wish lists, they are often
tempted to use several kludgy design schemes. One such scheme among the most prevalent kludges is a common
lookup table. Read more...
- A primer on key fundamentals
This article is currently being written Read more...
|
