![]() |
|
help1402This 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 341 active topics since dinosaurs roamed the Earth
Showing 966 of 958 articles.Currently 1 other person reading this forum. |
Final exam marks (all 3) | ||
12:33pm Fri 25th Nov | Mahit G. | |
38 mins later | Gordon R. | |
68 mins later | Mahit G. O.P. | |
Exam Marks & Solutions (all 3) | ||
1:14pm Sat 19th Nov | ANONYMOUS | |
43 hours later | Gordon R. | |
46 hours later | ANONYMOUS O.P. | |
UWA week 45 (2nd semester, 2nd exam week) ↓ |
||
Can a table have a composite key and be in BC form (both) | ||
1:44pm Mon 7th Nov | Wesley A. | |
22 hours later | Gordon R. | |
2014 Exam Q6 (both) | ||
9:36am Mon 7th Nov | Wesley A. | |
43 mins later | Gordon R. | |
UWA week 44 (2nd semester, 1st exam week) ↓ |
||
2021 BCNF (both) | ||
9:57pm Sun 6th Nov | ANONYMOUS | |
9 hours later | Gordon R. | |
Exam paper Q3 2021 (all 4) | ||
9:05pm Sun 6th Nov | ANONYMOUS | |
13 mins later | ANONYMOUS O.P. | |
15 mins later | ANONYMOUS O.P. | |
21 mins later | Gordon R. | |
Q9 Midsem and q2 2019 (all 3) | ||
8:31pm Sun 6th Nov | Venu S. | |
12 mins later | Trieu H. | |
13 mins later | Trieu H. | |
2019 2 Q6 (all 4) | ||
6:48pm Sun 6th Nov | Lili L. | |
75 mins later | Gordon R. | |
102 mins later | Trieu H. | |
104 mins later | Trieu H. | |
Exam 2021 Q1 (both) | ||
5:33pm Sun 6th Nov | ANONYMOUS | |
33 mins later | Gordon R. | |
2015 Exam Question 22 (d) (both) | ||
1:33pm Sun 6th Nov | ANONYMOUS | |
18 mins later | Gordon R. | |
extra practice lab (both) | ||
10:06am Sun 6th Nov | ANONYMOUS | |
3 hours later | Gordon R. | |
Past Question in Midsem Test (both) | ||
12:26am Sun 6th Nov | ANONYMOUS | |
8 hours later | Gordon R. | |
2019 q10 (all 3) | ||
1:05pm Sat 5th Nov | Neha M. | |
2 hours later | ANONYMOUS | |
20 hours later | Gordon R. | |
Exam Location (both) | ||
11:24am Sat 5th Nov | ANONYMOUS | |
21 hours later | Gordon R. | |
previous exam paper (all 3) | ||
9:25am Sat 5th Nov | ANONYMOUS | |
66 mins later | Gordon R. | |
103 mins later | ANONYMOUS O.P. | |
CASE statement (both) | ||
9:03am Sat 5th Nov | Neha M. | |
89 mins later | Gordon R. | |
Lossless-join (both) | ||
8:13am Sat 5th Nov | Neha M. | |
2 hours later | Gordon R. | |
Functional Dependencies (both) | ||
8:14pm Fri 4th Nov | ANONYMOUS | |
11 hours later | Gordon R. | |
2014 Q8 (both) | ||
7:49pm Fri 4th Nov | Zubayr R. | |
11 hours later | Gordon R. | |
ERD in exam (both) | ||
4:23pm Fri 4th Nov | ANONYMOUS | |
15 hours later | Gordon R. | |
Corrections for Exam 2019 Solutions | ||
3:55pm Fri 4th Nov | Gordon R. | |
2019 Exam Question 7,8 and part 3 (both) | ||
12:29pm Fri 4th Nov | ANONYMOUS | |
41 mins later | Gordon R. | |
Exam clarification (both) | ||
10:11pm Thu 3rd Nov | ANONYMOUS | |
8 hours later | Gordon R. | |
2019 Exam question 2 (all 4) | ||
8:55pm Thu 3rd Nov | ANONYMOUS | |
10 hours later | Gordon R. | |
64 hours later | ANONYMOUS | |
68 hours later | Gordon R. | |
Relational Algebra (both) | ||
8:22pm Thu 3rd Nov | ANONYMOUS | |
11 hours later | Gordon R. | |
2014 MC Q7 NATURAL LEFT OUTER JOIN (both) | ||
5:14pm Thu 3rd Nov | Dilan A. | |
14 hours later | Gordon R. | |
Super key (both) | ||
5:07pm Thu 3rd Nov | ANONYMOUS | |
28 mins later | Gordon R. | |
midsem solutions (all 4) | ||
4:59pm Thu 3rd Nov | ANONYMOUS | |
89 mins later | Gordon R. | |
28 hours later | ANONYMOUS O.P. | |
41 hours later | Gordon R. | |
2019 Exam and Solutions | ||
7:54am Thu 3rd Nov | Gordon R. | |
Practice Exam Answers for 2015 and 2021 (both) | ||
7:50pm Wed 2nd Nov | ANONYMOUS | |
12 hours later | Gordon R. | |
2014 Practice Exam (all 4) | ||
5:58pm Wed 2nd Nov | ANONYMOUS | |
109 mins later | ANONYMOUS | |
65 hours later | ANONYMOUS O.P. | |
65 hours later | ANONYMOUS O.P. | |
Practice Exam Question (all 4) | ||
2:46pm Wed 2nd Nov | ANONYMOUS | |
19 mins later | Gordon R. | |
2 hours later | Jessica HC. | |
17 hours later | Gordon R. | |
2014 Exam (all 6) | ||
12:30pm Wed 2nd Nov | ANONYMOUS | |
6 mins later | ANONYMOUS | |
27 mins later | Gordon R. | |
45 hours later | Cohen R. | |
45 hours later | Cohen R. | |
46 hours later | Gordon R. | |
2014 Exam Q10. (both) | ||
12:15pm Wed 2nd Nov | ANONYMOUS | |
29 mins later | Gordon R. | |
Practice Lab Solutions | ||
9:32am Wed 2nd Nov | Gordon R. | |
Indexing (all 3) | ||
9:42am Tue 1st Nov | Amanda B. | |
22 mins later | Gordon R. | |
28 mins later | Amanda B. O.P. | |
Exam Qs help (all 3) | ||
10:25pm Mon 31st Oct | ANONYMOUS | |
10 hours later | Gordon R. | |
11 hours later | Gordon R. | |
insertion anomaly (both) | ||
6:38pm Mon 31st Oct | ANONYMOUS | |
13 hours later | Gordon R. | |
RA Natural Join and Cartesian (all 3) | ||
5:35pm Mon 31st Oct | Amanda B. | |
13 hours later | Gordon R. | |
14 hours later | Amanda B. O.P. | |
Exam Structure (all 4) | ||
11:44am Mon 31st Oct | ANONYMOUS | |
19 hours later | Gordon R. | |
34 hours later | ANONYMOUS O.P. | |
43 hours later | Gordon R. | |
UWA week 43 (2nd semester, study break) ↓ |
||
Project marks (both) | ||
9:08pm Thu 27th Oct | ANONYMOUS | |
12 hours later | Gordon R. | |
Mid-sem papers (both) | ||
4:36pm Wed 26th Oct | ANONYMOUS | |
5 mins later | Gordon R. | |
Revision (all 6) | ||
8:27pm Mon 24th Oct | Meg G. | |
10 hours later | Gordon R. | |
21 hours later | ANONYMOUS | |
21 hours later | Gordon R. | |
66 hours later | ANONYMOUS | |
7 days later | Gordon R. | |
Misuse of COUNT() error (all 4) | ||
8:00pm Mon 24th Oct | Neha M. | |
10 hours later | Gordon R. | |
14 hours later | Neha M. O.P. | |
19 hours later | Gordon R. | |
exam (all 4) | ||
8:44am Mon 24th Oct | ANONYMOUS | |
22 hours later | Gordon R. | |
10 days later | ANONYMOUS | |
10 days later | Gordon R. | |
UWA week 42 (2nd semester, week 12) ↓ |
||
Decomposition vs Normalization (both) | ||
4:09pm Sat 22nd Oct | ANONYMOUS | |
4 hours later | Gordon R. | |
Boyce codd NF (all 4) | ||
1:27am Wed 19th Oct | ANONYMOUS | |
5 hours later | Gordon R. | |
17 hours later | ANONYMOUS O.P. | |
19 hours later | Gordon R. | |
UWA week 41 (2nd semester, week 11) ↓ |
||
Assumption: Will update on dateBack = today's date? (all 4) | ||
4:38pm Sat 15th Oct | ANONYMOUS | |
39 hours later | Gordon R. | |
47 hours later | ANONYMOUS O.P. | |
48 hours later | Gordon R. | |
daysLoaned (all 3) | ||
4:34pm Sat 15th Oct | ANONYMOUS | |
6 mins later | ANONYMOUS | |
39 hours later | Gordon R. | |
ERD qn on relationship attributes (all 3) | ||
4:20pm Sat 15th Oct | ANONYMOUS | |
4 mins later | ANONYMOUS O.P. | |
39 hours later | Gordon R. | |
loan table -borrowing constraint (all 3) | ||
3:33pm Sat 15th Oct | ANONYMOUS | |
25 mins later | ANONYMOUS O.P. | |
40 hours later | Gordon R. | |
More CHECK problems (all 4) | ||
1:04pm Sat 15th Oct | Meg G. | |
3 hours later | ANONYMOUS | |
25 hours later | Meg G. O.P. | |
26 hours later | Meg G. O.P. | |
Submission Weekend | ||
5:45pm Fri 14th Oct | Gordon R. | |
additional constraints (all 3) | ||
5:23pm Fri 14th Oct | ANONYMOUS | |
7 mins later | Michael S. | |
19 mins later | Gordon R. | |
Regarding dateBack field (both) | ||
4:59pm Fri 14th Oct | ANONYMOUS | |
30 mins later | Gordon R. | |
Trigger when clause (all 3) | ||
4:50pm Fri 14th Oct | ANONYMOUS | |
37 mins later | Gordon R. | |
2 hours later | ANONYMOUS O.P. | |
cant load data in sqlite studio (all 4) | ||
4:39pm Fri 14th Oct | ANONYMOUS | |
7 mins later | Gordon R. | |
23 mins later | ANONYMOUS O.P. | |
44 mins later | Gordon R. | |
daysLoaned as Cumulative Function. (both) | ||
4:08pm Fri 14th Oct | Lilee L. | |
16 mins later | Gordon R. | |
CHECK constraint not working (all 4) | ||
3:06pm Fri 14th Oct | Meg G. | |
69 mins later | Gordon R. | |
21 hours later | Meg G. O.P. | |
47 hours later | Meg G. O.P. | |
Only one row updated with Trigger (both) | ||
3:03pm Fri 14th Oct | Amanda B. | |
70 mins later | Gordon R. | |
checking isbn numerics (all 4) | ||
12:21pm Fri 14th Oct | ANONYMOUS | |
47 mins later | ANONYMOUS | |
107 mins later | Gordon R. | |
3 hours later | ANONYMOUS O.P. | |
Project - Question 2(c) (all 3) | ||
11:40am Fri 14th Oct | ANONYMOUS | |
2 hours later | Gordon R. | |
3 hours later | ANONYMOUS O.P. | |
Project trigger (all 4) | ||
11:29am Fri 14th Oct | ANONYMOUS | |
2 hours later | Gordon R. | |
2 hours later | ANONYMOUS O.P. | |
4 hours later | Michael S. | |
Q2 Check constraint on Client and BookCopy (both) | ||
10:02am Fri 14th Oct | Lilee L. | |
4 mins later | Gordon R. | |
Getting error when typing an Update Statement (all 3) | ||
9:06am Fri 14th Oct | Amanda B. | |
59 mins later | Gordon R. | |
2 hours later | Amanda B. O.P. | |
ISBN from BookCopy and BookEdition (all 3) | ||
2:35am Fri 14th Oct | ANONYMOUS | |
5 hours later | Gordon R. | |
62 hours later | Chuanrui Y. | |
Questions about changes to clientId and IS/IS NOT operators (both) | ||
11:09pm Thu 13th Oct | Kelly S. | |
8 hours later | Gordon R. | |
is REGEXP allowed (all 3) | ||
10:45pm Thu 13th Oct | Nicolas G. | |
18 mins later | Nicolas G. O.P. | |
9 hours later | Gordon R. | |
Keys Display in ERD (both) | ||
9:49pm Thu 13th Oct | ANONYMOUS | |
10 hours later | Gordon R. | |
CHECK constraint (both) | ||
8:06pm Thu 13th Oct | ANONYMOUS | |
11 hours later | Gordon R. | |
Main Purpose of Views (both) | ||
7:31pm Thu 13th Oct | ANONYMOUS | |
12 hours later | Gordon R. | |
Update Trigger Issue (both) | ||
6:44pm Thu 13th Oct | ANONYMOUS | |
42 mins later | ANONYMOUS O.P. | |
foreign key activation (both) | ||
5:44pm Thu 13th Oct | ANONYMOUS | |
16 mins later | Michael S. | |
Trigger Issue (all 5) | ||
5:37pm Thu 13th Oct | ANONYMOUS | |
69 mins later | ANONYMOUS | |
109 mins later | ANONYMOUS | |
13 hours later | ANONYMOUS O.P. | |
14 hours later | Gordon R. | |
Entity (both) | ||
3:37pm Thu 13th Oct | ANONYMOUS | |
17 mins later | Gordon R. | |
julianday() (all 3) | ||
2:19pm Thu 13th Oct | ANONYMOUS | |
41 mins later | Michael S. | |
50 mins later | ANONYMOUS O.P. | |
project question  (both) | ||
1:56pm Thu 13th Oct | ANONYMOUS | |
61 mins later | Michael S. | |
Composite in ERD (all 4) | ||
12:04pm Thu 13th Oct | Amanda B. | |
45 mins later | Amanda B. O.P. | |
56 mins later | Gordon R. | |
57 mins later | Gordon R. | |
Foreign Key in ERD (both) | ||
11:32am Thu 13th Oct | Ka L. | |
75 mins later | Gordon R. | |
Transactions Question (both) | ||
10:52am Thu 13th Oct | ANONYMOUS | |
4 hours later | Gordon R. | |
Can daysLoaned be NULL? (both) | ||
12:44am Thu 13th Oct | ANONYMOUS | |
6 hours later | Gordon R. | |
VIEW constraint (both) | ||
12:06am Thu 13th Oct | Mahit G. | |
7 hours later | Gordon R. | |
Project Submission (both) | ||
8:27pm Wed 12th Oct | ANONYMOUS | |
11 hours later | Gordon R. | |
Question 3 in Project (both) | ||
6:28pm Wed 12th Oct | ANONYMOUS | |
12 hours later | Gordon R. | |
trigger accepted but not working (all 4) | ||
6:22pm Wed 12th Oct | Mahit G. | |
4 mins later | Mahit G. O.P. | |
5 hours later | Mahit G. O.P. | |
13 hours later | Gordon R. | |
how to constrain the ISBN are all numeric (all 3) | ||
6:11pm Wed 12th Oct | ANONYMOUS | |
68 mins later | ANONYMOUS O.P. | |
13 hours later | Gordon R. | |
Guide for Question 4 of Project (both) | ||
4:24pm Wed 12th Oct | ANONYMOUS | |
71 mins later | Michael S. | |
Project marking (both) | ||
4:24pm Wed 12th Oct | ANONYMOUS | |
15 hours later | Gordon R. | |
Resubmissions (both) | ||
2:51pm Wed 12th Oct | ANONYMOUS | |
9 mins later | Gordon R. | |
Participation Constraint (all 3) | ||
2:10pm Wed 12th Oct | Gordon R. | |
0 secs later | Gordon R. O.P. | |
73 mins later | Gordon R. O.P. | |
Clarification on Exam Rules (all 3) | ||
11:45am Wed 12th Oct | Ryan T. | |
2 hours later | Gordon R. | |
3 hours later | Gordon R. | |
Question about ReadingHistory View (both) | ||
10:50am Wed 12th Oct | Kelly S. | |
40 mins later | Gordon R. | |
Submission of Project (both) | ||
9:52am Wed 12th Oct | Lauren H. | |
96 mins later | Gordon R. | |
daysLoaned total (both) | ||
10:47pm Tue 11th Oct | ANONYMOUS | |
8 hours later | Gordon R. | |
2c ISBN (both) | ||
9:37pm Tue 11th Oct | Mahit G. | |
9 hours later | Gordon R. | |
Pet-Breed ERD diagram (both) | ||
9:26pm Tue 11th Oct | ANONYMOUS | |
10 hours later | Gordon R. | |
Question on ERD and BookCopy ISBN (all 5) | ||
7:19pm Tue 11th Oct | ANONYMOUS | |
11 hours later | Gordon R. | |
16 hours later | ANONYMOUS | |
4 days later | Chuanrui Y. | |
4 days later | Chuanrui Y. | |
Double check on due date (both) | ||
4:51pm Tue 11th Oct | Wenjie S. | |
110 mins later | Gordon R. | |
Data not reading in terminal (all 5) | ||
4:35pm Tue 11th Oct | ANONYMOUS | |
2 hours later | Gordon R. | |
3 hours later | ANONYMOUS O.P. | |
15 hours later | Gordon R. | |
15 hours later | Gordon R. | |
relationship between bookcopy and client (both) | ||
2:59pm Tue 11th Oct | Mahit G. | |
41 mins later | Gordon R. | |
ERD Primary Key Clarification (both) | ||
1:27pm Tue 11th Oct | ANONYMOUS | |
21 mins later | Gordon R. | |
Data Insertion Error (all 8) | ||
12:29pm Tue 11th Oct | ANONYMOUS | |
8 mins later | Gordon R. | |
9 mins later | ANONYMOUS O.P. | |
70 mins later | Gordon R. | |
97 mins later | ANONYMOUS O.P. | |
104 mins later | Gordon R. | |
2 hours later | ANONYMOUS O.P. | |
18 hours later | Gordon R. | |
Date format (all 3) | ||
1:49am Tue 11th Oct | Ka L. | |
5 hours later | Gordon R. | |
32 hours later | Ehsan A. | |
Null values checking (both) | ||
11:08pm Mon 10th Oct | Mahit G. | |
7 hours later | Gordon R. | |
ERD and foreign keys (both) | ||
10:08pm Mon 10th Oct | Mahit G. | |
9 hours later | Gordon R. | |
Questions about trigger and files to submit (both) | ||
7:20pm Mon 10th Oct | Kelly S. | |
23 mins later | Michael S. | |
Views (SELECT with quotation mark) (both) | ||
5:48pm Mon 10th Oct | ANONYMOUS | |
112 mins later | Michael S. | |
ISBN Check (both) | ||
4:56pm Mon 10th Oct | ANONYMOUS | |
3 hours later | Michael S. | |
Inserting the test data (both) | ||
4:27pm Mon 10th Oct | ANONYMOUS | |
3 hours later | Michael S. | |
I can't submit ERD.png (both) | ||
3:23pm Mon 10th Oct | ANONYMOUS | |
95 mins later | Gordon R. | |
ERD confirmation (both) | ||
12:51pm Mon 10th Oct | ANONYMOUS | |
37 mins later | Gordon R. | |
SQLite Studio Not opening database file (both) | ||
12:32pm Mon 10th Oct | ANONYMOUS | |
55 mins later | Gordon R. | |
UWA week 40 (2nd semester, week 10) ↓ |
||
LIKE Statement Using Ranges NOT Working (both) | ||
10:30pm Sun 9th Oct | ANONYMOUS | |
8 hours later | Gordon R. | |
ISBN validation (all 4) | ||
9:41pm Sun 9th Oct | ANONYMOUS | |
83 mins later | Michael S. | |
94 mins later | ANONYMOUS O.P. | |
9 hours later | Gordon R. | |
Project sample data not working (all 8) | ||
3:02pm Sun 9th Oct | ANONYMOUS | |
10 mins later | Michael S. | |
22 mins later | ANONYMOUS O.P. | |
30 mins later | Michael S. | |
40 mins later | ANONYMOUS O.P. | |
45 mins later | ANONYMOUS O.P. | |
47 mins later | ANONYMOUS O.P. | |
55 mins later | ANONYMOUS O.P. | |
Results are different between terminal(powershell) and sqlite studio (all 7) | ||
2:12am Sun 9th Oct | ANONYMOUS | |
8 hours later | Michael S. | |
8 hours later | Michael S. | |
17 hours later | ANONYMOUS | |
18 hours later | Michael S. | |
29 hours later | Gordon R. | |
42 hours later | ANONYMOUS O.P. | |
Booedition (all 3) | ||
1:26am Sun 9th Oct | ANONYMOUS | |
74 mins later | ANONYMOUS O.P. | |
9 hours later | Michael S. | |
foreign key constraint (all 3) | ||
10:56pm Sat 8th Oct | ANONYMOUS | |
14 mins later | ANONYMOUS O.P. | |
54 mins later | Michael S. | |
update loan-trigger (both) | ||
9:40pm Sat 8th Oct | ANONYMOUS | |
42 mins later | Michael S. | |
ISBN in BookCopy (both) | ||
9:38pm Sat 8th Oct | ANONYMOUS | |
37 mins later | Michael S. | |
Problem with loading the sample project data (all 3) | ||
7:52pm Sat 8th Oct | ANONYMOUS | |
21 mins later | Michael S. | |
86 mins later | ANONYMOUS O.P. | |
Triggers (all 8) | ||
5:07pm Sat 8th Oct | ANONYMOUS | |
53 mins later | Michael S. | |
3 hours later | ANONYMOUS O.P. | |
4 hours later | Michael S. | |
4 hours later | ANONYMOUS O.P. | |
5 hours later | Michael S. | |
6 hours later | ANONYMOUS O.P. | |
6 hours later | Michael S. | |
ERD problem relationships (both) | ||
3:40pm Sat 8th Oct | ANONYMOUS | |
2 hours later | Michael S. | |
Using the Project Data (both) | ||
3:38pm Sat 8th Oct | ANONYMOUS | |
2 hours later | Michael S. | |
Primary Key Allocation (both) | ||
2:28am Sat 8th Oct | ANONYMOUS | |
10 hours later | Michael S. | |
help1402 may be unattended over the weekend | ||
5:14pm Fri 7th Oct | Gordon R. | |
Error when inserting project data (both) | ||
3:00pm Fri 7th Oct | ANONYMOUS | |
8 mins later | Andrew W. | |
How to use projectData.sql (both) | ||
1:46pm Fri 7th Oct | Kelly S. | |
3 hours later | Gordon R. | |
Submit task (both) | ||
1:05pm Fri 7th Oct | Cohen R. | |
36 mins later | Gordon R. | |
Project - View Null clientId (all 3) | ||
9:45pm Thu 6th Oct | Tu H. | |
10 hours later | Gordon R. | |
50 hours later | Tu H. O.P. | |
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 | Gordon R. | |
Wording not clear question 2a (both) | ||
9:08pm Wed 5th Oct | ANONYMOUS | |
10 hours later | Gordon R. | |
dateBack < dateOut (all 4) | ||
3:23pm Wed 5th Oct | Kyle C. | |
2 mins later | Kyle C. O.P. | |
74 hours later | ANONYMOUS | |
80 hours later | Michael S. | |
Trigger (all 4) | ||
2:45pm Wed 5th Oct | Wenjie S. | |
75 mins later | Gordon R. | |
9 days later | ANONYMOUS | |
9 days later | ANONYMOUS | |
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 | Gordon R. | |
BookCopy and BookEdition (all 6) | ||
12:06am Wed 5th Oct | Wenjie S. | |
6 hours later | Gordon R. | |
8 hours later | Yinyin W. | |
9 hours later | Gordon R. | |
64 hours later | ANONYMOUS | |
6 days later | ANONYMOUS | |
SubString in sqlite with Ints (both) | ||
2:44pm Tue 4th Oct | Amanda B. | |
17 mins later | Gordon R. | |
ERD (all 6) | ||
1:54pm Tue 4th Oct | ANONYMOUS | |
72 mins later | Gordon R. | |
4 days later | Mahit G. | |
4 days later | Mahit G. | |
6 days later | ANONYMOUS | |
6 days later | ANONYMOUS | |
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 | 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 | 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 4) | ||
4:33pm Sun 2nd Oct | Andrew W. | |
4 days later | ANONYMOUS | |
4 days later | Andrew W. O.P. | |
5 days later | Andrew W. O.P. | |
Submission of project file (both) | ||
2:25pm Sun 2nd Oct | ANONYMOUS | |
80 mins later | 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 | 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. | |
List of Project Corrections | ||
7:42am Sat 1st Oct | Gordon R. | |
Julian date calculation (both) | ||
2:51am Sat 1st Oct | ANONYMOUS | |
3 hours later | Gordon R. | |
Trigger question (all 3) | ||
1:09am Sat 1st Oct | ANONYMOUS | |
5 hours later | Gordon R. | |
12 days later | ANONYMOUS | |
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 | Tu H. | |
2 hours later | Gordon R. | |
Indicating a composite key in ERD (all 5) | ||
3:51pm Fri 30th Sep | ANONYMOUS | |
2 hours later | Gordon R. | |
9 days later | ANONYMOUS | |
9 days later | Pritam SS. | |
9 days later | ANONYMOUS | |
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 (all 3) | ||
3:01pm Wed 28th Sep | Mahit G. | |
61 mins later | Gordon R. | |
35 days later | ANONYMOUS | |
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 | 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 | Andrew W. | |
7 hours later | ANONYMOUS | |
usage of EXCEPT (both) | ||
2:37pm Fri 16th Sep | ANONYMOUS | |
23 mins later | Gordon R. | |
Lab Week 7 Q11 (all 4) | ||
1:49pm Fri 16th Sep | Amanda B. | |
22 mins later | 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 | Gordon R. | |
Test Topic (both) | ||
10:20am Thu 15th Sep | ANONYMOUS | |
2 hours later | 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 | 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 | Gordon R. | |
Writing Query (both) | ||
11:42am Wed 14th Sep | Zubayr R. | |
2 hours later | 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 | 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 | 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 | Gordon R. | |
8 days later | Ryan T. O.P. | |
9 days later | ANONYMOUS | |
9 days later | Ryan T. O.P. | |
9 days later | 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 | 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 | 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 | Gordon R. | |
87 hours later | Robert B. | |
Week 4 Lab Assignment Marks Release (both) | ||
6:32pm Thu 25th Aug | ANONYMOUS | |
12 hours later | 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 | 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 | 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 | 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 | 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 | Michael S. | |
32 mins later | 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 | 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 | 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 | ANONYMOUS | |
25 mins later | Gordon R. | |
.read in SQLite Studio (all 3) | ||
3:22pm Thu 11th Aug | ANONYMOUS | |
6 mins later | 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 | 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 | Gordon R. | |
94 mins later | Gordon R. | |
101 mins later | Gordon R. | |
15 hours later | Warren C. | |
19 hours later | Gordon R. | |
23 hours later | Andrew W. | |
24 hours later | 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 | Gordon R. | |
27 mins later | Michael S. | |
27 mins later | 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 | 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 | Gordon R. | |
Lab 2 Submission (all 3) | ||
11:46am Fri 5th Aug | ANONYMOUS | |
27 mins later | Michael S. | |
77 mins later | 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 | 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 | 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 | Shalini M. | |
51 hours later | 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 | 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 | Michael S. | |
2 hours later | 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 | 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 | 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 | 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 | Gordon R. | |
45 hours later | ANONYMOUS | |
56 hours later | Amanda B. | |
67 hours later | ANONYMOUS | |
68 hours later | 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 | Michael S. | |
88 mins later | 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 | 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 (mid-year break) ↓ |
||
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. | |