Brainscape's Knowledge GenomeTM

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


See full index

BTM 382 > Entity Relationship Modeling > Flashcards

Entity Relationship Modeling Flashcards

1
Q

What is an Entity Relationship Diagram?

A

It is a conceptual database as viewed by the end user

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

What are the main components of the ERD?

A

Entities
Attributes
Relationships

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

What are the 3 different ERD notations?

A

The Chen notation
The Crow’s Foot notation
The UML notation

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

What does the object of interest to the end user refer to?

A

It refers to the entity set and not to a single entity occurrence

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

What does the ERM correspond to?

A

It corresponds to a table in the relational environment

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

How is an entity represented in Chen. Crow’s Foot, and UML notations?

A

It is represented by a rectangle that contains the entity’s name

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

What are the characteristics of a required attribute?

A

Must have a value and cannot be left empty

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

What are the characteristics of a optional attribute?

A

Does not require a value and can be left empty

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

What are the characteristics of a domain?

A

Set of possible values for a given attribute

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

What are the characteristics of a identifier?

A

One or more attributes that uniquely identify each entity instance

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

What are the characteristics of a composite identifier?

A

Primary key composed of more than one attribute

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

What are the characteristics of a composite attribute?

A

Attribute that can be subdivided to yield additional attributes

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

What are the characteristics of a simple attribute?

A

Attribute that cannot be subdivided

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

What are the characteristics of a single-valued attribute?

A

Attribute that has only a single value

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

What are the characteristics of a multivalued attributes?

A

Attributes that have many values

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

What are the advantages of stored derived attributes?

A

Saves CPU processing cycles
Saves data access time
Data value is readily available
Can be used to keep track of historical data

17
Q

What are the advantages of not stored derived attributes?

A

Saves storage space
Computation always yields current value

18
Q

What are the disadvantages of stored derived attributes?

A

Requires constant maintenance to ensure derives value is current, especially if any values used in the calculation change

19
Q

What are the disadvantages of not stored derived attributes?

A

Uses CPU processing cycles
Increases data access time
Adds coding complexity to queries

20
Q

What is connectivity?

A

It describes the relationship classification

21
Q

What is cardinality?

A

It expresses the minimum and maximum number of entity occurrences associated with one occurence of related entity

22
Q

How is cardinality indicated in the ERD?

A

It is indicated by placing the appropriate numbers beside the entities, using the format (x,y)

23
Q

What is existence dependence?

A

Entity exists in the database only when it is associated with another related entity occurrence

24
Q

What is existence independence?

A

Entity exists apart from all of its related entities
Referred to as a strong entity or regular entity

25
Q

What is a weak (non-identifying) relationship?

A

Primary key of the related entity does not contain a primary key component of the parent entity

26
Q

What is a strong (identifying) relationship?

A

Primary key of the related entity contains a primary key component of the parent entity

27
Q

What are the conditions of a weak entity?

A

1- Existence-dependent
2- Has a primary key that is partially or totally derived from parent entity in the relationship

28
Q

How does a database designer determine whether an entity is weak?

A

Through business rules

29
Q

What is optional participation?

A

One entity occurrence does not require a corresponding entity occurrence in a particular relationship

30
Q

What is mandatory participation?

A

One entity occurrence requires a corresponding entity occurrence in a particular relationship

31
Q

What does a relationship degree do?

A

It indicates the number of entities or participants associated with a relationship

32
Q

What is a unary (recursive) relationship?

A

Association is maintained within a single entity

33
Q

What is a binary relationship?

A

Two entities are associated

34
Q

What is a ternary relationship?

A

Three entities are associated

35
Q

What kind of relationship is found in a unary relationship?

A

A relationship can exist between occurrences of the same entity set

36
Q

What is a pitfall when working with unary relationships?

A

One common pitfall when working with unary relationships is to confuse participation with referential integrity

37
Q

What are associative entities?

A

Used to represent an M:N relationship between two or more entities
Has a 1:M relationship with the parent entities
Composed of the primary key attributes of each parent entity
May also contain additional attributes that play no role in connective process

BTM 382 (6 decks)

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