Posts: 330
Threads: 27
Registered: December 11th, 2002
Member Is Offline
Location: Perth, WA
Theme: UltimaBB Pro Blue ( Default )
Mood: ¯`·.¸¸.·´¯`·.¸¸
posted on October 24th, 2003 at 02:09 PM
Well I'd say the first question would be something along the lines of ...
select certified.aircraftid, certified.employeeid, airemployee.employeename
from certified, airemployee
where certified.aircraftid = 'Boeing';
or something like that, that's all you need, now you should be able to do the rest yourself
Gotta love the SQL
Cheers Isaak
¯`·.¸¸.·´¯`·.¸¸.-> Keepin' it Real !!
amazer
Bishop of Volkswagenism
kombi pilot
Posts: 3187
Threads: 308
Registered: August 26th, 2002
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: Peachy!
posted on October 24th, 2003 at 03:59 PM
Quote:
Originally
posted by Da Wiz
Well I'd say the first question would be something along the lines of ...
select certified.aircraftid, certified.employeeid, airemployee.employeename
from certified, airemployee
where certified.aircraftid = 'Boeing';
or something like that, that's all you need, now you should be able to do the rest yourself
Gotta love the SQL
Cheers Isaak
hmmm you're not too far off.
Unfortunately I dont think there are any marks available to you, that was a relational algebra question not SQL.
The questions are stupid. Do question 3. What sort of plane can only fly from Sydney to Tokyo? If there is such a plane I bet they dont sell too well.
The only thing I can figure is that Sydney to Tokyo is the shortest flight offered.
Chris.... kombi pilot, oval dreamer... finisher #26971 2005 city to surf
amazer
Bishop of Volkswagenism
kombi pilot
Posts: 3187
Threads: 308
Registered: August 26th, 2002
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: Peachy!
posted on October 28th, 2003 at 11:22 AM
:cry
too hard.
I think I have enough to get maybe 25% so far.
Someone help me either of these and I might be able to work things out from there.
partB question 2, 3, 7, 9, or 10.
Chris.... kombi pilot, oval dreamer... finisher #26971 2005 city to surf
amazer
Bishop of Volkswagenism
kombi pilot
Posts: 3187
Threads: 308
Registered: August 26th, 2002
Member Is Offline
Location: Wollongong
Theme: UltimaBB Pro Blue ( Default )
Mood: Peachy!
posted on October 28th, 2003 at 03:28 PM
err up to 33% now
Chris.... kombi pilot, oval dreamer... finisher #26971 2005 city to surf
