chapter 2Exploring Relational Database Components

In this chapter, we explore the conceptual, logical, and physical components that the relational model comprises. The processes involved in database design are covered in Chapter 5. In the sections that follow, we explore first the components of a conceptual database design, and then the components of a logical and physical design.


In this chapter, the reader should:

• Understand conceptual database design components, including entities, attributes, relationships, and business rules.

• Understand logical/physical database design components, including tables, columns and data types, constraints, and views.

Conceptual Database Design Components

Conceptual database design involves ...

Get Databases DeMYSTiFieD, 2nd Edition, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.