Awesome q2a theme
0 votes
14 views

Here as well as in Korth it is mentioned that , for EACH MULTIVALUED ATTRIBUTE we make separate table. But in many places it is said that all the multivalued attributes combiningly require only one table.

https://gateoverflow.in/162562/database-does-multivalued-attribute-requires-separate-table. This link has the same question but there it is said that both cases are possible.

https://gateoverflow.in/14517/er-diagram?show=14796. Here is a lot of confusion in discussion. 

Some questions related to this have no chosen answer and so difficult to rely upon:- https://gateoverflow.in/215439/interesting-question-on-er-diagrams?show=215447

https://gateoverflow.in/3717/gate2004-it-73?show=252817. Here in the best answer , FDs have been assumed from information that A11 is key. But without explicit mention of FDs how can we answer such question. I mean they have just said that A11 is key, so we know these FDS are there:- A11-->A12  A11-->A13 , But how do we know there arent any other FD like A12-->A13. Because if there is A12-->A13 then 3 tables wont be enough for 3NF

in Databases by (97 points) | 14 views

Please log in or register to answer this question.

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
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
8,675 questions
2,878 answers
13,796 comments
95,575 users