O'Reilly logo

Database Design: Know It All by Graham Witt, Graeme Simsion, Markus Schneider, Patrick O'Neil, Elizabeth O'Neil, Bonnie O'Neil, Thomas P. Nadeau, Tony Morgan, Jim Melton, Sam S. Lightstone, W.H. Inmon, Jan L. Harrington, Terry Halpin, Ralf Hartmut Güting, Lowell Fryman, Stephen Buxton, Toby J. Teorey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 5. Logical Database Design

5.1. Introduction

If we produced a conceptual data model and had it effectively reviewed and verified, the next step would be to translate it into a logical data model suitable for implementation using the target database management system (DBMS).

In this chapter we look at the most common situation (in which the DBMS is relational) and describe the transformations and design decisions that we need to apply to the conceptual model to produce a logical model suitable for direct implementation as a relational database. Later it may be necessary to make some changes to this initial relational model to achieve performance goals; for this purpose we will produce a physical data model.

The advantages of producing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required