Introduction to Database, Design and Development Assignment, SMU, Singapore: Using any dialect of SQL, please complete the following SEVEN (7) parts
| University | Singapore Management University (SMU) |
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.
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
- MKTG1001 Foundations of Marketing Assignment 2 Individual Report | The University of Newcastle (UoN)
- S2010C Health and Wellness Graded Assignment AY2025 Term 4 – Republic Polytechnic (RP)
- RBP040L051 Postgraduate Dissertation Assessment brief – University of Roehampton Business School
- ACFI 2070 Business Finance Individual Assignment – The University of Newcastle (UoN)
- PY2107 Experimental Investigation and Analysis of Behaviour Assignment 2 Written – Research Report , James Cook University (JCU)
- ACCT111 Financial Accounting Individual Assignment, Singapore Management University (SMU)
- RM71003 Category Management & Merchandising Assignment 1 – Singapore Management University (SMU)
- Visual Arts Management Assignment 2 Essay Singapore Art Science Museum – Nanyang Academy of Fine Arts (NAFA)
- BM1987 Employment Law In-Course Assessment (ICA 1) Guide , Nanyang Polytechnic (NYP)
- MA3005/MA3705 Control Theory Coursework 2025-26, Nanyang Technological University (NTU)
