Answer Happy

2. Draw ERD (Entity Relationship Diagram) for your database,
preferably in WORD. For example, you can use the prototype in
Chapter 7 (section 7.2, figure 7.1), including their relationships.
(30 pts)

3. Implement your database in MySQL. (20 pts)

- First, create 3~5 tables in MySQL (at least 5 fields for
each table)

- Populate data into each table (at least 10 rows for each
table).

4. Write/Run the SQL statements (at least 8 queries, 30 pts)

For example, if you use Chapter 7 example:

- Show all customer information whose balance is greater than
$1,000.

- Show all vendor information with vendor contact information in an
upper case like "SMITH".

- Show the customer balance in total, on average, in minimized and
in maximized value.

- Aggregate the total cost of products grouped by V_CODE, and only
show the records with a total exceeds $500, and list the records in
descending order in total cost.

- Join the PRODUCT table and VENDOR table on V_CODE.

- Show all records from PRODUCT that price is above the average
price.