Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answering the questions using the database provided with the SQL statments a)List the callsID and destination phone number of calls made in 2006 whose duration

image text in transcribed

Answering the questions using the database provided with the SQL statments

a)List the callsID and destination phone number of calls made in 2006 whose duration was greater than 150.

b) As in query a) plus show the calling mobiles phone number.

c) As in query b) plus show the calling customers full name.

d) As in query c) except select only calls made on Saturday or Sunday (weekend) and show the cost of the call.

e) List all the pink mobile phones that are currently active and are on the Yes10 plan. Show the customer ID, customer's full name, phone number, joined date and the brand name of phone and the connection fee for the mobile.

f) Show a list of the tower usage. Display the tower ID and the number of calls connected through each tower, the location and the maximum connections

g) Show the full name and sex of each staff member and the name and sex of their supervisor (Hint: self join)

h) Display the full names of customers that have not bought any mobile phones. (Hint: outer outer join).

staff staffID customer customerID surname given Name dob calls callID mobileID phoneNumber callDate callDuration surname tower towerID location bandwidth maxConn connection connectID tower ID callID givenName sex mobile mobileID phone Number brandName joinDate cancelDate planName phoneColour customerID staffID sex phoneHome phone Work phone Fax address suburb state postcode joinDate resignDate address suburb postcode phone supervisorID commission rate PerHour plan planName connectFee peakFee offPeakFee weekendFee Entity-Relationship Diagram customer superv Dses plan Gas mobile staff call ses tower

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts

Authors: David M Kroenke, David J Auer

6th Edition

0132742926, 978-0132742924

More Books

Students also viewed these Databases questions

Question

=+5 How does HRM relate to efforts to increase innovation?

Answered: 1 week ago