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 ...

Get Database Design: Know It All now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.