In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer?

EduRev

All Courses

Explore Courses UPSC Exam UPSC Test Series Free Notes EduRev Infinity

Open App

GATE Exam > GATE Questions > In ER models, which statement is not valid?a...

Join the Discussion on the App

In ER models, which statement is not valid?

a)
Entity attributes has more than single value
b)
Entity attributes appears composite
c)
Row attribute in relational table has more than single value
d)
Row attribute in relational table has a NULL value

Correct answer is option 'C'. Can you explain this answer?

FREE This question is part of

Practice Test: Computer Science Engineering (CSE) - 13

Attempt Test

Attempt this Test

Verified Answer

In ER models, which statement is not valid?a)Entity attributes has mo...

It is seen that in ER model, entity is present in ER model while relational table is available in Relational Model. From above options we see that option (A) and option (B) are true as ER model supports multi valve and composite attributes, with this we see that option (C) is false. In case of option (D) we see that this option is true as an entry in the relational table has exactly one NULL value.

View all questions of this test

View all answers Start learning for free

< Previous Question Next Question >

Explore Courses for GATE exam

Similar GATE Doubts

Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?

View answer

An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which of the following conditions, can the relational table for R be merged with that of A?

View answer

Consider a relation R related to 7 entities E1,E2…..E7 respectively, each of them has 2 attributes (A,B) (C,D) (E,F) (G,H) (I,J) (K,L) (M,N) with first attribute as candidate key in all entities. All entities are related to R with one-one mapping. What is the number of candidate keys possible for R

View answer

Consider the productions A → PQ and A → XY. Each of the five non-terminals A, P, Q, X and Y has two attributes: s is a synthesized attribute, and i is an inherited attribute.Consider the following rules.Rule 1:P.i = A.i + 2, Q.i = P.i + A.i and A.s = P.s + Q.sRule 2:X.i = A.i + Y.s and Y.i = X.s + A.iWhich one of the following is TRUE?

View answer

Consider a relation R(A B C) with attribute size of A as 8 bytes. Disk block size is 512 bytes and block pointer is 8 bytes. The best choice for degree (maximum valu e) for B+ tree, if B+ tree was used for creating indexing on R(A B C) is _________. Correct answer is '32'. Can you explain this answer?

View answer

In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer?

Share with a Friend

Answer this doubt

Question Description
In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer? for GATE 2024 is part of GATE preparation. The Question and answers have been prepared according to the GATE exam syllabus. Information about In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer? covers all topics & solutions for GATE 2024 Exam. Find important definitions, questions, meanings, examples, exercises and tests below for In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer?.

Solutions for In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer? in English & in Hindi are available as part of our courses for GATE. Download more important topics, notes, lectures and mock test series for GATE Exam by signing up for free.

Here you can find the meaning of In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer? defined & explained in the simplest way possible. Besides giving the explanation of In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer?, a detailed solution for In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer? has been provided alongside types of In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer? theory, EduRev gives you an ample number of questions to practice In ER models, which statement is not valid?a)Entity attributes has more than single valueb)Entity attributes appears compositec)Row attribute in relational table has more than single valued)Row attribute in relational table has a NULL valueCorrect answer is option 'C'. Can you explain this answer? tests, examples and also practice GATE tests.

Explore Courses for GATE exam