$4.$Consider the table: one

S# STATUS STATE CODE CITY P# QUA..

Anderson $20$ PE $100$ Philadelphia car $300$

Peterson $30$ OR $150$ Portland fruits $200$

Johnson $10$ NY $200$ New York printers $300$

Johnson $10$ NY $200$ New York computers $500$

Smith $40$ TX $310$ Houston fruit $600$

Smith $30$ OR $150$ Portland fruit $300$

a$.$ What is the NF$?($explanation$),$ Please, give the key?

b$.$ What are the drawbacks of using it$?$

c$.$ Can it be simplified $?$ give the new NFs $,$ BCNF$?$ And please explain how we can take the information? Give details