This question has TWO (2) parts, part A relates to normalization and part B relates to SQL. Kaplin Art is a digital art shop focused on buying the best of computer art and design. Kaplin Art is developing a new website to sell their arts. The website will list all the artists and their arts. Customers can buy from Kaplin Art and later sells it back to Kaplin Art, who then will relist them on their webstore for other interested customers. Kaplin Art do not allow customer to sell to other customer on their website. One of the requirements of the new webstore is to maintain a list of their customers and what they have purchased. Figure 2 show the report layout. Page 2/3 Figure 2. Customer Purchase History Report Part A: 35 marks (Please clearly state all assumptions and ensure that you have sufficient annotations). Please complete the following FOUR (4) parts: i) Based on Figure 2, write down the unnormalized form. (5 marks) ii) Identify the repeating group of attributes and transform part (i) into tables that are in 1st Normal form. (Explain the rationale for your decision). (10 marks) iii) Identify any partial dependencies in part (ii) and transform into tables that are in 2 nd Normal Form. (Explain the rationale for your decision). (10 marks) iv) Identify any transitive dependencies in part (iii) and transform into tables that are in 3 rd Normal Form. (Explain the rationale for your decision). (10 marks) Part B: 35 marks (Please clearly state all assumptions and ensure that you have included the screen capture for each part marks will be deducted if you do not provide evidence of execution) Using any dialect of SQL, please complete the following SEVEN (7) parts: i) Draw an entity-relationship diagram of the identified tables in Part A. (5 marks) ii) Using the CREATE TABLE in any dialect of SQL, show the corresponding SQL tables. Indicate the primary key, foreign keys, column names, constraints etc. (5 marks) iii) Insert (at least) 10 sample rows for each identified table. Page 3/3 (5 marks) iv) List the names and phone numbers of all customers who have a credit limit > $10,000 in alphabetical order. (5 marks) v) Find the average purchase price of all the purchases for a particular customer. (5 marks) vi) List all the items with a price above the average price for a particular customer. (5 marks) vii) List the customer and art title that has been sold at least 2 times.