The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
+3 votes

asked in Databases by Active (1.2k points) | 354 views
Answer is 4??

4 Answers

+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.
answered by Junior (581 points)
edited by
@pradeepdeepu why can't we combine the table 3 and table 4 since the database need to satisfy just 1NF.
+1 vote
I think we need 5 tables. 3 for 3 entities, 1 for multivalued attribute and another for the Loans relationship.
answered by (241 points)
" another for the Loans relationship " ?? not able to understand this....
+1 vote

4 table is required

answered by Boss (24.2k points)
for multivalued dependency how many table more required?

1 more table, right?
1 extra is required for satisfying 2NF and above but for 1NF we need just 3 tables.
0 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:

Another good read:

answered by Loyal (8.4k points)

Related questions

+1 vote
1 answer
asked Dec 30, 2016 in Databases by chaser (435 points) | 238 views
+7 votes
3 answers
0 votes
0 answers
0 votes
2 answers
asked Dec 26, 2017 in Databases by ashish pal Active (1.2k points) | 156 views

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

44,161 questions
49,646 answers
65,809 users