You work as a Database Designer for RealTech Inc. You have to design the database of a bank.
The database has two tables: Employee and Department.
The Employee table has the following attributes:
EmpID (PK)
DeptID (FK)
Name
DateOfBirth
Designation
The Department table has the following attributes:
DeptID (PK)
DepartmentName
DeptID is the primary key (PK) of the Department table, whereas, after migration, in the above
Employee table, it is the foreign key (FK). What does migration of the DeptID attribute to the child
table Employee ensure?
A.
It ensures atomicity.
B.
It ensures referential integrity.
C.
It ensures faster data retrieval.
D.
It ensures domain integrity.