Chapter 4 Quiz 3

Question 1

an attribute that must have a value

Answer 1

Required attribute

Question 2

an attribute that does not require value; therefore, it can be left empty

Answer 2

optional attribute

Question 3

one or more attributes to uniquely identify each entity instance

Answer 3

identifiers

Question 4

attributes are also underlined in a frequently used shorthand notation for the table structure called____

Answer 4

Relational schema

Question 5

a primary key composed of more than one attribute

Answer 5

composite identifier

Question 6

an attribute that can be further subdivided to yield additional attributes

Answer 6

composite attribute

Question 7

an attribute that cannot be subdivided

Answer 7

simple attribute

Question 8

an attribute that can have only a single value

Answer 8

single-valued attribute

Question 9

attributes that can have any values

Answer 9

multivalued attributes

Question 10

an attribute whose value is calculated from other attributes

Answer 10

derived attribute

Question 11

The entities that participate in a relationship are known as______

Answer 11

Participants

Question 12

_____ is used to describe the relationship classification

Answer 12

connectivity

Question 13

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

Answer 13

Cardinality

Question 14

an entity is said to be ______ if it can exist in the database only when it is associated with another related entity occurence

Answer 14

existence-dependent

Question 15

if an entity can exist apart from all of its related entities, then it is _____ and is referred to as a “_____”

Answer 15

existence-independent, strong entity

Question 16

a ______ exists if the primary key of the related entity does not contain a primary key component of the parent entity

Answer 16

weak relationship

Question 17

A______ exists when the primary key of the related entity contains a primary key component of the parent entity

Answer 17

Strong relationship

Question 18

a _____ exists when thee entity is existence-dependent and the entity has a primary key that is derived from the parent entity in the relationship

Answer 18

Weak entity

Question 19

_______ means that one entity occurrence does not require a corresponding entity occurrence

Answer 19

Optional participation

Question 20

______ means that one entity occurrence requires a corresponding entity occurrence in a particular relationship

Answer 20

Mandatory participation

Question 21

_____ indicated the number of entities or participants associated with a relationship

Answer 21

Relationship degree

Question 22

____ exists when an association is maintained within a single entity

Answer 22

unary relationship

Question 23

A ____ exists when two entities are associated

Answer 23

binary relationship

Question 24

A____ exists when three entities are associated

Answer 24

ternary relationship

Question 25

when a relationship is related to itself

Answer 25

recursive relationship

Question 26

an_____ is based on repetition of processes and procedures

Answer 26

Iterative process