??? What does this have to do with Normalization???
There is not such thing as a one-table database that is normalized.
SELECT DISTINCT t1.name, t1.surname, t2.surname AS usedAsFlag
FROM table AS t1
LEFT JOIN ( SELECT name, surname FROM table
WHERE car = 'bmw' ) AS t2
ON t1.name = t2.name
AND t1.surname = t2.surname
HAVING usedAsFlag IS NULL