152 views
0 votes
0 votes
Full participation on "one " side of  one to many relationship

how many tables min required and what is foreign key ,primary key

1 Answer

1 votes
1 votes
Emp_id Emp_Name Dept_no As FK
E1 A D1
E2 B D1
E3 C D3
E4 D D2
E5 E D1
E6 F D2

(Department Entity) full participation 1 : N (Employee Entity)

Dept_no as PK Dept_name
D1 CSE
D2 IT
D3 MEC
D4 CHE

Two tables are required where Employee table attribute Dept_no is acting as FK and it is referring to Dept table (Dept_no).

Related questions

0 votes
0 votes
2 answers
1
Dipanshu Rana asked Oct 8, 2018
180 views
full participation on "many" side of one to many relation how many tables required and what will be pk,fk????
0 votes
0 votes
0 answers
2
Dipanshu Rana asked Oct 8, 2018
126 views
full participation on any " many" side in m:n mapping how many tables required and what will be pk,fk???
0 votes
0 votes
1 answer
3
KISHALAY DAS asked Oct 25, 2016
276 views
1 votes
1 votes
1 answer
4
KISHALAY DAS asked Oct 19, 2016
1,464 views
How can trainer id be p.key of Parts??