Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
14 Cards in this Set
- Front
- Back
What is an Entity |
Building blocks of an ERD they are shown as a table. They represent people, places objects, things, events, or concepts about which data is being collected. Nouns. General representation of all entity instances. |
|
What is a Entity-Relationship Model |
A visual representation (picture) of entities, their attributes, and the relationships between entities. |
|
Attribute |
Property or characteristics of entities or relationships. Do not use the space character, instead use the underscore character. Shown as a column on an ERD table. |
|
Relationship |
business rules governing associations. Verbs that link entities. Represented by a diamond on ERD. can have attributes (intersection Data). |
|
Entity instance |
a single example of an entity |
|
Primary key |
One or more attribute that uniquely identifies each instance of an entity (represented by an asterisk). |
|
Unary relationship |
Recursive relationship between instances of the same entity. |
|
Binary relationship |
relationship between two entities. |
|
Ternary relationship |
relationship between three entities |
|
Cardinality |
how many instances of one entity are associated with an instance of the other entity. Outer symbol (the one closer to an entity). |
|
Modality |
Minimum requirements either mandatory (vertical dash) or optional (oval). Inner symbol. |
|
crows feet |
many relationship |
|
single vertical line |
single relationship |
|
Associative entity |
When there is a many-to-many relationship there is always an intersection entity. (table between to tables) |