Question

A 'Dependent' entity (e.g., an employee's dependents) has no standalone primary key and always depends on 'Employee' for identification. When converting this weak entity to a relational table, what must be included in its primary key?

Q: Answer-A 'Dependent' entity (e.g., an employee's dependents) has no standalone primary key and always depen...

A weak entity cannot be uniquely identified by its own attributes alone. Its relational tables primary key must combine its partial key with the primary key of the owning strong entity it depends on for identification.

A An auto-generated surrogate key unrelated to the owning entity

B A composite key consisting of the weak entity's partial key plus the primary key of its owning strong entity (Employee)

C The primary key of the owning entity alone, without the weak entity's partial key

D No primary key is needed since weak entities are optional in relational schemas

E Only the weak entity's own partial key, since foreign keys are never part of primary keys

Practice Next

More IT DBMS Questions

In a database with a foreign key constraint defined using "ON DELETE CASCADE," what happens when a row in the parent (referenced) table is deleted?
Relation R(Student, Course, Hobby) stores every course a student takes and every hobby they have, independently of each other, producing a full cross-produ...
Bitmap indexes are most efficient when:
What will be the output of the following Python code: a=[1,2,3,4,5,6] print(a[-1],a[-1:],a[:-1])
What is the maximum number of processes that can be in the Ready state?
Distributed transactions typically use which protocol for atomicity?
The command to test reachability of a host in Linux is:
What is context switching?
When implementing a `Graph` traversal algorithm like Depth-First Search (DFS) recursively, what is the primary control flow mechanism that manages the orde...
A relation R(A, B, C, D, E) has candidate key {A, C}, with functional dependencies A -> B, BC -> D, and D -> E holding. What is the highest normal form tha...

Hey! Ask a query

🎓

Think You're Ready for RBI Grade B?

RBI Grade B 2026 Phase 1 Memory Based Paper

200 Questions with Detailed Solutions
Section-wise Coverage (GA, English, Quant & Reasoning)

Download Now 100% Free PDF

A 'Dependent' entity (e.g., an employee's dependents) has no standalone primary key and always depends on 'Employee' for identification. When converting this weak entity to a relational table, what must be included in its primary key?

Detailed Solution

More IT DBMS Questions

Hey! Ask a query

Please Register/Login

RBI Grade B 2026 Phase 1 Memory Based Paper