Correct option is D
The statement that is incorrect is
(d). A weak entity does not depend on a foreign key that uniquely identifies it in the database. Instead, a weak entity is identified by a combination of its attributes and the primary key of a related strong entity.
Important Key Points:
1.
Weak Entity:
· Dependent on a strong entity to have a meaningful existence.
· Does not have a primary key of its own.
· Identified by a combination of its own attributes and the primary key of a related strong entity.
· Used to represent entities that cannot be uniquely identified without another entity.
2.
Primary and Foreign Keys:
·
Primary Key: Uniquely identifies each record within its own table.
·
Foreign Key: References the primary key in another table but does not uniquely identify the weak entity on its own.
Knowledge Booster:
·
Example of Weak Entity: Consider a database for a university, where "Course" is a strong entity with a primary key CourseID, and "Student" is a weak entity that cannot be uniquely identified without the CourseID. The "Student" entity may have an attribute like StudentID, but StudentID combined with CourseID uniquely identifies each student enrolled in a specific course.