relationship on n-side while Employees entity participates in same
Chapter 14: Structuring Database for Accounting · ACCOUNTANCY · EN medium
From your actual textbook ✓
What does your textbook say about relationship on n-side while Employees entity participates in same?
relationship on -side. Therefore, the vouchers relation as already formed above in step , must also include as foreign key the primary key of Employees , which is EmpId . Similarly, we can deal with Prep.By relationship in which Employees and Vouchers again participate in binary :N relationship. The end result of mapping both these relationships is to include twice the EmpId , but in different roles. Since a relation cannot have same name (here EmpId twice to mean AuthBy and PrepBy ), we use their role names as attributes in Vouchers relation as foreign keys to reference Employees relation. Accordingly, the modified Vouchers relation appears as given below:
📖 Accounts 14 (1) · Page 26
Read from the source
Complete lesson
relationship on -side. Therefore, the vouchers relation as already formed above in step , must also include as foreign key the primary key of Employees , which is EmpId . Similarly, we can deal with Prep.By relationship in which Employees and Vouchers again participate in binary :N relationship. The end result of mapping both these relationships is to include twice the EmpId , but in different roles.
Since a relation cannot have same name (here EmpId twice to mean AuthBy and PrepBy ), we use their role names as attributes in Vouchers relation as foreign keys to reference Employees relation. Accordingly, the modified Vouchers relation appears as given below:
Related topics
Want this shaped for your exam marks?
Get an AI answer grounded in your actual textbook — with the exact page reference.
Ask AI about this topic →