Component

Component: Information Systems and Databases

Question 1

Question 1

Written Paper Section I Question 1 - 2010 HSC

Use of a card-based system to determine location of a book

Question 1

Question 1

Written Paper Section I Question 1 - 2001 HSC

Computer based method for organisation data

Question 2

Question 2

Written Paper Section I Question 2 - 2010 HSC

Issue to consider when sending a digital photograph of another student in an email

Question 3

Question 3

Written Paper Section I Question 3 - 2002 HSC

Mode that does not support hypermedia

Question 4

Question 4

Written Paper Section I Question 4 - 2010 HSC

Statement about quality of data in a database when details are updated

Question 4

Question 4

Written Paper Section I Question 4 - 2002 HSC

Storage medium that does not support direct access

Question 4

Question 4

Written Paper Section I Question 4 - 2001 HSC

Components of a database schema

Question 7

Question 7

Written Paper Section I Question 7 - 2010 HSC

Statement referring to normalisation

Question 7

Question 7

Written Paper Section I Question 7 - 2002 HSC

Effective use of data warehouse

Question 8

Question 8

Written Paper Section I Question 8 - 2010 HSC

Term for screens and reports produced from a database

Question 9

Question 9

Written Paper Section I Question 9 - 2010 HSC

Approximate storage space required for records in a database

Question 9

Question 9

Written Paper Section I Question 9 - 2002 HSC

Non ethical practice in management of a medical information system

Question 10

Question 10

Written Paper Section I Question 10 - 2010 HSC

The schema for two new tables

Question 10

Question 10

Written Paper Section I Question 10 - 2001 HSC

Not an example of metadata

Question 11

Question 11

Written Paper Section I Question 11 - 2002 HSC

Method to narrow a search within a search engine

Question 14

Question 14

Written Paper Section I Question 14 - 2002 HSC

Output from an identified SQL statement

Question 15

Question 15

Written Paper Section I Question 15 - 2002 HSC

Selection of data using SQL

Question 16

Question 16

Written Paper Section I Question 16 - 2001 HSC

Selecting data using structured query language (SQL)

Question 17

Question 17

Written Paper Section I Question 17 - 2002 HSC

Data types within a data dictionary

Question 17

Question 17

Written Paper Section I Question 17 - 2001 HSC

Minimising data redundancy

Question 18

Question 18

Written Paper Section I Question 18 - 2010 HSC

Screen elements displayed in a sequence of screens

Question 19

Question 19

Written Paper Section I Question 19 - 2010 HSC

Purpose of a specified information system

Student Responses (17)

Exemplary response 1 Exemplary response 2 Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

Question 21

Question 21

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.

Student Responses (15)

Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

Question 22

Question 22

Written Paper Section II Question 22 - 2010 HSC

Describe the difference between thin and fat clients. Design a data dictionary for a school payment system. Explain how the message is organised into packets of data to be transmitted and reassembled. Explain an error detection technique.

Student Responses (17)

Exemplary response 1 Exemplary response 2 Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

Question 22

Question 22

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.

Student Responses (15)

Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

Question 22

Question 22

Written Paper Section II Question 22 - 2001 HSC

Explain an advantage and a disadvantage of computerised information compared to paper-based records. Discuss technology issues relating to storage and retrieval, and displaying images in the information system. Explain why a receptionist and doctors have different screen views of the data.

Student Responses (13)

Band 5/6 response 1 Band 5/6 response 2 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2

Question 23

Question 23

Written Paper Section II Question 23 - 2010 HSC

Identify and explain a technique that has been implemented to reduce data entry errors. Explain the use of specified screen elements over other data collection methods. Design a screen to display data results for the scenario. Describe the analysing processes needed to generate information.

Student Responses (1)

Exemplary response 1

Question 23

Question 23

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.

Student Responses (15)

Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

Question 24

Question 24

Written Paper Section II Question 24 - 2001 HSC

Describe methods of error detection. Outline new trends in processing, organising, storing and retrieving data and how these trends might be applied to an information system. Analyse issues associated with an e-mail message.

Related responses

You may also be interested in: