# Ambiguities in Assigment 2

Posted by stevenv
Announcements Last Post
SoC Curricula 09/30/2017 01:08PM
Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
School of Computing Short Learning Programmes 11/24/2014 08:37AM
Unisa contact information 07/28/2011 01:28PM
 Ambiguities in Assigment 2 April 30, 2007 10:57AM Registered: 13 years ago Posts: 613 Rating: 0
There are way too many ambiguities in Assignment 2 for my liking, I sincerely hope that this is not an indication of what the exam will be like in Oct/Nov.

For instance (and I've already posted a thread about this), in Question 2.2 the question states "Which boat is still due for a service and when?" which indicates that the Next_Service value should be in the future but in the sample data, all the dates are in the past UNLESS you assume we are all living in 2005 right now and that requesting the current date will return some date where we can possibly have one of the given sample data thus occurring in the future.

Again, in question 2.11 where the question is "Delete the next service scheduled between 2005/01/01 and 2005/12/31". There are two services scheduled during these dates so how does one define "the next service scheduled" when if the current date is 2005/06/1, the next service is 2005/09/15 and if the current date is 2005/09/20 then the next service is 2005/10/10.

Furthermore, what is it exactly that they're asking for in 2.12? Is it something along the lines of page 638-640 of the textbook or is that they want some simple arithmetic to find the numerical difference between Spent_Hours for service request and job card tables respectively?
 Re: Ambiguities in Assigment 2 May 01, 2007 07:13PM Registered: 13 years ago Posts: 226 Rating: 0
for q2.1
The SERVICE_REQUEST table by itself won't have sufficient info for due service boad, you have to determine it in conjection with SLIP table by compare with the difference between both Slip_Num column in these two table.

My try:
select Boat_Name
from SLIP
where Slip_Num not in (select Slip_Num from SERVICE-REQUEST);

for q2.11
The question just want you to detelet the rows with the Next_Service column content between 2005/01/01 to 2005/12/31. It doesn't matter the current date.

My try:
delete from SERVICE_REQUEST
where Next_Service between #2005/01/01# and #2002/12/31#;

for q2.12
The question just want you to compare the SERVICE_REQUEST and the JOB_CARD table which obviously the Slip_Num, Category_Num,and Spent_Hours columns are the different columns and the Service_ID with content 1 and 2 in S_R table are different with the J_C table.

My try:
select *
from SERVICE_REQUEST
where * not in (select * from JOB_CARD);

How about q2.5 where in the text book can I find the SQL-92 standard. What four options they are talking about? Are they mean
restrict
constraint
unique ?

How about q1.13? what funcions can I use for the question? Maybe I should use Group by?

Any idea?
 Re: Ambiguities in Assigment 2 May 01, 2007 11:27PM Registered: 13 years ago Posts: 613 Rating: 0
Thanks for the response

2.1: Not a bad suggestion. Originally, someone suggested you 'fake' the current date returned by the function Now() to be sometime during 2005 and then write a query that would return the next service date. I tend to like your suggestion a bit more though.

2.11: The problem with that is that it will delete all services scheduled between those dates, not just the next service. I found a solution to this one where you use the MS Access function TOP 1 in conjunction with an order by which returns just the first record in date order which is essentially the next service.

2.12: This one is still stumping me.

2.5: Did some research online and found that they might be referring to cascade, delete, set null and set default. Not 100% sure about this one though.

1.13: This one was tricky but found that if you use a self-join you can have two copies of the dataset to work with i.e. two copies of description and two copies of charge and then all you have to do is the necessary comparisons on description and charge to write the query.

Steven
 Re: Ambiguities in Assigment 2 May 02, 2007 06:14AM Registered: 12 years ago Posts: 26 Rating: 0
1.12: How did you interpret this request?

To me it looks like they want us to create the table then insert the procedures from the TREATMENT table as well as a made-up Duration_Hour. Physician_ID and Cost should be left blank.
 Re: Ambiguities in Assigment 2 May 02, 2007 12:15PM Moderator Registered: 13 years ago Posts: 46 Rating: 0
Questions 2.1 and 2.12 contain ambiquities which make them impossible to evaluate fairly, i.e. no marks will be awarded for those questions. Exam questions are checked by external moderators so there should not be any ambiquities there.
 Re: Ambiguities in Assigment 2 May 02, 2007 07:31PM Registered: 13 years ago Posts: 1,138 Rating: 0
Q1.10
"List each patient's number and the total of his/her bill."

There is no price for a tonsillectomy or a private room, should we just answer the question without it?
 Re: Ambiguities in Assigment 2 May 02, 2007 10:14PM Registered: 13 years ago Posts: 613 Rating: 0
Don't worry about the cost of the treatment they received, focus on the CHARGES table which links patients with the charges against them.
 Re: Ambiguities in Assigment 2 May 03, 2007 08:04AM Registered: 13 years ago Posts: 898 Rating: 0
stevenv Wrote:
-------------------------------------------------------
> Don't worry about the cost of the treatment they
> patients with the charges against them.

Yip, and use the SUM and Group By functions.
 Re: Ambiguities in Assigment 2 May 03, 2007 04:05PM Registered: 13 years ago Posts: 613 Rating: 0
vbiljja Wrote:
-------------------------------------------------------
> Questions 2.1 and 2.12 contain ambiquities which
> make them impossible to evaluate fairly, i.e. no
> marks will be awarded for those questions. Exam
> questions are checked by external moderators so
> there should not be any ambiquities there.

Is this considered an official response?
 Re: Ambiguities in Assigment 2 May 04, 2007 08:42AM Registered: 13 years ago Posts: 898 Rating: 0
Well she is a senior lecturer at UNISA, and Lecturer for this Module (according to osprey), so I guess so.
 Re: Ambiguities in Assigment 2 May 04, 2007 03:34PM Registered: 13 years ago Posts: 613 Rating: 0
Oops
Sorry, only registered users may post in this forum.