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 2. Entity–Relationship Concepts

Until now we have dealt with databases made up of a number of distinct tables, without concerning ourselves very much with how the tables and their constituent columns were originally generated. Logical database design, also known simply as database design or database modeling, studies basic properties and interrelationships among data items, with the aim of providing faithful representations of such items in the basic data structures of a database. Databases with different data models have different structures for representing data; in relational databases the fundamental structures for representing data are what we have been calling relational tables. We concentrate on relational databases in this chapter ...

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