On successful completion of this unit, you will be able to:
- Explain the purpose of and technical foundations related to database technology.
- Explain the processes undertaken during identification of functional dependancies and normalisation.
- Design and develop a small database using Microsoft Access and design queries using structured query language (SQL).
- Identify issues related to data integrity in a multi user database environment.
- Explain the fundamental concepts of distributed database and data warehousing.
Australian Computer Society (ACS) recognises the Skills Framework for the Information Age (SFIA). SFIA is in use in over 100 countries and provides a widely used and consistent definition of ICT skills. SFIA is increasingly being used when developing job descriptions and role profiles.
ACS members can use the tool MySFIA to build a skills profile at https://www.acs.org.au/professionalrecognition/mysfia-b2c.html
This unit contributes to the workplace skills as defined by SFIA. The SFIA code is included:
Data Analysis (DTAN)
Systems Design (DESN)
Database/Repository Design (DBDS)
Systems Integration (SINT)
Program ming/Software Development (PROG)
Release and Deployment (RELM)
Applications Support (ASUP)