On successful completion of this unit, you will be able to:
- Differentiate database applications, systems, and their role in supporting business processes.
- Demonstrate competency in using Structured Query Language
- Design models using a specified data modelling approach.
- Create Relational Models
- Normalise tables using concepts relating to functional dependancy.
- Identify database implementation issues.
The aim of this unit is to provide the student with an understanding of database theory, technology, the database environment, and the role of database applications in support of enterprise. The focus is the use and design of databases using contemporary technology—relational database technology and SQL. An introduction is provided to database implementation issues and emerging database technology.
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 following workplace skills as defined by SFIA. The SFIA code is included:
Database Repository Design (DBDS)
Program ming/Software Development (PROG)
Database Administration (DBAD)