3. only keep prefered form and it's normalized equivalent, using inner join of streams