(1) Explain the purpose of data normalization and describe the main steps in the normalization process. ( 3 Marks) (2) A professional association in the Niagara Region would like to develop a database to maintain data about its members. The Association collects the data indicated in the following table on each member. MEMBERS As a requirement, the resulting database should let users be able to search the database using the first or last name of a member, list members who reside in a particular city, say Thorold, or by street name, etc. As part of the design process, normalize the table by answering the following questions: b) Identify the functional dependencies among the attributes represented in the table shown above. State any assumptions you make about the data shown in this table (if necessary). (2 Marks) c) Using the functional dependencies identified in part (b), describe and illustrate the normalization processes by converting the above table into the 1NF, 2NF and 3NF. Identify the primary and foreign keys correctly. (4 Marks)