Kaplan Gallery Pte Ltd (KGPL) is developing a new transactional Ecommerce website focused on buying and selling of online digital art. The website will list all the artists and their arts. Customers can buy from KGPL and later sells it back to KGPL, who then will relist them on their webstore for other interested clients. KGPL 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 1 show the report layout.

Figure 1. Client History Report

Please complete the following FOUR (4) parts:

1. Based on Figure 1, write down the unnormalised form.

(5 marks)

2. Identify the repeating group of attributes and transform part (i) into tables that are in 1^st Normal form. (Explain the rationale for your decision).
   10. marks)

3. 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)

4. 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)

(Please clearly state all assumptions and ensure that you have sufficient annotations).