Hi, Please refer to pictures for the details of the questions, Many Thanks

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. Customer Purchase History Customer Name: Gender Male Address: Simon Jackson Blk 252 Ang Mo Kio Ave 4 Singapore 560252 (065)-98423838 Date of Birth: 25/7/1960 Mobile: Credit Limit: $20,000 Artist ID Artist Name Art Title Art Type 1 54 26 1 21 54 James Arthur Sam Smoth Florine D James Arthur Macallen Sam Smoth The Tigers Says Sorry The Finders Within Me You Stay The Tigers Says Sorry Single Malt The Keepers Limited Edition Gold Edition Platinum Limited Edition Platinum Gold Edition Date of Purchase Purchase Price 20/1/2015 $500 15/5/2017 $800 25/7/2018 $2,000 5/8/2019 $700 5/8/2019 $5,000 8/8/2020 $1,400 Figure 2. Customer Purchase History Report 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) Insert (at least) 10 sample rows for each identified table. (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