^

 
 

Qualification details

ICA50511 - Diploma of Database Design and Development (Release 1)

Summary

Usage recommendation:
Superseded
Mapping:
MappingNotesDate
Supersedes and is equivalent to ICA50505 - Diploma of Information Technology (Database Design and Development)ICA50505 core units updated and reduced. Removal of entry requirements and prerequisites. Qualification made more flexible. Elective units added and technical content updated. OUTCOMES DEEMED EQUIVALENT. 17/Jul/2011
Is superseded by and equivalent to ICT50515 - Diploma of Database Design and DevelopmentUpdated to meet Standards for Training Packages. 24/Mar/2015

Releases:
ReleaseRelease date
(View details for release 2) 07/Nov/2013
1 (this release) 18/Jul/2011

Replaced release

You are currently viewing the components related to release 1.
The current release is release 2View release 2 details.

Units of competency

CodeSort Table listing Units of Competency by the Code columnTitleSort Table listing Units of Competency by the Title columnUsage RecommendationSort Table listing Units of Competency by the Usage Recommendation columnEssentialSort Table listing Units of Competency by the Essential column
ICTSUS6233A - Integrate sustainability in ICT planning and design projectsIntegrate sustainability in ICT planning and design projectsSupersededN/A
ICAPRG514A - Prepare for software development using rapid application developmentPrepare for software development using rapid application developmentSupersededN/A
ICAWEB502A - Create dynamic web pagesCreate dynamic web pagesSupersededN/A
ICAPRG505A - Build advanced user interfaceBuild advanced user interfaceSupersededN/A
ICAPMG606A - Manage IT project qualityManage IT project qualitySupersededN/A
ICADBS502A - Design a databaseDesign a databaseSupersededN/A
ICASAD502A - Model data processesModel data processesSupersededN/A
ICAPRG501A - Apply advanced object-oriented language skillsApply advanced object-oriented language skillsSupersededN/A
ICAPRG515A - Review developed softwareReview developed softwareSupersededN/A
ICAPRG503A - Debug and monitor applicationsDebug and monitor applicationsSupersededN/A
Items per page 10 | 20 | 50 | 100
Displaying items 1 - 10 of 29

Classifications

SchemeCodeClassification value
ANZSCO Identifier 262111 Database Administrator 
ASCO (occupation type) Identifier 2231 Computing Professionals 
ASCED Qualification/Course Field of Education Identifier 0203 Information Systems 
Qualification/Course Level of Education Identifier 421 Diploma 
Taxonomy - Industry Sector N/A Systems Design,Website and Database Development 
Taxonomy - Occupation N/A Data Warehouse Consultant,Database Developer,Database Designer,Assistant Database Designer/Developer 

Classification history

SchemeCodeClassification valueStart dateEnd date
ANZSCO Identifier 262111 Database Administrator 04/Nov/2011 
ASCO (occupation type) Identifier 2231 Computing Professionals 04/Nov/2011 
ASCED Qualification/Course Field of Education Identifier 0203 Information Systems 04/Nov/2011 
Qualification/Course Level of Education Identifier 421 Diploma 18/Jul/2011 
The content being displayed has been produced by a third party, while all attempts have been made to make this content as accessible as possible it cannot be guaranteed. If you are encountering issues following the content on this page please consider downloading the content in its original form

Modification History

Release 

Comments 

Release 1

This Qualification first released with ICA11 Information and Communications Technology Training Package version 1.0

Description

This qualification provides skills and knowledge for an individual to be effective in the design and development of ICT database systems. The qualification builds on a base core of design and development competencies with elective choices covering business needs analysis, quality assurance and project management.

Job roles 

Possible job titles relevant to this qualification include:

  • assistant database designer
  • assistant database developer
  • assistant database specialist.

Pathways Information

Pathways into the qualification 

  • after achieving ICA40211 Certificate IV in Information Technology Support, or other relevant qualifications or units equivalent to the core of ICA40211.

OR

  • with demonstrated vocational experience in a range of database design and development areas.

Pathways from the qualification 

ICA11 Advanced Diploma or Vocational Graduate Certificate qualifications or other higher education sector qualifications.

Licensing/Regulatory Information

There is no link between this qualification and licensing, legislative or regulatory requirements. However users should confirm requirements with the relevant federal, state or territory authority. There may be some alignment with industry standard certification competencies.

Entry Requirements

There are no entry requirements for this qualification.

Employability Skills Summary

The following table contains a summary of the employability skills required by industry for this qualification. The employability skills facets described here are broad industry requirements that may vary depending on qualification packaging options.

Employability skill 

Industry/enterprise requirements for this qualification 

Communication

  • articulating complex scenarios in a clear and concise manner relevant to all levels of the organisation
  • documenting information related to database requirements and solutions
  • writing and presenting complex technical reports, with supporting documentation

Teamwork

  • coordinating group and presenting on key project activities
  • reviewing the database with team members and key stakeholders

Problem-solving

  • developing controls and contingencies to alleviate security threats
  • taking corrective action on system implementation breakdowns

Initiative and enterprise

  • anticipating potential problems and devising solutions
  • conducting research to determine client business requirements
  • integrating sustainability in ICT planning and design projects
  • matching client IT requirements with the strategic direction of the enterprise

Planning and organising

  • developing project plans
  • planning for quality controls and contingencies when designing database system

Self-management

  • managing own time and work priorities against project plan and schedule
  • taking accountability and responsibility for self and others in achieving work outcomes

Learning

  • keeping up-to-date with current industry-accepted database, web and programming products
  • participating in learning and development opportunities

Technology

  • coordinating implementation of technology needs
  • assessing the technological capability of various products against architecture requirements and making recommendations on the best IT solution
  • examining current and future ICT capability against a client’s future requirements and modelling preferred systems solutions

Packaging Rules

Total number of units = 20 

9 core units  plus 

11 elective units 

The elective units consist of:

  • up to 11 from the elective units listed below
  • up to 4 from elsewhere in ICA11 or any other Training Package or accredited course at Diploma or Advanced Diploma level.

The elective units chosen must be relevant to the work outcome and meet local industry needs.

Core units 

ICADBS502A Design a database

ICAICT418A Contribute to copyright, ethics and privacy in an IT environment

ICAICT502A Develop detailed component specifications from project specifications

ICANWK514A Model preferred system solutions

ICAPRG425A Use structured query language

ICAPRG509A Build using rapid application development

ICASAD501A Model data objects

ICASAD502A Model data processes

ICTSUS6233A Integrate sustainability in ICT planning and design projects

Elective units 

ICADBS504A Integrate database with a website

ICAICT509A Gather data to identify business requirements

ICAICT511A Match IT needs with the strategic direction of the enterprise

ICAICT514A Identify and manage the implementation of current industry-specific technologies

ICAPMG501A Manage IT projects

ICAPMG606A Manage IT project quality

ICAPRG501A Apply advanced object-oriented language skills

ICAPRG503A Debug and monitor applications

ICAPRG504A Deploy an application to a production environment

ICAPRG505A Build advanced user interface

ICAPRG507A Implement security for applications

ICAPRG511A Monitor and support data conversion to new IT system

ICAPRG514A Prepare for software development using rapid application development

ICAPRG515A Review developed software

ICAPRG523A Apply advanced programming skills in another language

ICASAD506A Produce a feasibility report

ICASAS502A Establish and maintain client user liaison

ICASAS505A Review and update disaster recovery and contingency plans

ICAWEB502A Create dynamic web pages

ICTTEN5204A Produce technical solutions from business specifications