Podcast
Questions and Answers
A strong entity type always has a primary key that uniquely distinguishes each occurrence of that entity.
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.
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.
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.
The identifying owner is the weak entity type that depends on another entity.
Signup and view all the answers
A weak entity inherits its primary key entirely from its strong counterpart in the relationship.
A weak entity inherits its primary key entirely from its strong counterpart in the relationship.
Signup and view all the answers
EMPLOYEE is classified as a strong entity type and has Employee ID as its identifier.
EMPLOYEE is classified as a strong entity type and has Employee ID as its identifier.
Signup and view all the answers
A composite identifier is a primary key composed of only one attribute.
A composite identifier is a primary key composed of only one attribute.
Signup and view all the answers
Multivalued attributes in ER modeling can have many values associated with them.
Multivalued attributes in ER modeling can have many values associated with them.
Signup and view all the answers
An entity with a multivalued attribute should be implemented as is in a Relational Database Management System (RDBMS).
An entity with a multivalued attribute should be implemented as is in a Relational Database Management System (RDBMS).
Signup and view all the answers
Derived attributes in ER modeling must be physically stored within the database.
Derived attributes in ER modeling must be physically stored within the database.
Signup and view all the answers
Single-value attributes in ER modeling can have multiple values associated with them.
Single-value attributes in ER modeling can have multiple values associated with them.
Signup and view all the answers
In ER modeling, M:N relationships should not be implemented in the RDBMS.
In ER modeling, M:N relationships should not be implemented in the RDBMS.
Signup and view all the answers
A composite key is a primary key composed of only one attribute.
A composite key is a primary key composed of only one attribute.
Signup and view all the answers
Relationships between entities always operate in one direction only.
Relationships between entities always operate in one direction only.
Signup and view all the answers
A candidate key is a key that is unique but not minimal.
A candidate key is a key that is unique but not minimal.
Signup and view all the answers
Connectivity in ERD describes the relationship classification.
Connectivity in ERD describes the relationship classification.
Signup and view all the answers
An entity is said to be existence-independent if it can exist in the database without being associated with another related entity occurrence.
An entity is said to be existence-independent if it can exist in the database without being associated with another related entity occurrence.
Signup and view all the answers
Optional participation means that one entity occurrence requires a corresponding entity occurrence in a particular relationship.
Optional participation means that one entity occurrence requires a corresponding entity occurrence in a particular relationship.
Signup and view all the answers
A weak entity exists if the primary key of the related entity does not contain a component of the parent entity's primary key.
A weak entity exists if the primary key of the related entity does not contain a component of the parent entity's primary key.
Signup and view all the answers
Mandatory participation means that one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
Mandatory participation means that one entity occurrence does not require a corresponding entity occurrence in a particular relationship.
Signup and view all the answers
Entity instances in an ER model can only be associated with one other entity instance.
Entity instances in an ER model can only be associated with one other entity instance.
Signup and view all the answers
An alternate key is always chosen as the primary key in ER modeling.
An alternate key is always chosen as the primary key in ER modeling.
Signup and view all the answers
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
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
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.
