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.
The text is available as an online resource, logging in on UWA computers (maybe a UWA VPN if you are off campus). It does explain some of the slides in more detail and is worth checking out as it is quiet thorough.
Completing lab 5 was difficult but made even more so because I was using the tables and values that were given to us earlier in the course and they are stored on my computer. I found lab 5 had extra tables and question 3 had extra rows in it, so it ...
I found the test difficult, particularly the last few questions. I got four correct and gave up in the end, it was too stressful. I did not study triggers, however could we have some remedial follow up for it? I cannot be the only one that found ...
credit
https www.cs.uct.ac.za mit notes database htmls chp07.html
For anyone that was looking at the anonymous superclass inquiry on here....
I found this useful but it probably reinforces the lecture notes.
Method 1
All the entities in the relationshi...
The subquery question in the midsem. I found that one a difficult one to answer because there was a video on the subquery content of that question but the lab was not released until 4 September, so we were not really drilled on it. That is we reall...
Well, the student office would refer me to the UC as far as an appeal on a MCQ test, is a guess. All I can say is, that to write down 1 and 3 on the exam paper and then mark D on both the exam paper answer sheet, which is not A or E or both, was a s...
DR Nasim, I thought that was the basis of filling in the form? No-one has followed it up. I have my examination paper whereby I actually wrote down 1 and 3 as correct, but 3 is not correct, I crossed out 2, but on the answer sheet for some reason I...
I submitted a form indicating I was disputing my mark. I was marked wrong on question 7 when it is now in fact correct, I chose C. I am also lobbying for a mark for question 18, I did not guess any answers, I either knew them or I was completely de...
Can I play the idiot card for this question because I have fooled myself with answer sheets before? I marked the examination paper so that there was no doubt which answer I chose, I chose answer E but then circled D, which makes no sense. I correct...
Hello Teaching Staff,
I submitted the project part 1 on time, one day early, but it was not until I attempted lab4 that I noticed there were two different submission links. I submitted it as one pdf file, both the ER diagram and the data sheets.
Do I ...
Hello Teaching staff
LMS states that a text book is not required for the course.
The reading list mentions that we must have it.
The text book is mentioned in the class.
Do we need to refer to any textbook at all?
I thought I would add some late mail to this. The code runs because SQL likes it ?
However the rule that was introduced in the lecture states that with select a, b then a and or b must be either grouped or an aggregate function. B is the correct an...
Hello Teaching Staff
Does our ERD have to follow the same structure as the one in the case study? My extended research has found some other methods that include the same information. I found one that I thought was easier to implement and included al...
Hello Teaching staff
LMS does say there is no text book required for the course. Then there is the readings section on LMS which does say that that we have a "should buy" for the text book x 2. We have also been advised to read chapters. I think we...
Hello Teaching staff
Could someone please give me an update on my second query from Wed 4th Sept, relationship attributes? The reason for this is that the alternate diagram structures from lesson 4, ER modelling are confusing me. There is an instanc...
If it is not required then I am not going to put it in. I guess I was just thinking about it from a business perspective and I thought, is this the missing link? That leads to a HD? The obvious one that we need to put it. Point of Sale I guess is ...
I understand that relationship attributes are a separate concept to Multiplicity, but I did find a useful video that explains this in detail https www.youtube.com watch?v psgMeCyXDxc
However, this takes the worksheet exercise to a new level because...
Thinking about the worksheets and different terminologies. One thing I did note in the lecture was that it was emphasised that relationships have attributes as well, but my take on this is "Multiplicity". Would that be the correct interpretation fo...
What I found missing from the case study is billing or POS (Point of Sale) which would draw data from the different tables to produce a final invoice. All the information is recorded. Do we need to worry about an invoice cash receipt table for inst...