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

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

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions

Question

What is the environment we are trying to create?

Answered: 1 week ago

Question

How would we like to see ourselves?

Answered: 1 week ago