Database Systems – Design, Implementation, and Management – Chapter 4 – Entity Relationship (ER)

Database Systems_
Database
Design,
Systems_
Implementation,
Database
Design,
Systems_
and
Implementation,
Management
Design, and
Implementation,
–Management
Chapter 4_ and
Entity
–Management
Chapter
Relationship
4_ Entity
–
(ER)
Chapter
Relationship
Modeling
4_ Entity
(ER)Relationship
Modeling.pdf(ER) Modeling.pdf




Database Systems: Design, Implementation, and
Management – Chapter 4: Entity Relationship (ER)
Modeling




Page 1 of 11 Database Systems_ Design, Implementation, and Management – Chapter 4_ Entity Relationship (ER) Modeling.pdf Page 1 of 11

, Database Systems Design, Implementation, and
Database
Management
Systems
- Chapter
Design,4Implementation,
- Entity Relationship
and
Database
Management
(ER) Modeling
Systems
- Chapter
Design,4Implementation,
- Entity Relationship
and Management
(ER) Modeling.pdf
- Chapter 4 - Entity Relationship (ER) Modeling.pdf




binary relationship


An ER term for an association between two entities. For example, PROFESSOR teaches
COURSE.


cardinality


A property that assigns a specific value to connectivity and expresses the range of allowed
entity occurrences associated with a single occurrence of the related entity.


composite attribute


An attribute that can be further subdivided to yield additional attributes. For example, a
phone number such as 615-898-2368 may be divided into an area code 615, an exchange
number 898, and a four-digit code 2368. Compare to simple attribute.




Page 2 of 11 Database Systems Design, Implementation, and Management - Chapter 4 - Entity Relationship (ER) Modeling.pdf Page 2 of 11