John Deere Interview Question

Joins and types ,normalization,oops concepts