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