Caterpillar interview question

Basic Array questions. Oops ,DBMS(normalisation,keys),project explanation.