Project 1

ER DIAGRAM ATTATCH BELOW...!!

TASK 3

1.

SELECT cust_city
FROM customer
ORDER BY customer_id;

2.

ALTER TABLE PRoduct
RENAME ID TO prod_ID,
RENAME Name IF EXISTS TO prod_Name;

3.

select c.* from customers c, orders o, order_details od
where c.customer_id = o.customer_id
and o.order_id = od.order_id
group by od.order_id having count(od.item_id) > 1;

4.

SELECT *
FROM Employee
WHERE Name LIKE A%;

6.

CREATE [ OR ALTER ] TRIGGER [ table_name . ]trigger_name
ON { table | view }
[ WITH <dml_trigger_option> [ ,...n ] ]
{ FOR | AFTER | INSTEAD OF }
{ [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS { sql_statement [ ; ] [ ,...n ] | EXTERNAL NAME <method specifier [ ; ] > }