Consider following relational database: Account(ac_no, type, balance, branch) Customer(cid, name, address, phone_no, dob) Depositer(ac_no, cid, date)…
BBA Database Management System · 2023 · Solved Question with Answer
Consider following relational database:
Account(ac_no, type, balance, branch)
Customer(cid, name, address, phone_no, dob)
Depositer(ac_no, cid, date)
Write SQL statement for the following:
i) Insert a tuple {1001, checking, 30000} in Account relation.
ii) Delete those accounts which haven't owns any customer.
iii) Change the phone_no of Ram to 11111111.
iv) Find name of customer who owns an account with balance greater than 2000.
v) Display those records of customers whose name starts with "R" and end with "A".