What is the difference between a weak and a strong entity in terms of relationships?
- A strong entity always has a primary key, while a weak entity does not
- A strong entity is not involved in relationships, while a weak entity can participate
- A weak entity always has a primary key, while a strong entity does not
- A weak entity is not involved in relationships, while a strong entity can participate
The key distinction lies in the presence of a primary key. A strong entity always has a primary key, while a weak entity relies on a partial key and requires the association with a strong entity for identity. Weak entities lack independence and rely on a strong entity for survival.
Loading...
Related Quiz
- Scenario: A university has students and courses. Each student can enroll in multiple courses, and each course can have multiple students enrolled in it. What type of entity would you introduce to represent the relationship between students and courses in an ERD?
- How does the concept of slowly changing dimensions (SCD) relate to fact tables?
- _______ data partitioning involves dividing data based on ranges of a specific attribute.
- Scenario: During the development of a new database application, the requirements undergo frequent changes. How can the team utilize Forward and Reverse Engineering processes to adapt to these changes efficiently?
- ER diagram tools enable users to create visually appealing _______.