 |
» |
|
|
|
Database design is complex. The foregoing discussion oversimplifies many aspects of good design in the interest of getting you started. For a major production system, you need to study your data carefully and plan your tables accordingly. Here are the titles of some recommended readings for additional help in designing your databases: Atre, Shaku. Database: Structured Techniques for Design,
Performance, and Management. New York: John Wiley & Sons Inc., 1988. Date, Chris. "A Practical Approach to Database Design," in Relational Database: Selected Writings. Menlo Park, CA: Addison-Wesley Publishing Co., Inc., 1986. Loomis, Mary E. S. The Database Book. New York: Macmillan Publishing Company, 1987. Turk, Thomas A. "Using Data Normalization Techniques for Effective Data Base Design," Journal of Information Systems Management, Winter 1985.
Also, refer to the "Logical Design" and "Physical Design" chapters in
the ALLBASE/SQL Database Administration Guide.
|