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

What is the primary objective of database normalization?
Which type of join returns only matching records from both tables?
Given a table Employees(EmpID, ManagerID, Salary), which SQL statement correctly returns the EmpID of every employee who earns strictly more than their dir...
When debugging a recursive function that processes a `Tree` data structure, what is a common strategy to identify infinite recursion or incorrect base case...
A transaction either executes all of its operations completely, or none of its operations take effect at all, leaving the database unchanged if any part of...
Which of the following is a type of database index?
Which SQL command permanently removes a table's entire structure along with all of its data from the database?
Which SQL keyword is used to combine the result sets of two or more SELECT statements, automatically removing duplicate rows from the combined result?
A relation is in 2NF if:
In ER modelling, a relationship in which the same entity type participates more than once, playing different roles in each occurrence (for example, an 'Emp...

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