8 Further Extensions for ER Diagrams with Binary Relationships

DOI: 10.1201/9781003314455-8

8.1 INTRODUCTION

Having developed the basic entity-relationship (ER) model in Chapters 4 through 7, this chapter deals with some extensions to the basic model. We introduce a new concept—attributes of relationships and present several examples. We then revisit step 6 of the ER design methodology to include attributes of relationships. Next, the chapter looks at how more entities and relationships are added to the ER model and how attributes and relationships evolve into entities, all the while refining our ER design methodology. Relationships may develop into entities, creating an intersection entity. The grammar and structured English for the ...

Get Database Design Using Entity-Relationship Diagrams, 3rd Edition 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.