Using any dialect of SQL, please complete the following SEVEN (7) parts: Introduction to Database, Design and Development Assignment, SMU, Singapore

Question 3
Using any dialect of SQL, please complete the following SEVEN (7) parts:
i) Draw an entity-relationship diagram of the identified tables (3NF) in Question 2.
ii) Using the CREATE TABLE in any dialect of SQL, create the corresponding SQL tables. Indicate the primary key, foreign keys, column names, constraints etc.
iii) Insert (at least) 10 sample rows for each identified table.
iv) List the names and phone numbers of all clients who have a credit limit > $1,000 in alphabetical order. (5 marks)
v) Find the total price (before tax) for all the treatments for a particular client.
vi) List the cheapest treatment price for a particular client.
vii) List the clients and their pet(s) sorted by client’s gender.
(Please ensure that you include the screen capture for each part – marks will be deducted if you do not provide evidence of execution).