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?????????

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

## 5 Answers

Best answer

### 8 Comments

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.

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.

Option C is correct.

First Two options are related to ER Model and In E-R diagram we can have multi valued and composite attributes so those two options are correct.

Last Two options are related to Relational model

According to Relational Model every relation should be in 1NF and according to 1 NF, there should not be a multi-valued attribute in a relation. That means an attribute can have only one value or NULL value in a row. So statement of option C is incorrect