Written Paper
Section II
Question 21 - 2002 HSC
Describe the role of a file server on a network. Identify data redundancy in a database and outline the problems it may cause as the size of the database increases. Normalise the database, identifying primary and foreign keys.
Written Paper
Section II
Question 22 - 2002 HSC
Identify and outline an appropriate transmission medium for segments in the public telephone network. Outline the advantages of using mobile technology for work. Describe how a data dictionary can be useful in writing SQL queries.
Written Paper
Section II
Question 23 - 2002 HSC
Identifying information technology within an information system. Propose and outline two different types of information systems that could be used to analysing purchasing trends.
Written Paper
Section II
Question 21 - 2002 HSC
Describe the role of a file server on a network. Identify data redundancy in a database and outline the problems it may cause as the size of the database increases. Normalise the database, identifying primary and foreign keys.
Written Paper
Section II
Question 22 - 2002 HSC
Identify and outline an appropriate transmission medium for segments in the public telephone network. Outline the advantages of using mobile technology for work. Describe how a data dictionary can be useful in writing SQL queries.
Written Paper
Section II
Question 23 - 2002 HSC
Identifying information technology within an information system. Propose and outline two different types of information systems that could be used to analysing purchasing trends.
Written Paper
Section III
Question 27 - 2002 HSC
Describe CAD. Identify two actuators and describe a situation in which each would be used. Draw a block diagram for a letter-sorting system. Explain advantages and disadvantages of using barcodes in commercial applications. Describe and analyse automative warehouse system in terms of collecting, processing and displaying.
Written Paper
Section III
Question 26 - 2002 HSC
Define and give an example of two terms: structured problem and certainty factor. Design a spreadsheet to compare mobile phone plans and outline how different types of graphs could assist in the decision making. Describe and analyse a decision support system in terms of organising, analysing and processing.
Written Paper
Section III
Question 28 - 2002 HSC
Distinguish between LCD screens and CRT monitors and between path-based and cell-based animation. Draw a storyboard for a website using good design principles. Describe and analyse the system in terms of collecting, organising and displaying. Note: Question b (ii) is no longer applicable for the current syllabus. However, the calculation examples can be used to formulate an understanding of storage requirements for a given image file.
Written Paper
Section III
Question 25 - 2002 HSC
Define batch processing and describe a situation where it is appropriate. Distinguish between data accuracy and data integrity. Draw a dataflow diagram for a scenario, showing external entities and data stores. Discuss back-up procedures for the system. Describe and analyse an on-line ticketing system in terms of collecting; storage and retrieval; and processing. Note: 'Data accuracy' has been replaced with 'data quality' in the current syllabus.
Written Paper
Section II
Question 24 - 2002 HSC
Translate a decision tree into a decision table. Discuss the importance of user documentation for an online store. Identify two social or ethical issues in the design of the online store and propose how they can be addressed.
