CHAPTER 2

CONCEPTUAL MODELING

After reading this chapter, the reader will understand:

  • Basic concept of entity-relationship model
  • Entities and their attributes
  • Entity types and entity set
  • Different types of attributes
  • Key attribute, and the concept of superkey, candidate key and primary key
  • Concept of weak and strong entity types
  • Relationships among various entity types
  • Constraints on relationship types
  • Binary versus ternary relationships
  • E-R diagram notations
  • Features of enhanced E-R model that include specialization, generalization, and aggregation
  • Constraints on specialization and generalization
  • Alternative notations of E-R diagram
  • Unified modeling language (UML), a standard language used to implement object data modeling
  • Categories of UML ...

Get Introduction to Database Systems 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.