This unit describes the skills and knowledge required to design, develop and test a database in order to meet a specification.  It applies to individuals who may be either database, or web designers, required to create a simple database to store information for an online application, using a simple entity relational database.

Unit details

Study level:
Vocational and further education (TAFE)
Unit code:


Assessment tasks will be designed to reinforce and extend knowledge and skill competence within set and controlled parameters in accordance with each unit's learning outcomes and performance criteria requirements, including the setting of work based practical application tasks designed to provide evidence of competence outcomes, within periodic and scheduled timelines. Students will be expected to demonstrate the following required skills: - research client requirements for a database solution; - design a database that meets client requirements; - create a database on a web hosting service or server to meet client requirements by a due date, and; - test and debug the database.Students will also be expected to demonstrate the following knowledge: - outline the principles of open platforms, including browsers and databases; - list the processes associated with the creation of entities, attributes, and in populating fields, using both software solutions and script- based input; - describe data-modelling techniques to design a database; - outline the steps in database design, modelling and implementation; - describe the internet operation related to web servers and clients; - identify the naming conventions appropriate to database design; - identify security restrictions on servers, incorporating some theoretical concepts, and; - describe best practice communication, and accessibility, for audiences with special needs.

Where to next?

VU takes care to ensure the accuracy of this unit information, but reserves the right to change or withdraw courses offered at any time. Please check that unit information is current with the Student Contact Centre.