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

asked in Databases by (63 points) | 80 views
Answer is 4??

2 Answers

0 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 (327 points)
edited by
@pradeepdeepu why can't we combine the table 3 and table 4 since the database need to satisfy just 1NF.
0 votes
I think we need 5 tables. 3 for 3 entities, 1 for multivalued attribute and another for the Loans relationship.
answered ago by (103 points)

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

29,997 questions
37,681 answers
35,329 users