COMP9311 Project Q&A

Thank you! On Friday, May 25, 2018 at 1:18:02 AM UTC+10, Milena Davidson wrote: I was grabbing all

Thanks man! On Friday, 25 May 2018 07:41:13 UTC+10, Daniel Hocking wrote: This one has been answered

Hi Kai can u PLEASE confirm what u mean EXACTLY by invalid staffid and orgid in question 2 and 3? On

Hi , Getting this error since 1 hr. Can anyone tell me what is the problem. Trying to stop and start

Never mind my question - I rewrote it entirely using a different approch, just to be on the safe side

Refer to the function Cast: https://www.postgresql.org/docs/9.3/static/sql-createcast.html Cheers,

Refer to the function Round(). Cheers, Yang On Thursday, May 24, 2018 at 1:46:14 PM UTC+10, Adith

You need to add student as a second parameter of the ORDER BY clause for both ascending and

Hey, I figured out the issue. I had to re-index somethings. Something got messed up in my database.

Hey, The last average mark that you got is incorrect. I hope that helps you find the solution. :) On

Some students treat courses with the same name as the same course in project 1. We write this because

Thank you so much! It worked! On Wednesday, May 23, 2018 at 8:43:38 PM UTC+10, Paula Kiatkamolwong

You've probably figured out another way by now, but you could possibly use 'offset' and

Do something like this if you haven't already found it. create or replace function fin2(org_id

Hi Sarah, I think if the user input an orgid that doesn't exist in the table orgunits, then you

Hi Kai, I don't think that we should return 00s2 for a course which has been hold on for example

If a course_id from the course table doesn't have a corresponding record from the

Hi Kavitha, We have written very clear in the specification: For each question, please output results

Yes, you can. Just don't create huge tables which may cause your disk quota exceeded. Kai On Tue,

Check whether your function is correct or not. Cheers, Yang On Saturday, May 19, 2018 at 10:56:33 PM

Hey Yang, Will additional test cases be given? Regards, Kevin. On Tuesday, May 15, 2018 at 11:13:33

Sorry didnt realise the use of orgunit_groups! All good On Sunday, May 20, 2018 at 3:46:54 AM UTC+10,

Its not sum its count. If the student id is 509758 that will be added with sum but its one student so

"Include all" means parent and sub-organizations. So you have the given organization and

On Wednesday, May 16, 2018 at 7:06:58 AM UTC+10, S Venkata Soma Sekhar wrote: Hi, Q3. null score

yes, you can. On Wednesday, May 16, 2018 at 7:03:53 AM UTC+10, S Venkata Soma Sekhar wrote: Q2.

You can use an if statement in the recursive function to pass values that was seen so that you don

Yes. Boge 2018-05-17 11:40 GMT+10:00 Shaoyang <weis...@gmail.com>: Dear tutor, Could you

The timestamp of the file requested by the teacher because the last submission was unsuccessful

It looks like your type CourseRecord was not dropped hence why it is still there. Try run drop