WGU C175 - Lesson 4 : Quiz Blank/MC Only

_____ are characteristics of entities.

attributes

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

binary

A relationship _____ indicates the number of entities or participants associated with a relationship.

cardinality

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

circle

A _____ attribute can be further subdivided to yield additional attributes. A single-valued B multivalued C composite D simple

composite

A _____ attribute is an attribute that can be further subdivided to yield additional attributes.

composite

The entity relationship diagram (ERD) represents the _____ database as viewed by the end user. A conceptual B logical C physical D condensed

conceptual

The first step in building an entity-relationship diagram (ERD) is _____ . A identifying the business rules based on the description of operations B identifying the attributes and primary keys that adequately describe the entities C creating a detailed narrative of the organization's description of operations D developing the initial ERD

creating a detailed narrative of the organization's description of operations

A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity. A double dashed line B double line C single line D dashed line

dashed line

A(n) _____ attribute need not be physically stored within the database.

derived

The __________ attribute need not be physically stored within the database. A single-valued B derived C multivalued D composite

derived

A(n) _____ is the set of possible values for a given attribute. A key B identifier C range D domain

domain

A relationship is an association between _____. A entities B databases C fields D objects

entities

Knowing the minimum and maximum number of _____ occurrences is very helpful at the application software level. A entity B data C attribute D object

entity

A weak entity must be _____ dependent.

existence

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 data B business C relationship D existence

existence

In organizations that generate large number of transactions, _____ are often a top priority in database design. A relationships among entities B logical design standards C naming conventions D high processing speeds

high processing speeds

Complex _____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. A processing B information C entity D design

information

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

iterative

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

minimum

Ideally, an entity identifier is composed of _____ attribute(s). A six B three C one D two

one

Participation is _____ if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

optional

The existence of a(n) _____ entity indicates that its minimum cardinality is zero. A weak B ternary C optional D strong

optional

If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be _____ the DEPARTMENT entity. A independent of B existence-dependent on C optional to D mandatory for

optional to

The concept of relationship strength is based on how the _____ of a related entity is defined.

primary key

The Chen notation identifies a weak entity by using a double-walled entity _____.

rectangle

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a _____ relationship. A self B recursive C looping D self-referring

recursive

Identifying the attributes of entities helps in the better understanding of _____ among entities.

relationships

A(n) _____ attribute is an attribute that must have a value.

required

A _____ attribute is one that cannot be subdivided. A simple B single-valued C multivalued D composite

simple

A person's Social Security number would be an example of a(n) _____ attribute.

single valued

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

solid

When using the Crow's Foot notation, the associative entity is indicated by _____ relationship lines between the parents and the associative entity. A triple B solid C dotted D double

solid

A(n) _____ relationship is also known as an identifying relationship.

strong

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 unary B strong C weak D alone

strong

When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____. A images B attributes C symbols D tables

symbols

A _____ relationship exists when three entities are associated. A unary B strong C ternary D weak

ternary

A _____ relationship exists when an association is maintained within a single entity. A strong B weak C unary D ternary

unary

A _____ entity does not have sufficient attributes to form a primary key. A child B strong C weak D business

weak

The Crow's foot symbol with two vertical parallel lines indicates _____ cardinality. A (1,1) B (1,N) C (0,N) D (0,1)

(1,1)

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

Cardinality

_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity. A Dependence B Cardinality C Connectivity D Relationship

Cardinality

_____ 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.

Documentation

The conceptual model can handle _____ relationships and multivalued attributes. A 1:1 B 1:N C 1:M D M:N

M:N

The entity relationship model uses the associative entity to represent a(n) _____ relationship between two or more entities. A M:1 B M:N C 1:M D N:1

M:N

_____ are underlined in an ER diagram.

Primary keys

The _____ notation of entity-relationship modelling can be used for both conceptual and implementation modelling. A UML B Chen C Crow's Foot D Bachman

UML