A good way to study the IPT core topics (1 Viewer)

[goan_crazy]

We do this in the legal forum and its really helpful

How it works is person X asks a question and then person Y answers it AND posts another question and so on...

It can be from:
Project
Information systems and databases
Communication systems

I'll start

Question: Name the 5 types of information systems

 

[lislabella]

transaction processing systems
decision support systems
expert systems
managment information systems
office automation systems

I have a database of friends and family's addresses in a database called Addresses. The database fields include Firstname, Surname, Address, Phone Number, Birthday (DD,MM,YYYY).
Construct an SQL that I can use to determine all the people with birthdays in August, including Firstname, Address and Birthday, listing the first birthday first.

 

[melsc]

This is probably wrong, I suck at the date ones:-
SELECT Firstname, Address, Birthday
FROM (Name of table wasnt given)
WHERE Birthday =>31/08/1980 <=01/08/1980
ORDER BY Birthday asc

In which stage of the system development cycle is it the most expensive to find a problem with the system?

 

[goan_crazy]

This is probably wrong, I suck at the date ones:-
SELECT Firstname, Address, Birthday
FROM (Name of table wasnt given)
WHERE Birthday =>31/08/1980 <=01/08/1980
ORDER BY Birthday asc

In which stage of the system development cycle is it the most expensive to find a problem with the system?

implementing?

Next question:
In which stage of the system development cycle would you use a prototype?

 

[rama_v]

implementing?

Next question:
In which stage of the system development cycle would you use a prototype?

We argued this the other day but I believe the answer is Designing solutions, because this is where the problem is generally understood and the system designer would create the first prototpye. Keep in mind however that one of teh aims of a prototype is to better understand the problem, so one may argue that it belogns in teh first stage of the system development cycle.

Explain the difference between a router and a gateway, and outline two situations in which they would be used

 

[techno_freak]

Would it be Understanding the Problem?

Question: Where in the system development cycle would Social and Ethical issues come into play?

 

[rama_v]

Would it be Understanding the Problem?

Question: Where in the system development cycle would Social and Ethical issues come into play?

Yeah our teacher said it could be both so its hard to say. I thought social and ethical issues would come in mainly during designing solutions right?

 

[techno_freak]

Yeah our teacher said it could be both so its hard to say. I thought social and ethical issues would come in mainly during designing solutions right?

Thats what i thought as well but our teacher said it was in the testing, evaluating and maintaing cause you re-evaluate the social and ethical issues

 

[rama_v]

Thats what i thought as well but our teacher said it was in the testing, evaluating and maintaing cause you re-evaluate the social and ethical issues

ahh ok, thats probably right. But it seems silly tha social and ethical issues are not considered during the desinging solutions phase...

 

[goan_crazy]

ok next question:
What is normalisation?

 

[rama_v]

ok next question:
What is normalisation?

Normalisation is the process of eliminating redundant data in a database.

Explain the three levels of normalisation

 

[techno_freak]

Explain the difference between a router and a gateway, and outline two situations in which they would be used

A router identifies the destination address and determines the fastest route
Situtation 1: Perhaps it can be used in a school environment with serval different buildings which need to be linked back to the file server

A gateway links two LANs with protocols with are different
Situation 2: umm this one [taking a guess] could be used when you need to change protocols so from a TCP/IP which is like the internet i.e online company which connects to a Sydney warehouse which manages the stock ??? is that right

 

[goan_crazy]

Normalisation is the process of eliminating redundant data in a database.

Explain the three levels of normalisation

i'm not sure... Didn't learn this
what is the answer rama?

 

[rama_v]

i'm not sure... Didn't learn this
what is the answer rama?

Well the three are:

(First Level) Organising data into tables - reduce data redundancy by eliminating repeated fields. Data is separated into more tables in this level, and relationships are defined between them

(Second Level) Checking that no field values can be derived from another field, e.g. Checking deleting an "age" field if the "birthdate" field already exists.

(Third Level) No duplicate information is permitted. For example if two tables require an address, then a separate table is created speficialyl for this purpose and then linked.

 

[goan_crazy]

thanks rama...didn't know that

Next question: What is a protocol?

 

[lislabella]

This is probably wrong, I suck at the date ones:-
SELECT Firstname, Address, Birthday
FROM (Name of table wasnt given)
WHERE Birthday =>31/08/1980 <=01/08/1980
ORDER BY Birthday asc

In which stage of the system development cycle is it the most expensive to find a problem with the system?

correctamundo baby doll... i don't know about the year though... i don't think you can make it just pick a month can you?!

Protocol: a set of rules that control a communication link

active listening involves:..............................................
that was in my trial multiple choice

 

[techno_freak]

Active listening involves taking on board what you have heard and applying it to the task at hand

Question: what is the difference between System Analysts and System Designers?
I think that was the question in the CSSA trial

 

[DigitalFortress]

system analysts check the operation of the system against the original objectives,needs and boundaries.

system designers create screens,flowcharts and diagrams,code to help development in the system

(took a stab in the dark)

Some students sneak an exam out of their exam room and post the questions on an internet forum giving those who haven't sit the exam yet an unfair advantage, over class mates who do not visit the forum. What social and ethical issues does this infringe?

 

[DigitalFortress]

Some students sneak an exam out of their exam room and post the questions on an internet forum giving those who haven't sit the exam yet an unfair advantage, over class mates who do not visit the forum. What social and ethical issues does this infringe?

All of them.
GG you fucking dickheads.



What is a proxy server?

 

[Famine]

thanks rama...didn't know that

Next question: What is a protocol?

A protocol is a set of rules or standards which govern communication between computers and also between computers and peripheral devices.

Next Question: What are some advantages of Real time processing as opposed to batch processing.