Use SQL Management Studio to solve the Exam Question 1: Let supplier be a table with the following columns: supplier_no, article, city. The key of the table is the combination of the first two columns. Each supplier delivers several articles, and each article is delivered by several suppliers. There is only one supplier in each city. Answer the following questions: a. In which normal form is the supplier table? b. How can you resolve the existing functional dependencies