VCE IT Helpdesk

[Bozo]

Question 7a, on Section B in the Vcaa 2008 IT APPS exam. Does anybody have an example or copy of the answer that would give full marks.

[Bozo]

Okay, what the hell is a query in database. What does it do. WHAT IS IT!

Any takers?

[Plan-B]

Okay, what the hell is a query in database. What does it do. WHAT IS IT!

Queries are basically functions performed on a database management system that filters out data to present the user with specific records.
For example, if had an age field and only wanted to see records of people who were older then 45 years, you would perform a query with the criteria under the age field >45 . This will bring back results with only records whose age is greater then 45.

Hopefully thats kinda understandable

Question 7a, on Section B in the Vcaa 2008 IT APPS exam. Does anybody have an example or copy of the answer that would give full marks.

Check:
http://www.vceit.com/postmortems/2008ita/index.htm

[Uchiha_Jax]

http://img16.imageshack.us/img16/3951/img1287z.jpg   (removed img tags due to large image)

the above image is my task, I was wondering if someone could assist me in what sort of direction I could tackle this.

Thank-you in advance (:

[Lasercookie]

I'm guessing this is your database task? Since this is ITA, you won't have to create the software to produce the text file, just the underlying relational database for some imaginary software. Start with writing out what tables and fields you need. From there you can work out relationships, etc.

It's pretty interesting that you're teacher's sacs are pretty ambiguous.

EDIT: Wait, this is a software development task. Can't really help you out but I can take a guess. Might be completely wrong.
Well I guess your software would be something like:

1. Open the text file

2. Read the file, line by line probably.
I would be thinking something like a while loop, where it takes in the data line by line and then puts into some kind of array/list. (or an object oriented structure)

3. It should be fairly simple to sort the array by the reorder level now.

4. Now maybe another loop to output the contents of the array into the new textfile.

I probably didn't help much.

[Uchiha_Jax]

Yeah it's Software probably should have specified that, our teacher isn't really here much / doesn't provide much assistance / resources at all to complete tasks, struggling to find any kind of online help with this let alone able to read what the task is asking -.-

[huss48]

that is sure is a software development task, as i seen it before..

Where are everyone up to in IT Apps so i know wat do upload next 

[Lasercookie]

Yeah it's Software probably should have specified that, our teacher isn't really here much / doesn't provide much assistance / resources at all to complete tasks, struggling to find any kind of online help with this let alone able to read what the task is asking -.-

Hmm... well I guess you could try to scout out some people on here that do software development, get into discussions with them.

I'd also make sure you print out a copy of the study design and ensure that you understand each point, read the textbook religiously etc.  I'm not doing SD myself so I don't really have much of an idea about what's expected etc.

You could also look at some general programming websites/tutorials. Most programming forums will frown upon asking for homework help however.

[Lasercookie]

Where are everyone up to in IT Apps so i know wat do upload next 

I'm currently doing my Unit 3 Outcome 2 database SAC. That will be dragging going on for the next few weeks since exams etc. get in the way.

Thanks for all the resources you've uploaded so far

[conorp]

In terms of information systems, Why is data an integral component in an information system?

[Lasercookie]

In terms of information systems, Why is data an integral component in an information system?

Data is the raw facts that are manipulated/processed into a meaningful and useful form (called information). I guess it's integral because without data you cannot have information and an information system without information would be quite useless.

That's my understanding of it anyway.

Edit: The answer given in the Nelson solutions manual (for the old textbook, but still the exact same question):

Why is data an integral component in an information system?
Data an integral component in an information system because information systems need data to manipulate and process into information.