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

Question 3

Using any dialect of SQL, please complete the following SEVEN (7) parts:

1  Draw an entity-relationship diagram of the identified tables (3NF) in Question 2.

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.

3 Insert (at least) 10 sample rows for each identified table.

4 List the names and phone numbers of all clients who have a credit limit > $1,000 in alphabetical order.

5 Find the total price (before tax) for all the treatments for a particular client.

6List the cheapest treatment price for a particular client.

7 List the clients and their pet(s) sorted by client’s gender.