Course Title: Design databases

Part B: Course Detail

Teaching Period: Term2 2009

Course Code: COSC5944C

Course Title: Design databases

School: 650T TAFE Business

Campus: City Campus

Program: C4223 - Certificate IV in Business Administration

Course Contact : Sylvia Baroutis

Course Contact Phone: +61 3 9925 5469

Course Contact

Name and Contact Details of All Other Relevant Staff

Janet McDonald Course Leader

Contact Phone: 9925 5134


Nominal Hours: 60

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Pre-requisites and Co-requisites

There are no pre-requisites or co-requisites required for this competency.

Course Description

This unit describes the performance outcomes, skills and knowledge required to design and develop a database (including queries, forms and reports) to meet a defined need using existing data.

No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement.

This unit contains employability skills.

This unit applies to individuals employed in a range of work environments who create databases to store and retrieve data using commercially available database software. They may provide administrative support within an enterprise, or may be independently responsible for designing databases relevant to their own work roles.

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

BSBITA401A Design databases


1. Design database

Performance Criteria:

Review organisational and task requirements to confirm scope and functionality of database design, including data redundancy.

Develop a logical data model to identify and classify data into types.

Select appropriate software according to organisational and task requirements and required scope and functionality of database.

Confirm database design with appropriate person.


2. Develop database

Performance Criteria:

Set field attributes according to data type and link databases by a common field in accordance with software procedures.

Identify primary key to uniquely identify data.

Identify foreign keys to establish associations between data.

Use software functions and formulae to meet organisational and task requirements.


3. Develop queries, forms and reports

Performance Criteria:

Develop queries as required by organisational and task requirements.

Develop input screens or forms in order to access required data.

Develop reports according to organisational and task requirements.


4. Test and finalise database

Performance Criteria:

Populate database with sample dataset for testing.

Assess and document effectiveness of data relationships, queries, forms and reports.

Address any errors in databasde design.

Name and store database in accordance with organisational requirements and exit the application without data loss or damage.

Confirm database readiness with appropriate person.

Learning Outcomes

Details of Learning Activities

Learning activities will include class-based discussions, exercises, reading and reflection and situated learning in the Virtual Enterprise in order to develop competency, including the underpinning skills and knowledge.

Teaching Schedule

Week beginningContentRequirements
Week 9 - 7 SepCourse guide; Database theory; Employability skillsText
Week 10 - 14 SepSection 2: Planning & Creating DatabaseText
Week 11 - 21 SepSection 3 - FormsText
Week 12 - 28 SepSection 4 -QueriesText
Week 13 - 5 OctSection 5 - Reports & Section 6 - Importing and Exporting DataText
Week 14 - 12 OctAssessment 1Text & Printing Credits
Week 15 - 19 OctCase StudyText
Week 16 - 26 OctSection 6 - Macros & TemplatesText
Week 17 - 2 NovAssessment 3 - ExamText & Printing Credits
Week 18 - 9 NovSpecial considerationText & Printing Credits

Learning Resources

Prescribed Texts

Price & Wix,BSBITA401A Design Databases - Access 2003, Software Publications



Other Resources

Overview of Assessment

Students must demonstrate an understanding of all elements of a particular competency to be deemed competent.  Assessment methods have been designed to measure achievement of each competency in a flexible manner. Assessment will incorporate a variety of methods including: demonstration of techniques under supervised conditions and a review of a database designed, developed and tested in class.  Due to the complex nature of this competency, students may be required to demonstrate competency in any element more than once.  Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.  In addition, formative feedback will be provided to students throughout the course.

Assessment Tasks

Assessment 1 - In class week 14 20%

Students will complete a practical assessment in class, individually. Students will require their text book to complete the assessment which covers all elements of competency.

Assessment 2 Virtual Enterprise - Due week 16 or earlier by negotiation 30%

Students wil buy and sell goods and services for Reflective Records Virtual Enterprise. Students will make a minimum of six transactions for both selling and purchasing and document the trading cycle to its completion. Refer to the marking criteria guide for this assessment located at the Learning Hub for this course.

Assessment 3 Final Exam  - In normal class time week 17 - 50%

Students will complete a practical assessment in class, individually. This will be run under test conditions, is open book and covers all elements of competency.

Assessment Matrix

Element of competencyAssessment 1Assessment 2Assessment 3
Design databaseYesYesYes
Develop databaseYesYesYes
Develop queries, forms & reportsYesYesYes
Test and finalise databaseYesYesYes

Other Information

This course/competency includes the employability skills listed below:


Problem solving

Initiative and enterprise

Planning and organising




From July 2008 students issued with Training Package qualifications have been informed by their Registered Training Organisation that Employability Skills Summaries for Training Pactage qualifications can be downloaded from . Registered Training Organisations are required to add the mandartory sentence providing the URL for the Employability Skills Summaries to Training Package and Qualification Testamurs from 1 January 2009. The Australian Qualification Framework Implementation Handbook has been amended to show this requirement.

Course Overview: Access Course Overview