Have any queries? send us an email
A relational database management system of a bus company includes the following tables: BUS (bus-code, bus-type, departure-station, destination-station) JOURNEY (bus-code, driver-id, date, departure-time, arrival-time, duration, driver-bonus) DRIVER (driver-id, name, job-type, salary) Write SQL queries for the following: (i) List information about buses to ESHER. (2 marks) (ii) List details of buses which depart from KINGSTON and are destined for HOOK. (2 marks) (iii) Find the salary and driver-bonus for all drivers with job-type ‘Senior Level’. (2 marks) (iv) Find the name, salary and driver-bonus of drivers who are scheduled to drive bus R70. (2 marks) (v) Find the names of drivers who work on both bus 281 and on bus 465. (3 marks) (Total 11 marks) 3. Consider the Computer Equipment Rental form shown below. This form is used by departments to rent computer equipment. Various pieces of equipment can be rented over a period of days and each rental is processed by an administrator. The department is charged a cost of each rental.