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 Dipanshu Rana asked Oct 8, 2018 Dipanshu Rana 152 views answer comment Share Follow See 1 comment See all 1 1 comment reply tech_beardo commented Nov 16, 2019 reply Follow Share 1 Table will be enough. 0 votes 0 votes Please log in or register to add a comment.
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). Dharmendra Verma answered Oct 10, 2018 Dharmendra Verma comment Share Follow See all 0 reply Please log in or register to add a comment.