O'Reilly logo

Introduction to Database Systems by ITL Education Solutions Limited

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

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

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