Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 1: A certain telecom company issues calling cards of various denominations and types. The customer can buy a card and use them to make

image text in transcribed
image text in transcribed
Task 1: A certain telecom company issues calling cards of various denominations and types. The customer can buy a card and use them to make a call. The card can be renewed on expiration of the amount on the card. A customer can have more than one card in his account. The call duration, the card used for the call , the time of call are recorded. Review the data model below and answer the following questions : card master antomer telecom_operator Pand hor ENUM( ] Guld An DATEIN Warmand let off offerent calling cards walktly card denomina tion 1. Ropes 2 Premium Gold ontoner_cards when INT Master lot of all customer of the calling card company A calling and can have one or more A cullomen can have one or more +assand INT Pard d INT Call donate off the customer. (Many to Marg) Unemotional + 1- True. 9- Dominic cullen Q1. Write a query to find the list customer_name, customer_id, different cards owned and balance left on each card for all Premium customers? Q2. List the total renews of customers by different card types. Output should contain customer_id, card_type, card_name and total renewd_amount? Q3. List total calls made between 4th April 2018 and 5th May 2018 for all premium customers whose call duration is greater than 10 minutes by day. Output should contain total calls , date

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_2

Step: 3

blur-text-image_3

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

Foodservice Management Principles And Practices

Authors: June Payne Palacio, Monica Theis

13th Edition

0133801101, 9780133801101

More Books

Students also viewed these General Management questions

Question

=+30. JOINT VENTURES 587 Additional Information

Answered: 1 week ago

Question

2. What do the others in the network want to achieve?

Answered: 1 week ago

Question

1. What do I want to achieve?

Answered: 1 week ago