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

Which type of relationship exists when a record in one table can relate to multiple records in another table, and vice versa?
ACID properties in DBMS ensure:
In a relational database, what is a candidate key?
In the context of computer networks, what is the primary function of a router?
Which normal form removes partial dependency?
In database management, what is a 'foreign key'?
Given the `SinglyLinkedList` and its `delete_node` method as provided, what will be the output of `my_list.print_list()` after the following sequence of op...
Which system call is used to create a new process in UNIX/Linux?
In a program that manages a collection of `Employee` objects, each with a `salary` attribute, which control flow mechanism would be most efficient to find ...
Which SQL command is used to retrieve data from a table?

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