IndiaBIX

Database - Database Design Using Normalization - Discussion

Discussion Forum : Database Design Using Normalization - General Questions (Q.No. 20)
Database Design Using Normalization
20.
Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?
Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.
Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.
Three rows have the values Brown, NULL, and Blue in the same column.
One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
3 comments Page 1 of 1.
Atithi said:   1 decade ago
D is also not normalized value.
(1)
Sumit said:   9 years ago
Please explain.
(1)
Anjali S said:   7 years ago
D can be the answer but it's in double quotes and Sal treats it as single values.

But B is correct because there is no quotes which means that there are 3 values in a row which is not right.
(1)
Post your comments here:

Your comments will be displayed after verification.

Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers