Consider following relational database: Car (reg_no, model, price, color) Person (pid, name, address, phone) owns_by(reg_no, pid, date) Write SQL…
BBA Database Management System · 2024 · Solved Question with Answer
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, 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.