retagged by
808 views
1 votes
1 votes

Image result for total participation in dbms

min no. of tables ?

(participation of dependent is total)

retagged by

2 Answers

2 votes
2 votes

Dependent is weak entity, pname a partial key and employees is owner entity. so it will include primary key of owner entity and also as it have total participation so cost will go with dependent. Thus 2 tables Dependent(Pname,age,cost,ssn) Employees(ssn, name, lot).

Related questions

1 votes
1 votes
1 answer
2
aditi19 asked Jun 7, 2019
1,849 views
How to represent referential integrity constraint in ER model?pls explain with diagram
0 votes
0 votes
2 answers
3
kd..... asked Apr 26, 2019
776 views
Here if check_txn contains its own attributes then during converting into a relational model where does its attributes will be placed either in account side ( strong enti...
0 votes
0 votes
0 answers
4
_Bash_ asked Apr 4, 2019
437 views
What is the correct answer of this Question and what are the Minimized tables ???