And now that MS has a new version of Office, who is upgrading and can sell me their older version. Mine is a cut down cheapo version without access or powerpoint.
Black_math ·
Ile do it i gotta do one at school, teh olny thing is id be expecting some money. an dolny if i had to do taht database part no algebra for me
Anthiron ·
i just finished a huge IPT access assignment and i really cant say i feel like doing another
Bizarre ·
HAH!!! Eazy peezy!!
I wiuld be embarrased to help you on THAT simple question!!!
Money - i would PAY you!!! It is SOOOOO easy!!!
I will just sit in the corner with a beer until you do it.
Barry
amazer ·
:beer now why didnt I think of that earlier!
Brad ·
Black_math wrote:Ile do it i gotta do one at school, teh olny thing is id be expecting some money. an dolny if i had to do taht database part no algebra for me
I am guessing you have a lot of problems with SQL typing like that, I can't even understand what you are on about.... how the hell with the Little Man in My Computer !!!
MickH ·
Be nice Brad...He's "touch typing" Wots he touching hehehehehe:vader
WOOHOOOO!!!!NEW SIGNATURE!!!!!!!!!!!!!!!!
Brad ·
man I will swap you a VB.net assignment for it in a flash. I can have the answers to those question to you tommorrow 😀
Wanna swap ??
I am guessing you run it in WinSql or sumthin ... If only I hadn't of run out of SQL subjects and had to start doing GUI CRAP !!!!! 🙁🙁
Oh well back to VB.POO.NET
:bounce:bounce
amazer ·
hmmm nup. beer didnt work.
maybe if I have another one?
MickH ·
Lets colour in the page:bounce
amazer ·
I can only do java gui and even that would take me a month. If I'm accessing databases thru java I use Access at uni or mySQL here at home. But for the java subject they are just basic statements with no joins or anything. mySQL is missing a lot of things. Like date. Like foreign keys. stupid.
For this database subject with the joins and nested queries I use the uni's Oracle server over the net which is a PITA.
amazer ·
whats with you guys sig pictures. I see red crosses.
Black_math ·
Just cause i cant type, and teh has been accepted as a word these days anybody with puters know it cause were al too lazy to fix it up. STOP BAGING MY TYPEING:P
Brad ·
So reading the spec, you are going to have to run it in something. We are talking real SQM not MySql or Access SQL etc etc.
Nested Queries are cool, they make it very easy to follow the grouping side of things.
Bummer about the VB.net I was getting excited thought I could get out of VB.net 🙁
Are you doing IT or business ?
jenz58 ·
Have I missed something? Are you really meant to know about a particular pilot and which light he is on???? Then compute it all in algebra type thingy
Or do you make up all the flight stuff but have it come out as something that looks real?????
I can send you flight info but not who's flying or their salary:o
OK I read this quick and have no idea here
I mean if you can find the info on the pilots, flights etc then view source or something copy and paste in the right places, does that get your answer?????
This is why I never ever even considered a career in this area😀
Brad ·
😉 :kiss
vanderaj ·
I can't believe "typeing"... it would be faster to spell correctly. 🙂 Only kidding!
Chris and Brad, isn't the idea of assignments to learn something? 😉
Andrew
amazer ·
It will be run on Oracle.
Jen I got no idea about the algebra stuff. Absolute none. I dont even know why it exists. Must have slept through those lectures.
The Structured Query Language stuff is about getting a computer to do all your cutting and pasting. Doing it yourself will work for my assignment but probably not for the Commonwealth bank who would have to search through millions of records to cut and paste.
I've got the basics of SQL sussed. I can do a lot of the medium to hard questions from the textbook, but almost none from this bloody assignment.
Brad ·
vanderaj wrote:I can't believe "typeing"... it would be faster to spell correctly. 🙂 Only kidding!
Chris and Brad, isn't the idea of assignments to learn something? 😉
Andrew
You think you are my DAD ???:bounce
Chris if you get stuck drop me an email and I maybe able to help you out.
amazer ·
vanderaj wrote:Chris and Brad, isn't the idea of assignments to learn something? 😉
Oh cmon, which idealistic world were you brought up in. I just want 6 credit points so I can finish this degree, buy some occy straps, and start pushing shopping trolleys!
I'm off to bed guys. If you could all do 1 question each and email it to amazer39@yahoo.com that would be sweet. See you tomorrow 😉
Black_math ·
Its not important on teh spelling if pple can understand you theer is no problems😀
jenz58 ·
Chris get a job where you can pay someone to do all of this:thumb
Went out with my old friends last night. Dayle met me after work, Paul her husband rang. Main ANZ computer down (the BIG ONE), branches, data processing centres, everywhere - he was a couple of hours late cos he's in charge of getting them up:jesus
dodge ·
oh this sounds good! how bout I do Chris' SQL assignment and you two can be assignment buddies and do my .NET assignment and Brad's .NET assignment!!
WOOHOO! :bounce
....only thing is... its due on monday.... do u think u can have it done by then?? 😀
Brad ·
dodge wrote:oh this sounds good! how bout I do Chris' SQL assignment and you two can be assignment buddies and do my .NET assignment and Brad's .NET assignment!!
WOOHOO! :bounce
....only thing is... its due on monday.... do u think u can have it done by then?? 😀
Guess I am just lucky that it was due tonight so I have already done it hey 😀
Bugged Again ·
Its a shame not many people can spell any more, mus tbe a part of the brain that doesn't function properly 😀
Brad do I get one of those new fangled signatures as well?? Will get the baja runninmg one day.
Brad ·
You can have one, I have a Baja one as well as a buggy one 😀
What name ?
amazer ·
errr this is about MY assignment. I've checked my mail and there are no answers!
I still dont see any signatures, just red crosses.
modulus ·
The way I learned SQL was to use the Access WYSIWYG query editor in WYSIWYG mode and then read the SQL which it generated....
Of course, you wouldn't use shortcuts like this on an assignment...
BiX ·
I'll trade,I can get the SQl done if somebody will do my thesis due in 2 weeks. "waste water and fat racovery system analysis for gelita australia"
Haven't even started writting it yet🙁
but have finally finished testing 250 waste water samples!!!!!!!!
Jay_1965vw ·
Black_math wrote:Its not important on teh spelling if pple can understand you theer is no problems😀
I think the problem Black Math, is that half the time we can't understand you - or we have to read what you say 3 times before we do.
Its not just you young lot (can't believe I just said THAT!) Look at Birchall's spelling... or lack of :P
😀
Mrs J
LMAO
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
amazer ·
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.
amazer ·
: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.