IT232 Database Management System

Database Management SystemTU Board 2023

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…

10

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".

A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.

Discussion

Loading…

More Database Management System questions

All Database Management System old questions