Chapter 4- Relationships

Question 1

Stages of Database Development

Answer 1

1. Analysis Stage
2. Component Design Stage
3. Implementation Stage

Question 2

E-R Data Model Requirements

Answer 2

Entities
Attributes
Identifiers
Relationships

Question 3

A description of the structure and format of the occurrences of the entity

Answer 3

Entity Class

Question 4

A specific occurrence of an entity within an entity class

Answer 4

Entity Instance

Question 5

A single entity instance in one entity class is related to a single entity instance in another entity class

Answer 5

One-to-One (1:1)

Question 6

A single entity instance in one entity class is related to many entity instances in another entity class

Answer 6

One-to-Many (1:N)

Question 7

Many entity instances in one entity class is related to many entity instances in another entity class

Answer 7

Many-to-Many (N:M)

Question 8

Maximum number of entity instances that may participate in a relationship instance

Answer 8

Maximum Cardinality

Question 9

Minimum number of entity instances that must participate in a relationship instance

Answer 9

Minimum Cardinality

Question 10

Entity has a relationship to itself

Answer 10

Recursive Relationship

Question 11

An entity that cannot exist in the database w/o the existence of another entity.

Answer 11

Weak Entity

Question 12

Any entity that is not weak

Answer 12

Strong Entity

Question 13

A relationship b/w attributes in which one attribute (or group of attributes) determines the value of another attribute in the same table

Answer 13

Functional Dependency