It's UWAweek 48

help1402

This forum is provided to promote discussion amongst students enrolled in CITS1402 Relational Database Management Systems.

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.

How do I ask a good question?
Showing 20 of 685 articles
Showing page 29 of 35⬅ older  |  newer ⮕
Currently 1 other person reading this forum.


 UWA week 35 (2nd semester, week 6) ↓
SVG not supported 8:56pm Tue 27th Aug, ANONYMOUS

Hey, your in ARTS G58 which is Murdoch Lecture Theatre, which is the lecture theatre next to Alexander Lecture Theatre. Hope that helps


SVG not supported 8:49pm Tue 27th Aug, ANONYMOUS

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...


SVG not supported 6:53pm Tue 27th Aug, Mehwish N.

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 ...


SVG not supported 6:48pm Tue 27th Aug, Mehwish N.

)


SVG not supported 5:43pm Tue 27th Aug, ANONYMOUS

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


SVG not supported 5:31pm Tue 27th Aug, Nafisa T.

Hey, can anyone let me know which lecture hall is WTLTS?


SVG not supported 5:29pm Tue 27th Aug, ANONYMOUS

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.


SVG not supported 5:11pm Tue 27th Aug, ANONYMOUS

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...


SVG not supported 5:03pm Tue 27th Aug, Bhavya N.

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...


SVG not supported 4:57pm Tue 27th Aug, Bhavya N.

I am looking for partner for the project as well My student number is 24253549.


SVG not supported 4:02pm Tue 27th Aug, ANONYMOUS

Hi, Just wondering where the ARTS G58 room is. This is where my mid sem exam will take place. Thanks in advance.


SVG not supported 3:43pm Tue 27th Aug, ANONYMOUS

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 ...


SVG not supported 2:56pm Tue 27th Aug, Amisha G.

You can see room in pdf in new email sent by teacher. There is a pdf


SVG not supported 2:44pm Tue 27th Aug, Mehwish N.

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...


SVG not supported 2:43pm Tue 27th Aug, Mehwish N.

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


SVG not supported 1:34pm Tue 27th Aug, Tyson R.

Same for me, I'm guessing it'll be same for everyone.


SVG not supported 1:11pm Tue 27th Aug, Johar K.

I haven t received an email about room allocation. Is it just me or everyone?


SVG not supported 12:06pm Tue 27th Aug, ANONYMOUS

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...


SVG not supported 12:01pm Tue 27th Aug, Mengxi L.

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".


SVG not supported 11:18am Tue 27th Aug, ANONYMOUS

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

The University of Western Australia

Computer Science and Software Engineering

CRICOS Code: 00126G
Written by [email protected]
Powered by history
Feedback always welcome - it makes our software better!
Last modified  8:08AM Aug 25 2024
Privacy policy