Unsure of the required input, a 'create function' maybe?

#1
jordy26

Posted 19 November 2011 - 01:36 PM

Newbie

Members
2 posts

Hi everyone. I had a question regarding a small task i've been given. Below I have pasted the question and a screenshot of the database layout. Now I just don't understand what exactly i'm ment to be creating, a user defined function maybe? But how..

Question:
Calculate and return the total estimated chargeable cost of a stage taking into the different charge rates applicable for different tasks (assuming that all the work for the stage has been assigned).

Screenshot of DB layout:
Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

Not a clue :/

Any hints or tips to create the SQL output needed would be great help, thanks.

---------- Post added at 01:36 PM ---------- Previous post was at 01:35 PM ----------

I believe its 'estimated hours * chargeable rate' but still not entirely sure, any help really.

#2
WingedPanther

Posted 19 November 2011 - 02:18 PM

A spammer's worst nightmare

Moderators
16,831 posts

Location:Upstate, South Carolina
Programming Language:C, C++, PL/SQL, Delphi/Object Pascal, Pascal, Transact-SQL, Others
Learning:Java, C#, PHP, JavaScript, Lisp, Fortran, Haskell, Others

I would start by looking at sample data. What tables have to have the data for you to determine the charge of a stage? I'm guessing it involves STAGE, TASK, TASK_TYPE, and CHARGE_GRADE, but I can see it involving others, as well.

Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

#3
jordy26

Posted 19 November 2011 - 02:57 PM

Newbie

Members
2 posts

I'm guessing it involves STAGE, TASK, TASK_TYPE, and CHARGE_GRADE, but I can see it involving others, as well.

I have the table information (as shown below). Just the sql to connect and SUM them up I guess is where i'm confused I think.

Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting