This might help ....

The Gateway to Computer Science Excellence

First time here? Checkout the FAQ!

x

+18 votes

Given the basic ER and relational models, which of the following is **INCORRECT**?

- An attribute of an entity can have more than one value
- An attribute of an entity can be composite
- In a row of a relational table, an attribute can have more than one value
- In a row of a relational table, an attribute can have exactly one value or a NULL value

+26 votes

Best answer

0

y it is incorrect "In a row of a relational table, an attribute can have more than one value" then wts mean of multivalued attribute y it cnt state multivalued atribute?????????

+16

Multi-valued attribute is not possible in a relational table which means any relation in relational model is by default in 1NF.

0

then when multivalued attribute or wts use y we use such term please say bcz i search but didnt get satisfactory answer

+7

Say you have two phone numbers {981456234 and 345234981}. So, now phone number filed becomes multi-attribute. But in a relational model, this can't be stored in a single row. It will be stored as

Shimpy 981456234

Shimpy 345234981

But there can be other models like ER model where data can be represented as

Shimpy - {981456234 and 345234981} which is not in 1NF.

Shimpy 981456234

Shimpy 345234981

But there can be other models like ER model where data can be represented as

Shimpy - {981456234 and 345234981} which is not in 1NF.

0

so it imeans it is necessary tht ER model must be in 1 NF always??????????????????? & to make this condition we are making c incorrect???

+1 vote

The term ‘entity’ belongs to ER model and the term ‘relational table’ belongs to relational model.

A and B both are true. ER model supports both multivalued and composite attributes See this for more details.

(C) is false and (D) is true. In Relation model, an entry in relational table can can have exactly one value or a NULL.

A and B both are true. ER model supports both multivalued and composite attributes See this for more details.

(C) is false and (D) is true. In Relation model, an entry in relational table can can have exactly one value or a NULL.

- All categories
- General Aptitude 1.5k
- Engineering Mathematics 6.9k
- Digital Logic 2.7k
- Programming & DS 4.8k
- Algorithms 4.1k
- Theory of Computation 5.2k
- Compiler Design 2k
- Databases 3.9k
- CO & Architecture 3.4k
- Computer Networks 3.9k
- Non GATE 1.4k
- Others 1.5k
- Admissions 516
- Exam Queries 525
- Tier 1 Placement Questions 23
- Job Queries 67
- Projects 18

46,966 questions

51,293 answers

177,265 comments

66,644 users