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

asked in Databases by Active (1.3k points) | 203 views
Answer is 4??

2 Answers

+1 vote
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 (509 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 (225 points)
" another for the Loans relationship " ?? not able to understand this....

Related questions

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

33,709 questions
40,253 answers
38,875 users