Database Management SystemTU Board 2024
Consider following relational database: Car (reg no, model, price, color) Person (pid, name, address, phone) owns by(reg no, pid, date) Write SQL statement for the following: i) Insert a tuple 1,…
10Consider following relational database:
Car (reg_no, model, price, color) Person (pid, name, address, phone) owns_by(reg_no, pid, date)
Write SQL statement for the following: i) Insert a tuple {1, Ram Bdr, kathmandu} in person relation. ii) Display the model number with highest price. iii) Increase the price of each car by 15%. iv) Find name of person who owns red colored car. v) Display those records of car which model contains at most 4 characters.
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Mention any one difference between schemas and instances.TU Board 20251Define attribute inheritance.TU Board 20251List out any two data types used in SQL.TU Board 20251What is the importance of creating role?TU Board 20251Define Transitive dependency.TU Board 20251Write SQL query to remove an attribute named 'email' from Employee table.TU Board 20251