It's UWAweek 21 (1st semester, week 12)

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

Please consider offering answers and suggestions to help other students! And if you fix a problem by following a suggestion here, it would be great if other interested students could see a short "Great, fixed it!"  followup message.

How do I ask a good question?
Displaying selected article
Showing 1 of 166 articles.
Currently 1 other person reading this forum.


 UWA week 18 (1st semester, week 9) ↓
SVG not supported

Login to reply

👍?
helpful
5:14pm Thu 2nd May, ANONYMOUS

Hi, just wanted to clarify some doubts I had when attempting to create the views 3.List the current service fee for all the services when it is greater than $100. [view name:expensiveServices] When creating the db, are we updating the "currentServiceFee" to reflect the "actualFee" or is the "actualFee" customized for each appointment? For instance, let's say "Service A" has a current service fee of $3. However, for one appointment, "Surgeon A" decides to charge $500 for "Service A," while for another appointment, "Surgeon B" decides to charge $250 for the same service. In creating the view, do you filter out which services, when given for an appointment, are priced at more than $100 and return the "currentServiceFee" of $3?

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  5:07AM Sep 06 2023
Privacy policy