Systems Design Chapter 05 Flashcards
Binary Relationships
Relationship between two different types of things - i.e. customer and an order
Unary Relationship (recursive)
Relationship among two things of the same type - such as one person married to another person
Ternary Relationship
Relationship among three different types of things
n-ary Relationship
Relationship among n (any number of) different types of things
Attribute
one piece of specific information about a thing
identifier key
an attribute that uniquely identifies a thing - (primary key in db)
compound attribute
attribute that contains a collection of related attributes
multiplicity
a synonym for cardinality
cardinality
the number of associations that occur among specific things - 1:1 - 1:M - M:M
Data Entities
things about which the system needs to store information in the traditional approach to information systems
Entity Relationship Diagram ERD
The squares with the zero/one to many lines
Associative Entity
A data entity that represents a many-to-many relationship between two other data entities
Generalization/Specialization hierarchies
hierarchies that structure or rank classes from the more general superclass to the more specialized subclasses; sometimes called inheritance hierarchies
inheritance
a concept that allows subclasses to share characteristics of their superclasses
whole-part hierarchies
hierarchies that structure classes according to their components
aggregation
whole-part relationship between an object and its parts
composition
whole-part relationship in which the parts cannot be dissociated from the object