Revision of HSC topic two

HSC Topic 2 - Information Systems and Databases
Information systems are computer systems that support end users, giving them access to the information. For a large number of information systems, the data is held in databases and access is via database management systems. Information systems perform a variety of tasks and while all of the information processes are represented in information systems, the processes of organising, storing and retrieving with database systems and hypermedia should be emphasised.

information systems - characteristics of an information system and different types of and purposes for information systems.

database information systems
• school databases holding information on teachers, subjects, classrooms and students
• the RTA holding information on automobiles and holders of drivers licences
• DVD hire stores holding information on borrowers and videos

organisation
• non-computer methods of organising
• computer based methods of organising
• the advantages and disadvantages of computer based and non-computer based organisation methods
• the logical organisation of flat-file databases
• the logical organisation of relational databases

• data modelling tools for organising databases
• choose and justify the most appropriate type of database, flat-file or relational, to organise a given set of data
• create a simple relational database from a schematic diagram and data dictionary
• populate a relational database with data
• describe the similarities and differences between flat-file and relational databases
• create a data dictionary for a given set of data
• create documentation, including data modelling, to indicate how a relational database has been used to organise data
• demonstrate an awareness of issues of privacy, security and accuracy in handling data
• the logical organisation of hypermedia
• tools for organising hypermedia

storage and retrieval
• database management systems (DBMS)
• direct and sequential access of data
• on-line and off-line storage
• centralised and distributed databases
• storage media
• encryption and decryption
• backup and security procedures
• tools for database storage and retrieval
– extracting data through searching and sorting
– selecting data from a relational database using Query by Example (QBE) and Structured Query
Languages (SQL) the commands:
- select
- from
- where
- order by
• tools for hypermedia search and retrieval
• reporting on data found in hypermedia systems

other information processes for database information systems
• displaying

issues related to information systems and databases
• acknowledgment of data sources
• the Freedom of Information Act
• privacy principles
• quality of data
• accuracy of data and the reliability of data sources
• access to data, ownership and control of data
• data matching to cross link data across multiple databases
• current and emerging trends in the organisation, processing, storage and retrieval of data
(See Course Specifications Document)

***A reminder that all of the digital resources used during the course can be accessed through the Year 12 IPT Class Page in MyClasses***