COURSE: DATABASE ENGINEERING

i) List the names of all buses with at least one journey priced below RM15.

ii) List the names of all destinations that do not have any buses.

iii) Find the number of buses going to Ipoh.

iv) List the name of the destination with the least price.

A relational database contains details about journeys from Kuala Lumpur to a number of destinations. BUS (BusCode, BusName) JOURNEY (BusCode, DesCode, Price) DESTINATION (DesCode, DesName, Distance) Each bus is assigned a unique code (BusCode) and a name. Each destination has a unique code (DesCode), a destination name (DesName) and the distance (Distance) of the destination from Kuala Lumpur. The relation JOURNEY records the price of an adult fare from Kuala Lumpur to the given destination by a specific bus; several buses may operate over the same route. Based on the relational schemas above, formulate the following queries using SQL and RA statement