Exercise #15 |
||
Find the hard drive sizes that are equal among two or more PCs. Result set: hd. A superficial knowledge of data structure is the reason of incorrect solution: Solution 1.11.1
This query extracts those PCs for which an another model of PC with same size of hard drive exists. The mistake is in the intuitive notion of the model uniqueness in the PC table. However, as was mentioned early, a model numbers are unique only in Product table. But here a numbers can be not unique. So, the query is wrong because the same models with same hard drive size are not taken into account. |