Test 4 SU4 - Test 4 on SU4 PDF

Preview

Summary

Test 4 on SU4...

Description

Part 1 of 3 - True | False / 10.0 Points

Question 1 of 35

1.0 Points

The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1. True Fals e

Question 2 of 35

1.0 Points

The entity relationship model (ERM) is dependent on the database type. True Fals e

Question 3 of 35

1.0 Points

Connectivities and cardinalities are established by concise statements known as business rules. True Fals e

Question 4 of 35

1.0 Points

Relationships between entities always operate in one direction. True Fals e

Question 5 of 35

1.0 Points

The Crow's Foot notation easily identifies multivalued attributes. True

Fals e

Question 6 of 35

1.0 Points

An entity in the entity relationship model corresponds to a table in the relational environment. True Fals e

Question 7 of 35

1.0 Points

Composite attributes make it easier to facilitate detailed queries. True Fals e

Question 8 of 35

1.0 Points

In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first. True Fals e

Question 9 of 35

1.0 Points

In the entity relationship model, a table row (record) corresponds to an entity instance. True Fals e

Question 10 of 35

1.0 Points

In Chen notation, there is no way to represent cardinality. True Fals e

Part 2 of 3 - Multiple Choice / 15.0 Points

Question 11 of 35

1.0 Points

To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent _____ relationships whenever possible.



A. unary



B. binary



C. strong



D. weak

Question 12 of 35

1.0 Points

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship.



A. self



B. self-referring



C. looping



D. recursive

Question 13 of 35

1.0 Points

The conceptual model can handle _____ relationships and multivalued attributes.



A. 1:1



B. M:N



C. 1:M



D. 1:N

Question 14 of 35

1.0 Points

The Crow’s foot symbol with two vertical parallel lines indicates _____ cardinality.



A. (0,N)



B. (1,N)



C. (1,1)



D. (0,1)

Question 15 of 35

1.0 Points

The first step in building an entity-relationship diagram (ERD) is _____.



A. developing the initial ERD



B. creating a detailed narrative of the organization’s description of operations



C. identifying the attributes and primary keys that adequately describe the entities



D. identifying the business rules based on the description of operations

Question 16 of 35

1.0 Points

An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence.



A. existence



B. relationship



C. business



D. data

Question 17 of 35

1.0 Points

A(n) _____ is the set of possible values for a given attribute.



A. domain



B. range



C. identifier



D. key

Question 18 of 35

1.0 Points

In the entity relationship diagram (ERD), cardinality is indicated using the _____ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.



A. (max, min)



B. (min, max)



C. [min ... max]



D. {min|max}

Question 19 of 35

1.0 Points

A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.



A. single line



B. dashed line



C. double dashed line



D. double line

Question 20 of 35

1.0 Points

If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) _____ entity.



A. weak



B. alone



C. unary



D. strong

Question 21 of 35

1.0 Points

Database design is a(n) _____ process based on repetition.



A. sequential



B. iterative



C. linear



D. intermittent

Question 22 of 35

1.0 Points

When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.



A. symbols



B. attributes



C. images



D. tables

Question 23 of 35

1.0 Points

A relationship is an association between _____.



A. objects



B. entities



C. databases



D. fields

Question 24 of 35

1.0 Points

A _____ attribute is one that cannot be subdivided.



A. composite



B. simple



C. single-valued



D. multivalued

Question 25 of 35

1.0 Points

The entity relationship diagram (ERD) represents the _____ database as viewed by the end user.



A. condensed



B. physical



C. logical



D. conceptual

Part 3 of 3 - Fill in the Blank / 10.0 Points

Question 26 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. attributes are characteristics of entities.

Question 27 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. A weak entity must be existence -dependent.

Question 28 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. A person’s Social Security number would be an example of a(n) single-valued attribute.

Question 29 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks.

A(n) iterative process is based on repetition of processes and procedures.

Question 30 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. A(n) strong relationship is also known as an identifying relationship.

Question 31 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. The Chen notation identifies a weak entity by using a double-walled entity rectangle .

Question 32 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. A relationship degree indicates the number of entities or participants associated with a relationship.

Question 33 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. Documentation not only helps database designers to stay on track during the design process, it also enables them to pick up the design thread when the time comes to modify the design.

Question 34 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. Identifiers are underlined in an ER diagram.

Question 35 of 35

1.0 Points

What follows is a fill in the blank question with 1 blanks. Identifying the attributes of entities helps in the better understanding of relationships among entities....