Exam 7: Data Modeling With Entity Relationship Diagrams

Instead of storing a person's age, it is better to store the date of birth and use the difference between that value and the system date as a(n) ____________________ attribute.

(Short Answer)

4.7/5

(26)

Question 41

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) ____________________ on the side of the optional entity.

(Short Answer)

4.8/5

(29)

Question 42

The Crow's Foot notation depicts the strong relationship with a(n) ____________________ line between the entities.

(Short Answer)

4.9/5

(36)

Question 43

In the ERD, cardinality is indicated using the ____ notation.

(Multiple Choice)

4.8/5

(34)

Question 44

Explain multivalued attributes, and provide an example. How are multivalued attributes indicated in the Chen model? How are they indicated in the Crow's Foot model?

(Essay)

4.8/5

(31)

Question 45

Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

(Multiple Choice)

4.7/5

(30)

Question 46

Relationships operate only in one direction.

(True/False)

4.8/5

(41)

Question 47

Knowing the ____ number of entity occurrences is very helpful at the application software level.

(Multiple Choice)

4.9/5

(38)

Question 48

In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.

(Short Answer)

4.8/5

(44)

Question 49

The following step occurs first in the process of building an ERD: ____.

(Multiple Choice)

4.8/5

(36)

Question 50

____ attributes can have many values.

(Multiple Choice)

4.7/5

(42)

Question 51

Derived attributes are stored in a special database table.

(True/False)

4.9/5

(29)

Question 52

____________________ not only helps you stay on track during the design process, it also enables you and your coworkers to pick up the design thread when the time comes to modify the design.

(Short Answer)

4.8/5

(29)

Question 53

The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

(Multiple Choice)

4.8/5

(35)

Question 54

Some attributes are classified as ____.

(Multiple Choice)

4.7/5

(29)

Question 55

When indicating cardinality, the first value represents the ____________________ number of associated entities.

(Short Answer)

4.8/5

(31)

Question 56

Explain single-valued attributes and provide an example. Is an attribute that is single-valued always simple? Why or why not? Use an example to illustrate your point.

(Essay)

4.9/5

(35)

Question 57

The word "entity" in the ER model corresponds to a table.

(True/False)

4.8/5

(33)

Question 58

If the focus is on data-retrieval speed, you might also be forced to include ____ attributes in the design, which would not ordinarily be done.

(Multiple Choice)

4.9/5

(26)

Question 59

A ____ relationship exists when two entities are associated.

(Multiple Choice)

4.9/5

(40)

Question 60

Showing 41 - 60 of 100

Instead of storing a person's age, it is better to store the date of birth and use the difference between that value and the system date as a(n) ____________________ attribute.

In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n) ____________________ on the side of the optional entity.

The Crow's Foot notation depicts the strong relationship with a(n) ____________________ line between the entities.

In the ERD, cardinality is indicated using the ____ notation.

Explain multivalued attributes, and provide an example. How are multivalued attributes indicated in the Chen model? How are they indicated in the Crow's Foot model?

Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

Relationships operate only in one direction.

Knowing the ____ number of entity occurrences is very helpful at the application software level.

In the relationship "EMPLOYEE claims DEPENDENT" the DEPENDENT entity is ____________________ on the EMPLOYEE entity.

The following step occurs first in the process of building an ERD: ____.

____ attributes can have many values.

Derived attributes are stored in a special database table.

____________________ not only helps you stay on track during the design process, it also enables you and your coworkers to pick up the design thread when the time comes to modify the design.

The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity.

Some attributes are classified as ____.

When indicating cardinality, the first value represents the ____________________ number of associated entities.

Explain single-valued attributes and provide an example. Is an attribute that is single-valued always simple? Why or why not? Use an example to illustrate your point.

The word "entity" in the ER model corresponds to a table.

If the focus is on data-retrieval speed, you might also be forced to include ____ attributes in the design, which would not ordinarily be done.

A ____ relationship exists when two entities are associated.

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Interacting With Databases Through the Web

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters