Consider the given schema design for Department Store. Customer (c_id, C_Name, address, gender, age, phone, email, created_date) Product (pr_id,…
2024 · Solved Question with Answer
Consider the given schema design for Department Store.
Customer (c_id, C_Name, address, gender, age, phone, email, created_date)
Product (pr_id, P_name, product_price, mfg_date, exp_date)
Purchase (id, c_id, pr_id, qunatity, total_price, entered_by, entered_at)
a. Find the name and price of product whose name start from 'K' and end in 'T'.
b. Find the name of customer who purchases ‘Pen’.
c. Insert the record of new customer.
d. Delete the product ‘Pen’
e. Increaser the price of all product by 25%
f. Write DDL statement for creating above relation