Using any dialect of SQL, please complete the following SEVEN (7) parts: i) ii) iii) iv)...

Transcribed Image Text:

Using any dialect of SQL, please complete the following SEVEN (7) parts: i) ii) iii) iv) v) vi) vii) Draw an entity-relationship diagram of the identified tables (3NF) in Question 2. Using the CREATE TABLE in any dialect of SQL, create 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) List the names and phone numbers of all clients who have a credit limit > $1,000 in alphabetical order. (5 marks) Find the total price (before tax) for all the treatments for a particular client. (5 marks) List the cheapest treatment price for a particular client. List the clients and their pet(s) sorted by client's gender. (5 marks) (5 marks) (5 marks) Using any dialect of SQL, please complete the following SEVEN (7) parts: i) ii) iii) iv) v) vi) vii) Draw an entity-relationship diagram of the identified tables (3NF) in Question 2. Using the CREATE TABLE in any dialect of SQL, create 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) List the names and phone numbers of all clients who have a credit limit > $1,000 in alphabetical order. (5 marks) Find the total price (before tax) for all the treatments for a particular client. (5 marks) List the cheapest treatment price for a particular client. List the clients and their pet(s) sorted by client's gender. (5 marks) (5 marks) (5 marks)