Logical Database Design.

Creating a database logical design is one of the first important steps in designing a database. There are four logical database models that can be used hierarchical, network, relational, or object-oriented. 1.Hierarchical: The first important logical database model. Still found in many mainframe-based, legacy systems. Records are arranged in a top-down parent/child structure. Each child can be related to only one parent 2.Network Developed to overcome the limited scope of the hierarchical model. Similar …

…overlap, and/or increase efficiency. One of the main complaints about relational databases is the complexity of the relations themselves. That is, how everything's split out into all these tables. This is where we attempt to reduce that complexity. Works Cited [MC99] F. R. McFadden, J. A. Hoffer, M. B. Prescott, MODERN DATABASE MANAGEMENT, The Benjamin/Cummins Publishing Company, Inc., Redwood City, CA, 1999 Kevin Hough, SQL SERVER 7 DATABSE DESIGN STUDY GUIDE , Sybex Inc., Alameda, CA, 1999