Skip to content
Aussieveedubbers

Who wants to do my database assignment?

0 likes
Share Share on Facebook Share on X Share on Reddit
Log in to reply

Da Wiz Officially Full-On Dubber

330 posts · joined Dec 2002 ·

#103475
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 kombi pilot

3,187 posts · joined Aug 2002 ·

#103514
Da Wiz wrote: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 kombi pilot

3,187 posts · joined Aug 2002 ·

#105066
: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 kombi pilot

3,187 posts · joined Aug 2002 ·

#105173
err up to 33% now
Chris.... kombi pilot, oval dreamer... finisher #26971 2005 city to surf