Based on the table structures and business rules, match the following questions with the correct answers. Your answers should be in coordination with concepts discussed in Chapter$-6.$ You will drag column A to column B Jonny removed City and State from the Location table and added a linked Zip table$\mathrm{.}1$NF$-$compliant database structure.The existing Supplier table is in violation of$?$Eliminate the Repeating Groups and create a new Location table with unique rows.To achieve $3$NF$--$compliant database structure, Jonny should eliminate:If each value of A determines one and only one value of B$.$A functional dependence criterion is f