1,578 views

3 Answers

2 votes
2 votes

Four tables are required

Child(name,age,gender,ssn)

Dept(Did,dname,address,ssn)

Works(ssn,Did)

Emp(ssn,Ename,rating)

0 votes
0 votes

Three tables for three entities. For 1:N relationship no separate table is made. Below images might help. Any specific notation in your question that you don't understand?

 

Related questions

0 votes
0 votes
1 answer
1
1 votes
1 votes
1 answer
3
Na462 asked May 12, 2018
1,358 views
The number of minimum Relations which satisfy 1NF _________. (Partial participation between E1 and R should not lost in RDBMS design).Please explain every point in detail...