Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

IIM > Entity Relationship Model > Flashcards

Entity Relationship Model Flashcards

1
Q

Expressed in terms of entities in the business environment, the relationship (or associations) among those entities, and the attributes (or properties) of both the entities and their relationships

A

Entity-Relationship Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Detailed, logical representation of the data for an organization or for a business area

A

Entity-Relationship Model

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

is a graphical representation of an E-R Model

A

E-R Diagram

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Basic Symbols

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data (NOUN)

A

Entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Naming and Defining Entity Types

A

Singular Noun
Specific to organization
Precise

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What Should an Entity Be?

A
  • An object that will have many instances in the database
  • An object that will be composed of multiple attributes
  • An object that we are trying to model
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Entity Types

A
  • Weak
  • Strong
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

An entity that exists independently of other entity types

A

Strong Entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

An entity type whose existence depends on some other entity
type

A

Weak Entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

The relationship between weak entity type and its owner

A

Identifying Relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Property or characteristic of an entity type that is of interest to the organization

A

Attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

An attribute of an entity that must have a value for each entity instance

A

Required Attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

An attribute of an entity that may not have a value for every entity instance

A

Optional Attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

An attribute that cannot be broken down into smaller components

A

Simple (or atomic) attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

An attribute that can be broken down into components parts

A

Composite attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

An attribute that may take on more than one value for a given entity instance

A

Multivalued attribute

17
Q

attributes hold a single value for each record.

A

Single valued attribute

18
Q

are physically stored in the database.

A

Stored Attribute

19
Q

whose values can be calculated from related attribute values

A

Derived Attribute

20
Q

An attribute (or combination of attributes) that uniquely identifies individual instances of an entity type

A

Identifier Attribute

21
Q

Association representing an interaction among the
instances of one or more entity types that is of interest to the organization
Has a verb phrase name – present tense

A

Relationship

22
Q

A meaningful association between (or among) entity types

A

Relationship Type

23
Q

An association between (or among) entity instances where each relationship instance includes exactly one entity from each participating entity type

A

Relationship Instance

24
Q

may be associated with many-to-many (or one-to-one) relationship, as well as with an entity

A

Attributes

25
Q

An entity type that associates the instances of one or more entity types

A

Associative Entity

26
Q

involves a rectangle with a diamond inside.

A

Associative Entity

27
Q

Each entity in the relationship will have exactly one related entity

A

One-to-One

28
Q

An entity on one side of the relationship can have many related entities, but an entity on the other side will have a maximum of one related entity

A

one-to-many

29
Q

A relationship between the instances of a single entity type

A

Unary Relationship

30
Q

Entities on both sides of the relationship can have many related entities on the other side

A

many-to-many

31
Q

The number of entity types that participate in a relationship

A

Degree

32
Q

A relationship between the instances of two entity types

A

Binary Relationship

33
Q

A simultaneous relationship among the instances of three entity types

A

Ternary Relationship

34
Q

The maximum number of instances of one entity that may be associated with each instance of another entity

A

Maximum Cardinality

35
Q

The minimum number of instances of one entity that may be associated with each instance of another entity

A

Minimum Cardinality

36
Q

Specifies the number of instances of one entity that can (or must) be associated with each instance of another entity

A

Cardinality Constraints

IIM (6 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions