Question: 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

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Consider the following relational schema: Staff ( staffNo , name, dept, skillCode) Skill ( skillCode , description, chargeOutRate) Project ( projectNo ,...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

A relational database contains details about journeys from India to a variety of destinations and contains the following relations: Operator (opCode, opName) Journey (opCode, destinationCode,price)...

Explain informally the difference between Godel's completeness theorem and his first incompleteness theorem. [8 marks] (b) State the meaning of Hoare triples {P} C {Q} in separation logic. [3 marks]...

Hi Sara Hope you are doing well. I need to prepare Ratio Analysis for eBay company and Amazon. I uploaded the most recent 10-K report for the most recent years, 2014 to 2016. Please let me know if...

Chapter 16 Passenger Transport Law INTRODUCTION 5 10 15 20 25 30 35 Transport law is a complex area of law covering the carriage (transport) of passengers and their luggage, as well as the carriage...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

AN ARBITRATOR'S DILEMMA: BULLYING OR SELF-PRESERVATION ? INTRODUCTORY NOTES According to Namie (2000), one in every five United States employees was bullied with repeated, deliberately harmful verbal...

Investigate how career development and career management works within the organization selected for the individual report section. Include any personal work experience if applicable. Discuss tools...

The following transactions pertain to Getrude Wangari for 2018 Jan 1 Began operations by depositing Sh. 500,000 in a bank account in the name of the business, Getrude Enterprise Mar 1 Paid three...

The most recent stages of the Evolution of Financial Technology have focused more on: Digitizing the processes of Banking and Payments Pushing the old, obsolete banking institutions out of business....

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Identify the necessary implementation strategies and practices to achieve success.

Discuss the more popular typologies of generic strategies and the various HRM practices associated with each. page 80

List the components of the strategic management process. page 72