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
