22 Questions
A strong entity type always has a primary key that uniquely distinguishes each occurrence of that entity.
True
A weak entity type can exist without a relationship with another entity.
False
A table with a foreign key that can contain nulls is considered a strong entity.
False
The identifying owner is the weak entity type that depends on another entity.
False
A weak entity inherits its primary key entirely from its strong counterpart in the relationship.
False
EMPLOYEE is classified as a strong entity type and has Employee ID as its identifier.
True
A composite identifier is a primary key composed of only one attribute.
False
Multivalued attributes in ER modeling can have many values associated with them.
True
An entity with a multivalued attribute should be implemented as is in a Relational Database Management System (RDBMS).
False
Derived attributes in ER modeling must be physically stored within the database.
False
Single-value attributes in ER modeling can have multiple values associated with them.
False
In ER modeling, M:N relationships should not be implemented in the RDBMS.
True
A composite key is a primary key composed of only one attribute.
False
Relationships between entities always operate in one direction only.
False
A candidate key is a key that is unique but not minimal.
False
Connectivity in ERD describes the relationship classification.
True
An entity is said to be existence-independent if it can exist in the database without being associated with another related entity occurrence.
True
Optional participation means that one entity occurrence requires a corresponding entity occurrence in a particular relationship.
False
A weak entity exists if the primary key of the related entity does not contain a component of the parent entity's primary key.
False
Mandatory participation means that one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
False
Entity instances in an ER model can only be associated with one other entity instance.
False
An alternate key is always chosen as the primary key in ER modeling.
False
Study Notes
Entity Types
- Strong entity type: has a unique characteristic (identifier) that distinguishes each occurrence
- Weak entity type: existence depends on another entity type (existence-dependent) and has a primary key partially or totally derived from the parent entity
- Examples: EMPLOYEE (strong), DEPENDENT (weak)
Entity Characteristics
- Attributes: represented by ovals connected to entity rectangle with a line (Chen notation) or written in attribute box below entity rectangle (Crow’s Foot notation)
- Required attribute: must have a value
- Optional attribute: may be left empty
- Domain: set of possible values for an attribute
- Identifiers: one or more attributes that uniquely identify each entity instance
- Composite identifier: primary key composed of more than one attribute
Attribute Types
- Composite attribute: can be subdivided (e.g., ADDRESS, PHONE_NUMBER)
- Simple attribute: cannot be subdivided (e.g., AGE, SEX, MARITAL_STATUS)
- Single-value attribute: can have only a single value (e.g., SERIAL_NUMBER)
- Multivalued attributes: can have many values (e.g., DEGREE)
- Derived attribute: value may be calculated from other attributes (e.g., EMP_AGE)
Relationships
- M:N relationships and multivalued attributes should not be implemented directly in the RDBMS
- Create a new entity composed of original multivalued attribute’s components
- Identifiers (Primary Keys): one or more attributes that uniquely identify each entity instance
- Foreign Key: attribute in a table that references the primary key in another table
- Association between entities: participants are entities that participate in a relationship
- Connectivity: describes the relationship classification
- Cardinality: expresses minimum and maximum number of entity occurrences associated with one occurrence of related entity
Existence Dependence
- Existence dependence: entity exists in database only when associated with another related entity occurrence
- Existence independence: entity can exist apart from one or more related entities
- Weak entity meets two conditions: existence-dependent, primary key partially or totally derived from parent entity in relationship
- Database designer determines whether an entity is weak based on business rules
Explore the concepts of strong and weak entity types in database management. Learn about unique identifiers, foreign keys, and the dependency of weak entities on other entity types.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free