IPT "Last Minute" Question and Answer (1 Viewer)

[ZzJasonzZ]

I thought this worked well for the SDD thread.. post questions you have and someone will answer them..

1) Please don't post comments in this thread.

2) Questions and replies to questions only.

3) Please don't repeat your question if not answered.

=)

 

[last.minute]

I got a question:
Every topic, there is sumthin like "example of information system" (except topic 1)
eg. database topic, they ask about school, rta and video rental's info sys.
Do we need to know every one of them in detail?

thats like more than 10 frign information systems! whats the point?

 

[rckl]

the point is to show you what are 7 information processes for each different type of information systems. so in the exam, you will probably finds out there will be something similar to what you have studied.

 

[ar5ena1]

getting the answer now...

 

[ar5ena1]

the idiot on the advice line wouldn't get drawn on saying whether or not we actually needed to learn about the rta etc.

but in general, they aren't going to say

"from you're studies of the rta database system describe the participants involved"

we can assume this because they have never done it before, and it would be a grossly unfair question. i'd just know in general whats involved (common sense), and thats it.

 

[Seraph]

Heres one for ya :

couldnt seem to udnerstand it too well ,

Normalise this database into two tables, showing all the data and clearly
identifying the primary and foreign keys.



APPARENTLY , you cannot make the Relationship off the UNIQUE key , Computer_number... why is this??? I thought relationships have to be formed off a unique key
check it out ..

 

[adrianp]

Whats the difference between a Primary key and secondary key

and whats a good definiiton for each?

 

[rckl]

weird question........ well in that case maybe you need to add another column yourself to make it unique or as a primary key?


that is the best way.. i believe... because a primary key cannot be empty or null, it must contain a value which is not similar

 

[lostki3nt_au]

Primary key is a unique record in a db, eg student_id because there can only be 1 student id for each student?
secondary key is not necessarrily unique to a record but can be applied in one or more records. eg surname.

also normalisating, means u gotta split the table into 2 separate table i.e by location, for example having a separate table named "reception" and "manager's office". then u jst list the info again except takin out the location info. shove the storeroom somewhere =\

 

[DI2AGON]

in response to that case study question, you'll just get a general one on the exam... the other ones were pretty much there to help you get practice on analysing them, u dont actually have to study those case studies

 

[egnaro]

heres one:

if you were to do a query of m?t* , give 3 examples which could turn up from the search

and a longer question:

A retail organisation keeps data about its emplyees in a database:
-Emplyee: emplyeeID, Lastname, Firstname, address, suburb, postcode, an department
-Wage: EmployeeID, WeeklyPay, PayDate and weeklyTax

Describe the results of this SQL query:
Select firstname, lastname
From employee, Wage
Where Employee.department = "sport" AND wage.weeklypay > 1000
Order BY lastname

 

[rainonmay]

heres one:

if you were to do a query of m?t* , give 3 examples which could turn up from the search

and a longer question:

A retail organisation keeps data about its emplyees in a database:
-Emplyee: emplyeeID, Lastname, Firstname, address, suburb, postcode, an department
-Wage: EmployeeID, WeeklyPay, PayDate and weeklyTax

Describe the results of this SQL query:
Select firstname, lastname
From employee, Wage
Where Employee.department = "sport" AND wage.weeklypay > 1000
Order BY lastname

the first one: matthew, mitchel, metal wot eva u get the idea... ? - stands for one character. * - stands for one or more characters

Second one: It would show the first name and lastname of all employees who work in the department sports and has a weelky pay greater then 1000 and its sorted by the last name field

 

[rckl]

HSC 2003 paper, from board of studies


anyone know the answer? and how did u work it out?

 

[nan01]

anyone know the answer? and how did u work it out?

hmmm is it B? isnt it just the size of the no? lol i really dont know..thats my logical thinking for you!

 

[Fade33]

you just convert the reading at those times into binary.

so it goes 2 = 010
4=100
1 = 001

easy

 

[rckl]

Yes it is.....
but how??? i played with the number around but still counldn't get it to work... pls explain

 

[nan01]

oh my bad! yeah binary is right!

 

[Fade33]

ok, at sample 2, when you read across the graph it is at height 2.

2 in binary is 010.

at sample 3, when you read across the graph it is at height 4.

4 in binary is 100

at sample 4, when your read across the graph it is at height 1.

1 in binary is 001

when you combine the 3, you get

010 100 001 = b