CIS 1200 - Ch 4

True or False: A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.

False

True or False: All simple attributes are also single-valued.

False

True or False: In Chen notation, there is no way to represent cardinality.

False

A ____ should be a derived attribute. Question options: person's name person's age person's social security number person's phone number

person's age

A ____ relationship exists when an association is maintained within a single entity. Question options: unary ternary binary weak

unary

In an ER diagram, primary keys are indicated by ____. Question options: bolding italics underlining a special font

underlining

A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. Question options: strong weak business relationship

weak

True or False: An ERM is dependent on the database type.

False

True or False: Attributes have a domain that specifies the data type of the attribute.

False

True or False: In an ER diagram, primary keys are usually bolded.

False

A ____ relationship exists when three entities are associated. Question options: unary binary ternary weak

ternary

True or False: Relationships operate only in one direction.

False

True or False: The Crow's Foot model is less implementation-oriented than the Chen model.

False

True or False: The DBMS can easily handle multivalued attributes.

False

True or False: A composite identifier is a primary key composed of more than one attribute.

True

True or False: A relationship is identified by a name that describes the relationship.

True

True or False: A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship.

True

True or False: In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line.

True

True or False: The ER model refers to a specific table row as an entity instance.

True

True or False: The ER model refers to a specific table row as an entity occurrence.

True

A ____ attribute can be further subdivided to yield additional attributes. Question options: composite simple single-valued multivalued

composite

A ____ identifier is composed of more than one attribute. Question options: primary foreign composite domain

composite

The associative entity is also known as a ____ entity. Question options: unary weak strong composite

composite

The ERD represents the ____ database as viewed by the end user. Question options: condensed physical logical conceptual

conceptual

A derived attribute is indicated in the Chen model by a ____. Question options: single line dashed line circle double line

dashed line

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. Question options: multivalued composite weak derived

derived

Attributes may share a ____. Question options: name domain location table

domain

If an entity can exist apart from one or more related entities, it is said to be ____-independent. Question options: existence relationship business weak

existence

The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity. Question options: mandatory optional multivalued single-valued

mandatory

Knowing the ____ number of entity occurrences is very helpful at the application software level. Question options: maximum minimum approximate maximum and minimum

maximum and minimum

If Tiny College had some departments that were classified as "research only," they would not offer courses; therefore, the COURSE entity would be ____ to the DEPARTMENT entity. Question options: existence-dependent independent weak optional

optional

If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship. Question options: self self-referring looping recursive

recursive

Some attributes are classified as ____. Question options: simple complex defined grouped

simple

A ____ attribute can have only one value. Question options: composite simple single-valued multivalued

single-valued

Another word for existence-independent is ____. Question options: weak alone unary strong

strong