Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

consider the following relational schema that manages the telephobe bills of a mobile phone company. CUSTOMER ( SSN , Name, Surname, PhoneNum, Plan ) PRICINGPLAN

consider the following relational schema that manages the telephobe bills of a mobile phone company.
CUSTOMER (SSN, Name, Surname, PhoneNum, Plan)
PRICINGPLAN (Code, ConnectionFee, PricePerSecond)
PHONECALL (SSN, Date, Time, CalledNum, Seconds)
BILL(SSN, Month, Year, amount)
write a trigger that at the end of each month discount the bills by 5% per call to direct users of the t comapny (that is to registered users in the table CUSTOMER) if the total monthly amount of the bill excedds Rs 200.

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

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students explore these related Databases questions

Question

How would we like to see ourselves?

Answered: 3 weeks ago