Creating a trigger, function and a procedure in SQL

[rakesh-the gilli]

Hi,

I have 3 tables namely,

1) Vehicle (vehid, vehno, type, seats, status)
2) Driver (drid, dname, phno, address, status)
3) Hiring (hid, hdate, vehid, drid)

How can i create a trigger that checks the status of vehicle and driver for hiring
How to create a function that returns the number of vehicles that are available for hiring and
How to create a procedure which prints the hiring information with corresponding vehicle and driver information.

 

[Vyom]

This is not "complete your homework" forum.
It's best if you try them on your own after reading some sample triggers/functions and then ask your queries by posting what you think should work.