It's UWAweek 40 (2nd semester, week 10)

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?
There are 217 active topics since Time began
Showing 593 of 585 articles.
Currently 2 other people reading this forum.


 UWA week 39 (2nd semester, week 9) ↓
SVG not supported 7:42am Sat 1st Oct, Gordon R.

Several students have already reported errors, omissions or ambiguities in the draft project document - thanks for spotting these. I am collecting those in a list that is at the bottom of the Project description on the LMS, so you can rapidly check if...


 UWA week 40 (2nd semester, week 10) ↓
Project - View Null clientId (both)
9:45pm Thu 6th Oct Tu H.
10 hours later Gordon R.

Trigger affects only one row (both)
7:19pm Thu 6th Oct ANONYMOUS
12 hours later Gordon R.

check constraints ISBN # (both)
2:03pm Thu 6th Oct ANONYMOUS
95 mins later Gordon R.

Project Clarifications (all 3)
12:26pm Thu 6th Oct Martin E.
60 mins later Michael S.
3 hours later Gordon R.

Project - Trigger test (all 3)
12:32am Thu 6th Oct Tu H.
27 mins later Tu H.  O.P.
6 hours later  👍x1 Gordon R.

Wording not clear question 2a (both)
9:08pm Wed 5th Oct ANONYMOUS
10 hours later Gordon R.

dateBack < dateOut (both)
3:23pm Wed 5th Oct Kyle C.
2 mins later Kyle C.  O.P.

Trigger (both)
2:45pm Wed 5th Oct Wenjie S.
75 mins later Gordon R.

Notnull (both)
2:06pm Wed 5th Oct Wenjie S.
4 hours later Gordon R.

LoanTrigger (both)
12:28pm Wed 5th Oct Cohen R.
44 mins later Gordon R.

Bookedition (both)
11:48am Wed 5th Oct Cohen R.
17 mins later Gordon R.

about the ISBN type (both)
11:32am Wed 5th Oct Lili L.
29 mins later Gordon R.

daysLoaned Clarification (both)
1:00am Wed 5th Oct ANONYMOUS
6 hours later Gordon R.

Project - Primary Keys (both)
12:07am Wed 5th Oct Tu H.
7 hours later  👍x1 Gordon R.

BookCopy and BookEdition (all 4)
12:06am Wed 5th Oct Wenjie S.
6 hours later Gordon R.
8 hours later Yinyin W.
9 hours later  👍x1 Gordon R.

SubString in sqlite with Ints (both)
2:44pm Tue 4th Oct Amanda B.
17 mins later  👍x1 Gordon R.

ERD (both)
1:54pm Tue 4th Oct ANONYMOUS
72 mins later Gordon R.

Project (both)
1:41pm Tue 4th Oct ANONYMOUS
84 mins later Gordon R.

ISBN Project (both)
1:10pm Tue 4th Oct Amanda B.
114 mins later  👍x1 Gordon R.

Client entered before borrow (all 4)
12:40pm Tue 4th Oct Cohen R.
13 mins later Andrew W.
44 hours later Cohen R.  O.P.
45 hours later Andrew W.

Relationships (all 3)
12:13pm Tue 4th Oct Cohen R.
16 mins later Cohen R.  O.P.
4 hours later Gordon R.

Loan, BookCopy, Clients (both)
3:16am Tue 4th Oct Wenjie S.
5 hours later Gordon R.

Project Trigger Question (all 3)
9:23pm Mon 3rd Oct ANONYMOUS
10 hours later  👍x1 Gordon R.
14 hours later ANONYMOUS  O.P.

Sample data (both)
9:03pm Mon 3rd Oct ANONYMOUS
11 hours later Gordon R.

Project Constraint (all 5)
6:05pm Mon 3rd Oct ANONYMOUS
3 mins later ANONYMOUS  O.P.
39 mins later Andrew W.
57 mins later ANONYMOUS  O.P.
66 mins later Andrew W.

 UWA week 39 (2nd semester, week 9) ↓
Project loan table (both)
7:06pm Sun 2nd Oct Kelly S.
 ✅11 mins later Andrew W.

Project Sample Data Generator Repository (all 3)
 ✅4:33pm Sun 2nd Oct  👍x4 Andrew W.
4 days later ANONYMOUS
4 days later Andrew W.  O.P.

Submission of project file (both)
2:25pm Sun 2nd Oct ANONYMOUS
80 mins later  👍x1 Gordon R.

week 9 q11 (both)
7:50am Sun 2nd Oct ANONYMOUS
65 mins later Gordon R.

Project: Sample Data (all 4)
12:07am Sun 2nd Oct Andrew W.
9 hours later Gordon R.
11 hours later Andrew W.  O.P.
16 hours later Andrew W.  O.P.

Sample Question in Lecture/Video 23 (Week 8) (all 3)
11:54pm Sat 1st Oct ANONYMOUS
8 hours later Gordon R.
54 hours later ANONYMOUS  O.P.

LAB 9 Q4 (both)
10:13pm Sat 1st Oct ANONYMOUS
10 hours later Gordon R.

lab 9 ques 9 (all 4)
8:52pm Sat 1st Oct  👍x1 Jasleen H.
11 hours later Gordon R.
18 hours later ANONYMOUS
61 hours later Gordon R.

Project: Datatype for publicationDate (all 3)
7:24pm Sat 1st Oct Andrew W.
4 mins later Andrew W.  O.P.
13 hours later Gordon R.

Can the clientId starts with 0 (both)
2:48pm Sat 1st Oct ANONYMOUS
2 hours later Gordon R.

Relationship between BookCopy and BookEdition (all 3)
2:41pm Sat 1st Oct Wenjie S.
19 mins later Wenjie S.  O.P.
2 hours later Gordon R.

Project: Relationship between BookCopy and BookEdition (both)
10:38am Sat 1st Oct Andrew W.
3 mins later Andrew W.  O.P.

Julian date calculation (both)
2:51am Sat 1st Oct ANONYMOUS
3 hours later Gordon R.

Trigger question (both)
1:09am Sat 1st Oct ANONYMOUS
5 hours later Gordon R.

Question on the page5 of the project (both)
5:01pm Fri 30th Sep Wenjie S.
90 mins later Gordon R.

Project QA - Client entity (both)
4:20pm Fri 30th Sep  👍x1 Tu H.
2 hours later Gordon R.

Indicating a composite key in ERD (both)
3:51pm Fri 30th Sep ANONYMOUS
2 hours later  👍x1 Gordon R.

Lab 9 Question 3 (all 3)
2:44pm Fri 30th Sep ANONYMOUS
41 mins later Gordon R.
34 hours later William J.

Lab 9 q15 (all 3)
8:55pm Thu 29th Sep ANONYMOUS
1 min later ANONYMOUS  O.P.
10 hours later Gordon R.

Answer sheet to the extra practical lab (both)
5:45pm Thu 29th Sep ANONYMOUS
13 hours later Gordon R.

q 11 sheet 9 (all 4)
5:14pm Thu 29th Sep Mahit G.
96 mins later Andrew W.
7 hours later Mahit G.  O.P.
13 hours later Gordon R.

Extra Practice Lab Q2 inner Query use of (SELECT MAX(SELECT COUNT(id)... (all 3)
3:49pm Thu 29th Sep Wesley A.
 ✅2 hours later Wenjie S.
17 hours later Gordon R.

Week 9 submission questions (both)
10:55am Thu 29th Sep ANONYMOUS
30 mins later Gordon R.

Deadline of the project (all 5)
1:37am Thu 29th Sep Wenjie S.
6 hours later Gordon R.
14 hours later ANONYMOUS
16 hours later Wenjie S.  O.P.
37 hours later Gordon R.

Lab 9 Q11 (all 3)
11:38pm Wed 28th Sep ANONYMOUS
8 hours later Gordon R.
60 hours later ANONYMOUS

Help with Q11 Wk 9 (all 3)
10:15pm Wed 28th Sep Zaki R.
49 mins later Zaki R.  O.P.
18 hours later Mahit G.

Week 9 Lab - Question 10 (both)
4:38pm Wed 28th Sep ANONYMOUS
15 hours later Gordon R.

question 11 lab 9 (all 3)
3:12pm Wed 28th Sep Mahit G.
58 mins later Gordon R.
20 hours later Andrew W.

lab 9 question 10 (both)
3:01pm Wed 28th Sep Mahit G.
61 mins later Gordon R.

General Lab Question (both)
7:36pm Tue 27th Sep ANONYMOUS
14 hours later Michael S.

Week 9 Lab Q 11 (all 4)
5:13pm Tue 27th Sep Johnson C.
1 min later Johnson C.  O.P.
26 hours later Ryan T.
28 hours later ANONYMOUS

Week 9 lab Q9 (both)
2:57pm Tue 27th Sep Kelly S.
21 hours later Gordon R.

Defining and using an Alias inside a SELCT statement lab9 Q12 (both)
4:18pm Mon 26th Sep Wesley A.
17 hours later  👍x2 Michael S.

 UWA week 38 (2nd semester, week 8) ↓
Lab9 Question 11(A16.sql) (all 4)
8:39pm Sat 24th Sep Yulong W.
4 mins later ANONYMOUS
8 mins later Yulong W.  O.P.
73 mins later Gordon R.

Week 9 lab (qn1) (all 4)
11:38am Fri 23rd Sep ANONYMOUS
48 mins later Gordon R.
3 hours later ANONYMOUS  O.P.
4 hours later Gordon R.

 UWA week 37 (2nd semester, week 7) ↓
Submitting test (all 3)
11:18am Sat 17th Sep ANONYMOUS
5 hours later Gordon R.
5 hours later ANONYMOUS  O.P.

woring submit on lms
10:31am Sat 17th Sep Yulong W.

2021 Semester 2 midsemester practice test Q4 (both)
9:37am Sat 17th Sep Lili L.
12 mins later ANONYMOUS

2021 Semester 2 midsemester practice test Q1 (both)
9:12am Sat 17th Sep Lili L.
7 mins later Gordon R.

Practice Question (all 3)
11:55pm Fri 16th Sep Zubayr R.
 ✅8 hours later ANONYMOUS
92 hours later Jinwei Z.

Test time (all 3)
3:59pm Fri 16th Sep ANONYMOUS
54 mins later Gordon R.
19 hours later Tu H.

lab 7 Q16 (all 5)
2:42pm Fri 16th Sep ANONYMOUS
27 mins later Gordon R.
108 mins later Yinyin W.
4 hours later  👍x1 Andrew W.
7 hours later ANONYMOUS

usage of EXCEPT (both)
2:37pm Fri 16th Sep ANONYMOUS
23 mins later  👍x1 Gordon R.

Lab Week 7 Q11 (all 4)
1:49pm Fri 16th Sep Amanda B.
22 mins later  👍x1 Gordon R.
39 mins later Amanda B.  O.P.
40 mins later Amanda B.  O.P.

SUM function (both)
11:54am Fri 16th Sep James R.
54 mins later Gordon R.

Q9 week 7 lab (both)
11:16am Fri 16th Sep Neha M.
88 mins later Gordon R.

2021 Semester 2 midsemester practice test Q6 (both)
12:39am Fri 16th Sep Wesley A.
7 hours later Gordon R.

differences between count(1) and count(*) (both)
11:38pm Thu 15th Sep Yulong W.
8 hours later Gordon R.

Early Sitting of Midsem Test (both)
10:57am Thu 15th Sep ANONYMOUS
2 hours later Gordon R.

IIF vs CASE (both)
10:28am Thu 15th Sep Zubayr R.
3 hours later  👍x1 Gordon R.

Test Topic (both)
10:20am Thu 15th Sep ANONYMOUS
2 hours later  👍x1 Gordon R.

Another migrated question (both)
6:49am Thu 15th Sep Gordon R.
3 mins later Gordon R.  O.P.

Question 6 Practice Test (both)
12:19am Thu 15th Sep Zubayr R.
12 mins later  👍x1 Michael S.

Mid Semester Test (both)
8:23pm Wed 14th Sep ANONYMOUS
62 mins later ANONYMOUS

Regarding Query writing style (all 4)
1:25pm Wed 14th Sep ANONYMOUS
42 mins later Gordon R.
107 mins later ANONYMOUS  O.P.
2 hours later Gordon R.

Syllabus for mid sem test (both)
1:19pm Wed 14th Sep ANONYMOUS
46 mins later Gordon R.

Question 4 of Practice Test (both)
12:23pm Wed 14th Sep ANONYMOUS
101 mins later  👍x1 Gordon R.

Writing Query (both)
11:42am Wed 14th Sep Zubayr R.
2 hours later  👍x1 Gordon R.

Mid Sem Test (both)
11:17am Wed 14th Sep ANONYMOUS
16 mins later Zubayr R.

Lab 5 question 12 (both)
4:47pm Tue 13th Sep ANONYMOUS
13 hours later Gordon R.

Lab 5 question 10 (both)
4:34pm Tue 13th Sep ANONYMOUS
14 hours later Gordon R.

Lab 7 question 16 (both)
1:57pm Tue 13th Sep ANONYMOUS
2 hours later Gordon R.

Mid semester test questions (both)
11:00pm Mon 12th Sep Tu H.
8 hours later  👍x1 Gordon R.

Lab 7 - Question 12 and Question 16 Query (both)
6:39pm Mon 12th Sep ANONYMOUS
2 mins later Gigi C.

Types of attributes in ERD (both)
3:51pm Mon 12th Sep Kelly S.
73 mins later Gordon R.

Lab 7 Questions (both)
8:26am Mon 12th Sep Gordon R.
10 mins later Gordon R.  O.P.

 UWA week 36 (2nd semester, mid-semester break) ↓
Early test request question (all 4)
12:55pm Sat 10th Sep Robert B.
9 hours later Jichunyang L.
18 hours later Gordon R.
43 hours later Gordon R.

Week 7 lab (both)
12:39pm Sat 10th Sep ANONYMOUS
43 hours later Gordon R.

And another question
2:09pm Fri 9th Sep Gordon R.

More questions
9:58am Fri 9th Sep Gordon R.

Set Operators and Subqueries (all 3)
3:38pm Thu 8th Sep ANONYMOUS
5 hours later  👍x1 Gordon R.
4 days later ANONYMOUS

Week 5 & 6 Lab Solutions (all 3)
11:44am Wed 7th Sep ANONYMOUS
53 mins later Gordon R.
96 mins later ANONYMOUS  O.P.

FOURTH Question Received by Email
11:37am Wed 7th Sep Gordon R.

Third Question Received by Email
11:18am Wed 7th Sep Gordon R.

Second Question Received by Email
11:11am Wed 7th Sep Gordon R.

More Questions Migrated From Email
11:06am Wed 7th Sep Gordon R.

Follow through marks in the test. (both)
3:27pm Tue 6th Sep Martin M.
43 mins later Gordon R.

Filename for database .. (both)
8:00am Mon 5th Sep Gordon R.
5 mins later Gordon R.  O.P.

LAB 6 Q10 (both)
12:58am Mon 5th Sep ANONYMOUS
6 hours later Gordon R.

 UWA week 35 (2nd semester, week 6) ↓
Lecture Slides for 2022 (all 3)
1:00pm Sun 4th Sep Felix VP.
4 hours later Gordon R.
4 hours later Gordon R.

Test Date (all 8)
4:57pm Sat 3rd Sep Ryan T.
14 hours later  👍x1 Gordon R.
8 days later Ryan T.  O.P.
9 days later ANONYMOUS
9 days later Ryan T.  O.P.
9 days later  👍x1 ANONYMOUS
10 days later Ryan T.  O.P.
10 days later Ryan T.  O.P.

Lab 6 Question 6 A9.sql (both)
8:40am Sat 3rd Sep Zac M.
23 hours later Gordon R.

lab 6 q6 (both)
10:53pm Fri 2nd Sep ANONYMOUS
8 hours later  👍x1 Gordon R.

Validating output for submissions (both)
2:34pm Fri 2nd Sep ANONYMOUS
101 mins later Gordon R.

Question 8 in Week 6 Lab (both)
12:04pm Fri 2nd Sep ANONYMOUS
71 mins later Gordon R.

Confirmation of Question 5 from the Week 6 lab sheet (all 3)
11:59am Fri 2nd Sep ANONYMOUS
72 mins later Michael S.
73 mins later Gordon R.

Question migrated from email (both)
9:29am Fri 2nd Sep Gordon R.
9 mins later Gordon R.  O.P.

Clarification for Q4 lab 6 (all 4)
9:28am Fri 2nd Sep ANONYMOUS
4 mins later Gordon R.
13 mins later ANONYMOUS  O.P.
16 mins later Gordon R.

Clarification for Lab6 Q4 (both)
11:40pm Thu 1st Sep ANONYMOUS
9 hours later Gordon R.

Midsemester Test Alternative Sitting (both)
9:37pm Thu 1st Sep Kelly S.
11 hours later Gordon R.

Seminar 6 - Range of Questions Part 4. (both)
3:39pm Thu 1st Sep Wesley A.
17 hours later Gordon R.

Lab 6 submission (both)
9:44pm Wed 31st Aug ANONYMOUS
10 hours later Gordon R.

lab 6 q9 (both)
9:40pm Wed 31st Aug ANONYMOUS
38 mins later Michael S.

clarification on question 14 example of lab 6 (both)
6:50pm Wed 31st Aug Ronjon K.
43 mins later Andrew W.

Order By default sorting (all 4)
5:06pm Wed 31st Aug ANONYMOUS
44 mins later Michael S.
4 hours later Gordon R.
5 hours later Michael S.

Lab 6 ORDER BY (both)
11:03am Wed 31st Aug Kelly S.
9 mins later Gordon R.

ROUND in Wk 6 Lab (both)
10:03pm Tue 30th Aug ANONYMOUS
9 hours later Gordon R.

HAVING and WHERE (both)
8:47pm Tue 30th Aug ANONYMOUS
12 hours later Gordon R.

in or exists (all 3)
2:53pm Tue 30th Aug ANONYMOUS
78 mins later Gordon R.
7 days later Minghao C.

Question 12 Lab 5 (both)
4:05pm Mon 29th Aug Kyle C.
50 mins later Gordon R.

 UWA week 34 (2nd semester, week 5) ↓
lab 6 (both)
3:43pm Sun 28th Aug Minghao C.
8 hours later Michael S.

Q8 Lab 5 Week 6 Submission (both)
4:59pm Sat 27th Aug ANONYMOUS
3 hours later Jichunyang L.

lab 5 Q6 (all 3)
8:16pm Fri 26th Aug ANONYMOUS
17 hours later Andrew W.
62 hours later Gordon R.

Lab 3 Solutions (all 3)
3:38pm Fri 26th Aug ANONYMOUS
49 mins later Gordon R.
57 mins later ANONYMOUS  O.P.

How to do question 8 (week 5 lab work) (both)
3:00pm Fri 26th Aug ANONYMOUS
17 mins later Gordon R.

Sample Question2 on Video 17 (both)
1:45pm Fri 26th Aug ANONYMOUS
86 mins later  👍x1 Gordon R.

How to use the EXCEPT clause/statement (all 3)
10:56am Fri 26th Aug ANONYMOUS
 ✅25 mins later Andrew W.
3 hours later Gordon R.

Using Aliases (both)
11:48pm Thu 25th Aug ANONYMOUS
6 hours later Gordon R.

Week 6 lab q6 (all 3)
7:57pm Thu 25th Aug ANONYMOUS
10 hours later  👍x1 Gordon R.
87 hours later Robert B.

Week 4 Lab Assignment Marks Release (both)
6:32pm Thu 25th Aug ANONYMOUS
12 hours later  👍x1 Gordon R.

week 5 question 12 (all 3)
10:26am Tue 23rd Aug ANONYMOUS
2 hours later Gordon R.
58 hours later ANONYMOUS

week 5 lab submission (both)
7:55pm Mon 22nd Aug ANONYMOUS
10 mins later  👍x2 Michael S.

submitting files in correct format (all 3)
4:57pm Mon 22nd Aug ANONYMOUS
12 mins later Michael S.
22 mins later ANONYMOUS  O.P.

 UWA week 33 (2nd semester, week 4) ↓
the difference between != and except (both)
2:34am Sun 21st Aug ANONYMOUS
9 hours later  👍x1 Michael S.

Midsemester Test Date (all 4)
12:40pm Fri 19th Aug Kelly S.
87 mins later Gordon R.
26 hours later Kelly S.  O.P.
65 hours later Gordon R.

Problems in NATURAL JOIN (both)
12:37pm Fri 19th Aug ANONYMOUS
86 mins later  👍x1 Gordon R.

File submissions (both)
11:10am Fri 19th Aug Wesley A.
3 mins later Wesley A.  O.P.

Help with Week 4 Lab - Question 3 (both)
10:01pm Thu 18th Aug ANONYMOUS
9 hours later Gordon R.

ways to join II/III (both)
5:22pm Thu 18th Aug Saleh A.
12 mins later Gordon R.

Marking method (both)
6:21pm Wed 17th Aug ANONYMOUS
10 mins later  👍x2 Gordon R.

Q7 Week 4 Lab (both)
5:42pm Wed 17th Aug ANONYMOUS
21 mins later Gordon R.

Lab Week 4 Q6 (both)
2:11am Wed 17th Aug ANONYMOUS
5 hours later Gordon R.

Question about output column names (both)
11:17pm Tue 16th Aug ANONYMOUS
8 hours later Gordon R.

Lab 4 Q5 (all 4)
10:45am Tue 16th Aug Tin P.
25 mins later  👍x1 Michael S.
32 mins later  👍x1 Gordon R.
3 hours later Tin P.  O.P.

Mid Semester test format (all 3)
4:58am Tue 16th Aug Kyle C.
31 mins later Kyle C.  O.P.
2 hours later Gordon R.

 UWA week 32 (2nd semester, week 3) ↓
Lab 4 - SQLStudio - no result on my query (all 3)
7:27pm Sat 13th Aug Gigi C.
23 mins later Michael S.
21 hours later Gigi C.  O.P.

Relations are sets (so order of rows does not matter)
4:50pm Sat 13th Aug  👍x1 Gordon R.

Relations are sets (so row order does not matter)
4:49pm Sat 13th Aug Gordon R.

Lab3 , Q2 (all 4)
5:57pm Fri 12th Aug ANONYMOUS
4 hours later Jichunyang L.
22 hours later Gordon R.
94 hours later ANONYMOUS

Help with Week 3 Lab - question 11 (both)
4:07pm Fri 12th Aug ANONYMOUS
42 mins later Helen Y.

Lab 4 Question 3 (A4.sql) (all 5)
12:16pm Fri 12th Aug Uways M.
31 mins later Michael S.
58 mins later Uways M.  O.P.
91 mins later  👍x1 Michael S.
100 mins later Uways M.  O.P.

Q7 Week 4 Lab Submission (all 3)
10:49am Fri 12th Aug Shalini M.
2 hours later Michael S.
5 days later ANONYMOUS

Lab 3, Question 2 (both)
10:24am Fri 12th Aug Andrew W.
9 mins later Michael S.

Week 4 lab q6 (both)
8:37pm Thu 11th Aug  👍x1 ANONYMOUS
25 mins later  👍x1 Gordon R.

.read in SQLite Studio (all 3)
3:22pm Thu 11th Aug ANONYMOUS
6 mins later  👍x1 Gordon R.
17 mins later ANONYMOUS  O.P.

Naming the Files for Submission for Week 4 Lab (both)
2:50pm Thu 11th Aug ANONYMOUS
33 mins later  👍x1 Gordon R.

LAB 3 question 2, 9 and 11 (both)
12:44pm Thu 11th Aug ANONYMOUS
2 hours later Gordon R.

Lab Week 3 Q10 (both)
2:02am Wed 10th Aug ANONYMOUS
9 hours later Gordon R.

Lab 2 Q12 (all 9)
2:02pm Tue 9th Aug Amanda B.
36 mins later Warren C.
92 mins later  👍x1 Gordon R.
94 mins later Gordon R.
101 mins later  👍x3 Gordon R.
15 hours later Warren C.
19 hours later Gordon R.
23 hours later Andrew W.
24 hours later  👍x1 Gordon R.

Week 3 Lab Question 4 (both)
1:31pm Tue 9th Aug ANONYMOUS
4 mins later Gordon R.

Week 3 Lab Question 2 (all 4)
1:02pm Tue 9th Aug ANONYMOUS
5 mins later Gordon R.
25 hours later ANONYMOUS
4 days later Gordon R.

Easy Scroll Up Shortcut (all 4)
12:40pm Tue 9th Aug Amanda B.
26 mins later  👍x1 Gordon R.
27 mins later Michael S.
27 mins later  👍x1 Michael S.

online lecture (all 3)
9:00am Tue 9th Aug ANONYMOUS
63 mins later Michael S.
33 hours later ANONYMOUS

challenge question (both)
2:43am Tue 9th Aug ANONYMOUS
7 hours later Michael S.

this weeks lab (Challenge question) (all 3)
8:49pm Mon 8th Aug ANONYMOUS
68 mins later  👍x1 Trieu H.
17 hours later Andrew W.

sql3problem (both)
3:54pm Mon 8th Aug ANONYMOUS
21 mins later Michael S.

Lab Assignment Results (both)
12:58am Mon 8th Aug ANONYMOUS
7 hours later Gordon R.

 UWA week 31 (2nd semester, week 2) ↓
sqlite directory (both)
12:13am Sun 7th Aug Quang T.
4 hours later Raman D.

Lab 2 Question 2-3 (both)
2:32pm Sat 6th Aug ANONYMOUS
4 hours later Trieu H.

submitting (all 3)
9:58pm Fri 5th Aug ANONYMOUS
15 mins later Jichunyang L.
24 mins later Michael S.

Help with question 7 of the lab assignment (all 3)
5:01pm Fri 5th Aug ANONYMOUS
19 mins later Warren C.
26 mins later Michael S.

First Lab Submission (all 4)
1:22pm Fri 5th Aug ANONYMOUS
42 mins later Gordon R.
3 hours later ANONYMOUS
28 hours later ANONYMOUS  O.P.

Help with question 4 of the lab assignment (both)
1:14pm Fri 5th Aug ANONYMOUS
53 mins later  👍x1 Gordon R.

Lab 2 Submission (all 3)
11:46am Fri 5th Aug ANONYMOUS
27 mins later Michael S.
77 mins later  👍x1 Gordon R.

Need help with accessing AFLResult.db in sqlite3 (all 3)
11:13am Fri 5th Aug ANONYMOUS
14 mins later Gordon R.
28 mins later ANONYMOUS  O.P.

Checking Labs (both)
9:41am Fri 5th Aug Ciaran E.
113 mins later Gordon R.

cits1402 .open error Mac (all 3)
9:06am Fri 5th Aug ANONYMOUS
22 mins later ANONYMOUS  O.P.
2 hours later Michael S.

= or == (both)
1:36am Fri 5th Aug ANONYMOUS
6 hours later Gordon R.

Basic Shell Commands
 ✅8:17pm Thu 4th Aug Jichunyang L.

Cannot find cssubmit on LMS. (all 4)
7:46pm Thu 4th Aug ANONYMOUS
12 mins later ANONYMOUS  O.P.
18 hours later ANONYMOUS
19 hours later ANONYMOUS

File format for lab week 2 (.sql or .txt?) (all 4)
6:06pm Thu 4th Aug ANONYMOUS
55 secs later ANONYMOUS  O.P.
46 mins later  👍x1 Michael S.
106 mins later ANONYMOUS  O.P.

saving/importing into files (all 3)
10:07pm Wed 3rd Aug Daniel L.
28 mins later ANONYMOUS
10 hours later Gordon R.

week 3 lab (both)
6:03pm Wed 3rd Aug ANONYMOUS
14 hours later Gordon R.

Document type for lab submission (both)
3:00pm Wed 3rd Aug ANONYMOUS
101 mins later  👍x1 Gordon R.

week 3 lab question (all 10)
12:17pm Wed 3rd Aug ANONYMOUS
117 mins later ANONYMOUS  O.P.
2 hours later Shalini M.
4 hours later Gordon R.
22 hours later ANONYMOUS
24 hours later Gordon R.
25 hours later ANONYMOUS
27 hours later  👍x1 Shalini M.
51 hours later  👍x1 Warren C.
82 hours later Salar SN.

AFLResults in sqlite3 (all 3)
11:25am Wed 3rd Aug ANONYMOUS
96 mins later ANONYMOUS  O.P.
47 hours later ANONYMOUS

Query Structure for Lab Submission (both)
11:19pm Tue 2nd Aug Joshua DM.
7 hours later Gordon R.

Syntax for comparing text (both)
6:34pm Tue 2nd Aug ANONYMOUS
4 hours later Michael S.

File Submission content (all 5)
11:16am Tue 2nd Aug  👍x1 Gigi C.
3 mins later Michael S.
104 mins later Gigi C.  O.P.
113 mins later Michael S.
3 hours later Gigi C.  O.P.

Seminar and Lab Rooms (both)
5:39pm Mon 1st Aug ANONYMOUS
96 mins later Gordon R.

.read error (all 6)
12:58pm Mon 1st Aug ANONYMOUS
10 mins later Michael S.
54 mins later ANONYMOUS  O.P.
59 mins later  👍x1 Michael S.
2 hours later  👍x1 Gordon R.
3 hours later ANONYMOUS  O.P.

Checking lab answers with .read (all 4)
12:40pm Mon 1st Aug Daniella V.
27 mins later Michael S.
43 mins later Gordon R.
46 mins later Gordon R.

CITS1402 (all 5)
9:57am Mon 1st Aug ANONYMOUS
26 mins later Andrew W.
29 mins later  👍x1 Andrew W.
66 mins later Gordon R.
4 days later ANONYMOUS

 UWA week 30 (2nd semester, week 1) ↓
Potentially helpful solution to file format issues for plain text files (all 5)
5:43pm Sun 31st Jul  👍x1 Andrew W.
2 mins later Andrew W.  O.P.
2 hours later Jichunyang L.
13 hours later Gordon R.
75 hours later ANONYMOUS

Week 2 Lab Submissions
11:50am Sun 31st Jul Gordon R.

Unsuccessful Submission of Lab1 (all 7)
9:56am Sun 31st Jul ANONYMOUS
2 mins later Shalini M.
33 mins later Warren C.
91 mins later Gordon R.
93 mins later Jen Z.
116 mins later  👍x1 Gordon R.
5 hours later Warren C.

Submission W2 Lab - Validation Failed
9:55am Sun 31st Jul Shalini M.

.read Command (all 10)
2:21pm Sat 30th Jul Kelly S.
41 mins later Kelly S.  O.P.
20 hours later Tet S.
21 hours later  👍x1 Gordon R.
45 hours later ANONYMOUS
56 hours later Amanda B.
67 hours later ANONYMOUS
68 hours later  👍x1 Kelly S.  O.P.
70 hours later Amanda B.
72 hours later Amanda B.

why do we allow duplicate row? (both)
11:13pm Fri 29th Jul Hui-Xin Y.
 ✅34 hours later Shalini M.

labwork upload (both)
1:04pm Fri 29th Jul Jiaxin T.
3 hours later Gordon R.

Can't open sqlite3 in Powershell - Error message (all 5)
10:45am Fri 29th Jul Gigi C.
6 mins later Michael S.
59 hours later Longfei Z.
81 hours later ANONYMOUS
4 days later Michael S.

Data dictionaries (all 3)
9:50am Fri 29th Jul Andrew W.
73 mins later  👍x1 Michael S.
88 mins later  👍x1 Gordon R.

Labs (both)
11:21pm Wed 27th Jul ANONYMOUS
9 hours later Gordon R.

week2 lab question (all 6)
8:26pm Wed 27th Jul ANONYMOUS
2 mins later Michael S.
15 mins later ANONYMOUS  O.P.
12 hours later Gordon R.
15 hours later Jared H.
15 hours later Jared H.

Problem with SQLite (all 5)
6:08pm Wed 27th Jul ANONYMOUS
73 mins later Jichunyang L.
2 hours later Michael S.
15 hours later Wan H.
17 hours later Michael S.

When are lab submissions due?
8:01am Wed 27th Jul Gordon R.

sqlite problem (all 3)
11:47pm Tue 26th Jul Jiaxin T.
21 mins later Jiaxin T.  O.P.
 ✅28 mins later Jichunyang L.

How to Run Latest Version of SQLite on Mac (both)
1:00pm Tue 26th Jul Kelly S.
92 mins later Gordon R.

downloading sqLite (both)
12:16pm Tue 26th Jul ANONYMOUS
102 mins later Michael S.

AFLResults.db (both)
11:50am Tue 26th Jul Lauren H.
2 hours later Gordon R.

How do I download the PDF from Echo?
10:50am Tue 26th Jul  👍x1 Gordon R.

Online Seminar (both)
9:18am Tue 26th Jul Mark T.
88 mins later Gordon R.

SQLite Version (all 3)
12:25pm Mon 25th Jul Kelly S.
27 mins later Gordon R.
115 mins later Kelly S.  O.P.

 UWA week 29 (last week before 2nd semester) ↓
Unit Outline (all 5)
6:08pm Sat 23rd Jul Wesley A.
42 hours later Gordon R.
51 hours later Venu S.
61 hours later Gordon R.
68 hours later Venu S.

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  1:17AM Sep 14 2022
Privacy policy