17 Questions
At least two professors must be qualified to teach each ______.
course
Each professor must be qualified to teach at least one ______.
course
Figure 2-15a and 2-15b Multivalued attributes can be represented as ______.
relationships
Figure 2-11a A ______ relationship with an attribute.
binary
Figure 2-13c An associative entity – bill of materials ______.
structure
Figure 2-18 Cardinality constraints in a ternary ______.
relationship
A composite attribute is broken into ______ parts
component
A multivalued attribute may take on more than one value for a given entity instance, while a derived attribute can be calculated from related attribute values and is not physically stored in the database. (______/False)
True
In a binary relationship, ______ entities are related to each other
two
The degree of relationships refers to how many entities are related to each other. It can be one entity related to another entity of the same type, or entities of ______ different types related to each other
three
A unary relationship involves ______ entity
one
Cardinality constraints define the number of instances in a relationship. In a mandatory cardinality, a patient history is recorded for ______ patient
one
In a binary relationship, the ______ specifies how many of each entity type is allowed
relationship cardinality
A good business rule focuses on defining the interactions between ______
entities
The degree of relationships specifies the number of ______ types involved
entity
An entity that is also a relationship is a ______ entity
strong
Unary relationships involve ______ entity type
one
Learn about composite attributes, which break down the address into component parts. Understand multivalued attributes that can have more than one value for a given entity and derived attributes that are calculated from related attribute values. Explore examples like an entity with multivalued attribute (Skill) and derived attribute (Years Employed).
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free