Course Title: Design databases

Part B: Course Detail

Teaching Period: Term2 2010

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 Coordinator

Tel: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 

Create password and access system according to 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 database 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 and reading and reflection in order to develop competency, including the underpinning skills and knowledge.

Teaching Schedule

 The total number of scheduled hours of teaching, learning and assessment involved in this course will include all planned activities. This may incorporate face-to-face classes, lectures, workshops and seminars; wherever possible workplace visits, online learning and other forms of structured teaching and learning. The total scheduled hours includes the amount of effort required to undertake, evaluate and complete all assessment requirements, including observation of work performance, discussions with supervisors and others providing third party evidence and one on one and group assessment sessions with students.

Week beginning

Week 10 - 13 SeptCourse guide; Database theory & Section 2: Planning & Creating DatabaseText
Week 11 - 20 SeptSection 3 - FormsText & Printing Credits
Week 12 - 27 SeptSection 4 - QueriesText & Printing Credits
Week 13 - 4 OctSection 5 - Reports & Section 6 - Importing and Exporting DataText & Printing Credits
Week 14 - 11 OctAssessment 1Text & Printing Credits
Week 15 - 18 OctCase StudyText & Printing Credits
Week 16 - 25 OctAssessment 2Text & Printing Credits
Week 17 - 1 NovPublic Holiday 
Week 18 - 8 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

Students will complete two practical assessments during normal class time in Week 14 and Week 16 for all elements of competency. These assessments are open book and must be completed individually.

Assessment Matrix

Grading Information 

HD>=80High distinction (competency achieved)
DI 70-79Distinction (competency achieved)
CR60-69Credit (competency achieved)
PA50-59Pass (competency achieved)
NN<50 Fail (not yet competent)
CA Not applicableCompetency Achieved
NYCNot available Not yet competent

Elements of CompetencyAssessement 1 & 2
Design databaseYes
Develop a logical data model to identify and classify data into typesYes
Develop databaseYes
Develop queries, forms and reportsYes
Test and finalise databaseYes

Other Information

Special Consideration

Special consideration allows the University to take account of unexpected circumstances that can affect your ability to complete an assessment. Examples of unexpected or extenuating circumstances for eligibility may include:
• Serious illness with a significant impact e.g. hospital admission, concussion, serious injury, asthma attack or depression. It does not include illnesses with minor impact such as a cold, headache, period pain or stomach ache.
• Loss or bereavement e.g. death of a close family member, family/relationship breakdown.
• Hardship or trauma e.g. victim of serious crime, sudden loss of income or employment, severe unexpected disruption to domestic arrangements.

How to apply

You must apply for special consideration no later than two working days after the relevant examination or assessment deadline. You must complete the Special Consideration Application form available at and lodge the original and one photocopy at the Hub on your campus. You can also lodge the application and supporting documentation via fax to tel. 9925 8845 or send scanned copies via email to

Please note that in 2010 it is anticipated that applications for special consideration will move to an online process. More information about this new process will be available at

Your application must be supported by a medical impact statement and/or relevant supporting documentation. A medical certificate alone is not sufficient. If you cannot obtain the impact statement or supporting documents within two days, you should lodge an incomplete application form and provide the additional documents within five business day.

Late applications can only be accepted in extenuating circumstances and their submission requires the approval of the Academic Registrar.

Assessment of applications

All special consideration applications are considered by a panel of health and academic experts, convened by the Academic Registrar. All communication about your application will be through your RMIT student email account. It is your responsibility to check your RMIT student email account regularly, promptly respond to any requests for information or action and ensure your account can receive incoming emails.

Extensions of time for submission of assessment – seven days or fewer

If you are seeking an extension of seven calendar days or fewer from the original due date you must meet certain eligibility criteria (similar to special consideration) and complete an Application for Extension of Time for Submission of Assessable Work form and lodge it with the School. Forms are available at

Arrangements for lodging forms can vary according to individual school procedures. It is your responsibility, as the applicant, to check whether the form should be lodged with the school administrative officer, the course coordinator or program coordinator. Except in exceptional circumstances the application must be lodged no later than one working day before the official due date.

Employability skills

Employability skills are included in this course and are based on broad industry requirements.

Course Overview: Access Course Overview