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.
Hey, Arts G58 is Murdoch Lecture Theatre, if you don't know where it is, it is next door to Alexander Lecture Theatre. If you know where Reid Library is then simply go straight the way you go to where you go to get the 950 bus stop but then turn righ...
Hi,
In principle the AND and OR should not give the same result, however, given the tiny amount of data the sample file has, it may give you the same result. You can add more test data to test your queries on your own computer.
The where clause will ...
I believe it is the Tattersall Lecture Theatre, it's immediately north of the Bayliss Building and south of James Oval. Here is a map link https link.mazemap.com yYJbFfZY
Hey , Guys if anyone need a partner for the project then i can connect with them as i am new to this subject and also need knowledge about this subject along with project, if someone feels he or she can help me. I will be very pleased.
Fellow student response
The context for Worksheet 2 was the same as Lab 2 so I used the data provided for that lab on the Jinhong server to test the queries you proposed and this is what I found
1) Not sure why this is. All I can say for sure is that...
Good evening,
I hope this message finds you well. My name is Bhavya Narula, and I am currently enrolled in CITS1402 (Relational Database Management Systems). I was unable to locate my name in the "rooms.pdf" file for the seating of the upcoming mid-se...
Hi,
From the lectures,
"Column names in HAVING clause must also appear in the GROUP BY list or be contained
within an aggregate function."
The solution uses
HAVING count(cust id) 2 and city OR phone IS NOT NULL
However, column city, phone are ...
Already answered on forums
Content
- Theory Everything that we will cover till the Lecture in week 6 (26 Aug 2024). Topics include
Introduction to Databases
Relational Model
Relational Algebra
ER Modeling (Wk 4)
Enhanced ER Modeling (Wk 5-6)
- SQL Eve...
Did I not emphasize enough yesterday that logical or physical database design was not part of the exam?
We did not study anything related to those phases. We just did an intro.
Mehwish
Hello,
Worksheet number 2 has a question that goes as follows
Q) Display credit code, and the count of publishers in a column called Number of
publishers. Then group according to the creditcode for all the cases where either the
count is greater th...
All column names in SELECT list must appear in GROUP BY clause unless name is used only in an aggregate function.
For this solution, we "SELECT job id, po date", but only "GROUP BY job id".
Hi,
The solutions for worksheet 2 mention that there is an error in the solution to Question 2. What is that error? I have not been able to pick that up.
Thanks