LDDM — A structured logical database design methodology

  • Beverly K. Kahn
Part 1. Data Base Design And Requirement Engineering
Part of the Lecture Notes in Computer Science book series (LNCS, volume 132)


The trend of producing databases which do not satisfy organizational requirements can be attributed to the fact that the database designer is required to simultaneously consider many design constraints and does not have a comprehensive methodology to follow. A new decomposition of the logical database design process in which each level satisfies a single design objective is developed. In this decomposition, the requirements process and logical database design process are integrated to ensure that organizational requirements are satisfied. A structured logical database design methodology called LDDM that is based on this decomposition has been developed. LDDM consists of six design steps: Requirements Step, Entity Step, Relationship Step, Entity Structure Step, Refinement Step and DBMS Accommodation Step. LDDM including its constituent steps and techniques is presented. The utilization of LDDM will result in increased designer productivity, better documentation and a high quality logical database.


Processing Requirement Database Management System Database Design Requirement Document Type Description 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. Aurdal, Eivind, "A Multi-Level Procedure for Design of File Organization," CASCADE Working Paper 36, Institute for Data Base Handling, University of Trudheim, Norway, 6 May 1975.Google Scholar
  2. Bernstein, Philip A., "Synthesizing Third Normal Form Relations from Functional Dependencies," Transactions on Database Systems, (December 1976).Google Scholar
  3. Bubenko, J.A. Jr., Derild, S., Lindencrona-Ohlin, E. and Nachmen, R., "From Information Requirements to DBTG-data Structures," Proceedings of Conference on Data: Abstraction, Definition and Structure, Salt Lake City, Utah, March 1976.Google Scholar
  4. Hartman, W., Matthes, H., Proeme, A., Management Information Systems Handbook, (New York: McGraw-Hill Book Co., 1968).Google Scholar
  5. Kahn, Beverly K., "A Method for Describing the Information Required by the Database Design Process," Proceedings of SIGMOD, Washington, D.C., June 1976.Google Scholar
  6. Kahn, Beverly K., "A Structured Logical Database Design Methodology," Ph.D. Dissertation, The University of Michigan, August, 1979.Google Scholar
  7. Novak, Donald O., and Fry, James P., "The State of the Art of Database Design," Technical Report 76 DE 7, The University of Michigan, August 1976.Google Scholar
  8. Smith, John M., and Smith, Diane C. "Data Base Abstraction," Proceedings of ACM Conference on Data: Abstraction, Definition and Structure, Salt Lake City, Utah, March 1976.Google Scholar
  9. Teichroew, Daniel, "Improvements in the System Life Cycle," Proceedings of IFIP, Stockholm, August 1974 (Amsterdam: North-Holland Pub. Co., 1974).Google Scholar
  10. Teichroew, D., and Winters, E., "Recent Developments in System Analysis and Design," ISDOS Working Paper No. 153, University of Michigan, July 1976.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1982

Authors and Affiliations

  • Beverly K. Kahn
    • 1
  1. 1.School of ManagementBoston UniversityBoston

Personalised recommendations