bazookajoe
Shy Guy
- Joined
- May 23, 2005
- Messages
- 3,207
- Gender
- Male
- HSC
- 2006
Re: Semester 1 Chatter Thread
I hardly ever stress, it's kinda awesome
I hardly ever stress, it's kinda awesome
Well played.JFK said:He's too busy recovering from State of Origin.
I haven't heard anything to that effect, but then again I have a perfect record (literally 100%, it's fucking amazing) of lecture non-attendance for said subject.goony said:I forget, but do you have to hand in the cheat sheet at the end of the exam?
qfthistorykidd said:Well played.
Although 32 metres doesn't really warrant a recovery.
I went to bed a 2pm, finishing of my sociology of health essay, worth 55%!!!!!!!!!!!!!!stazi said:went to bed at 5am Now have to get printing done
I'm not sure we need to know about jdbc/stored procedures/OLAP etc. if we're doing 2820, and for jdbc and stuff, pseudocode will do apparently. Alan (lecturer) said that stuff would be for info2120 only and the advanced guys do 2820 material instead, which is pretty sweet because i have no clue about stored procedures.withoutaface said:I haven't heard anything to that effect, but then again I have a perfect record (literally 100%, it's fucking amazing) of lecture non-attendance for said subject.
Dude are you doing INFO2120/2820 as well (if 2820 I have a question).
EDIT: Actually this exam's looking fairly sweet, confused about whether JDBC stuff fits into the exam at all, but getting 80% should be fairly easy (Adv components could be tricky cause I have zero idea what to do with recursive and hierarchical SQL
Sat at the back for the ones I did attend, left a few early, arrived late, skipped most of the last few. Yeah I'm a pretty bad student.goony said:I'm not sure we need to know about jdbc/stored procedures/OLAP etc. if we're doing 2820, and for jdbc and stuff, pseudocode will do apparently. Alan (lecturer) said that stuff would be for info2120 only and the advanced guys do 2820 material instead, which is pretty sweet because i have no clue about stored procedures.
as for recursive and hierarchical stuff, apparently you get a choice between using recursive and hierarchical sql. IMO i'd just use recursive because it's structured pretty similarly to the datalog stuff we did.
dude, i probably saw you in some of the 2820 classes, were you at the back of those 'tutorials' in eastern ave or just didnt bother to show up to those?
WITH temp(N1, N2) AS
(SELECT N1, N2
FROM supervises
CONNECT BY PRIOR N2=N1);
WITH Expert (tfn, make, model) AS
(SELECT *
FROM Qualified
UNION ALL
SELECT Expert.tfn, s.substituteMake, s.substituteModel
FROM Expert, Substitute AS s
WHERE Expert.make = s.make AND Expert.model = s.model);
SELECT *
FROM Technician AS t
WHERE EXISTS
(SELECT *
FROM Plane AS p
WHERE p.owner = 'Qantas' AND (t.tfn, p.make, p.model) IN Expert);
I'm not too good with the hierarchical stuff (the only question i miffed in the last assignment...yet still sanjay gave me full marks for it? :/)...but anyway, i think you need CONNECT_BY_ROOT or something in the select line of that query to make it work. I missed the last tutorial as well, apparently he mentioned all of this there...i'll grab it off a friend when she comes online or something.withoutaface said:Sat at the back for the ones I did attend, left a few early, arrived late, skipped most of the last few. Yeah I'm a pretty bad student.
If you've done the adv revision activity, can you tell me whether this works for calculating out the supervision hierachy in 1b?
I understand the hierarchical stuff if the above's accurate, but the recursive stuff I have no idea (well, I've found some stuff on the net, but it doesn't make a whole lot of sense to me) and there's no examples on the site :/Code:WITH temp(N1, N2) AS (SELECT N1, N2 FROM supervises CONNECT BY PRIOR N2=N1);
EDIT: If it's similar to datalog I can dig, but wouldn't have a clue about the syntax
WITH RECURSIVE TCSub(make, model, submake, submodel)
AS
(SELECT make, model, submake1 AS make1, submodel1 AS model1 FROM Substitute)
UNION
(SELECT s.make, s.model, T.make1, T.model1
FROM Substitute s, TCSub T
WHERE s.submake=T.make AND s.submodel=T.model)
--another SELECT query here etc etc
CREATE VIEW TCSub(make, model, make1,model1) AS
SELECT connect_by_root make, connect_by_root model, submake,submodel
FROM Substitute
CONNECT BY NOCYCLE PRIOR submake = make AND PRIOR submodel = model
--then query your view to see it etc etc