1,248 views
3 votes
3 votes

4 Answers

2 votes
2 votes
I think we need  4 tables.

3 tables for 3 entities and one for multivalued attribute Ph_no in 1st entity.

table 1:  Code , Name, Addr .

table 2:  Code, Ph_no.

table 3:  Branch No, Code, Addr, Bank name

table 4:  Loan_no, amount, type, Branch No.
edited by
2 votes
2 votes

4 table is required

1 votes
1 votes
I think we need 5 tables. 3 for 3 entities, 1 for multivalued attribute and another for the Loans relationship.
1 votes
1 votes

3 tables are required since they have asked for 1NF. when given ER diagram is converted into a table, then every record contains atomic values. 

i.e. If a person has 2 phone & 2 office then that person will have 4 records, but then every record contains atomic values only. Thus relation is always in 1NF.

For 2NF and above we need 4 tables.

Read here: https://gateoverflow.in/29974/minimum-number-of-relation-for-given-er-diagram

Another good read: https://www.tutorialcup.com/dbms/er-model-into-tables.htm

Related questions

5 votes
5 votes
3 answers
3
Rohit Gupta 8 asked Nov 18, 2017
1,312 views
Consider the following E-R diagram: What is the minimum relations required which satisfied the 2nd normal form?A)1B)2C)3D)4