Chapter 4 Flash Cards

Question 1

Binary Relationship

Answer 1

Two entities are associated.

Question 2

Cardinality

Answer 2

Expresses the minimum and maximum number of entity occurrences associated with one occurrence of related entity

Question 3

Composite Attribute

Answer 3

Attribute that can be subdivided to yield additional attributes.

Question 4

Composite Identifier

Answer 4

Primary key composed of more than one attribute.

Question 5

Connectivity

Answer 5

Describes the relationship classification. (1:1, M:N, 1:M)

Question 6

Derived Attribute

Answer 6

Attribute whose value is calculated from other attributes

Question 7

Existence-Dependent

Answer 7

Entity exists in the database only when it is associated with another related entity occurrence. AKA Strong Entity or Regular Entity.

Question 8

Existence-Independent

Answer 8

Entity exists apart from all of its related entities.

Question 9

Identifiers

Answer 9

One or more attributes that uniquely identify each entity instance.

Question 10

Iterative Process

Answer 10

Based on repetition of processes and procedures.

Question 11

Mandatory Participation

Answer 11

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

Question 12

Multivalued Attributes

Answer 12

Attributes that have many values. Need to create either several new attributes or a new entity composed of original multivalued attribute’s components.

Question 13

Optional Attribute

Answer 13

Does not require a value, can be left empty.

Question 14

Optional Participation

Answer 14

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

Question 15

Participants

Answer 15

Entities that participate in a relationship

Question 16

Recursive Relationship

Answer 16

Relationship exists between occurrences of the same entity set.

Question 17

Relational Schema

Answer 17

The organization of a relational database as described by the database administrator.

Question 18

Relationship Degree

Answer 18

Indicates the number of entities or participants associated with a relationship

Question 19

Required Attribute

Answer 19

Must have a value, cannot be left empty.

Question 20

Simple Attribute

Answer 20

Attribute that cannot be subdivided.

Question 21

Single-Valued Attribute

Answer 21

Attribute that has only a single value.

Question 22

Strong (Identifying Relationship) Relationship

Answer 22

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

Question 23

Ternary Relationship

Answer 23

Three entities are associated.

Question 24

Unary Relationship

Answer 24

Association is maintained within a single entity.

Question 25

Weak Entity

Answer 25

An entity that is existence-dependent and has a primary key that is partially or totally derived from parent entity in the relationship

Question 26

Weak (Non-Identifying Relationship) Relationship

Answer 26

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