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 Email:sylvia.baroutis@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Janet McDonald Course Leader
Contact Phone: 9925 5134
Email: janet.mcdonald@rmit.edu.au
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 |
Element: |
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. |
Element: |
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. |
Element: |
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. |
Element: |
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 beginning | Content | Requirements |
| Week 9 - 7 Sep | Course guide; Database theory; Employability skills | Text |
| Week 10 - 14 Sep | Section 2: Planning & Creating Database | Text |
| Week 11 - 21 Sep | Section 3 - Forms | Text |
| Week 12 - 28 Sep | Section 4 -Queries | Text |
| Week 13 - 5 Oct | Section 5 - Reports & Section 6 - Importing and Exporting Data | Text |
| Week 14 - 12 Oct | Assessment 1 | Text & Printing Credits |
| Week 15 - 19 Oct | Case Study | Text |
| Week 16 - 26 Oct | Section 6 - Macros & Templates | Text |
| Week 17 - 2 Nov | Assessment 3 - Exam | Text & Printing Credits |
| Week 18 - 9 Nov | Special consideration | Text & Printing Credits |
Learning Resources
Prescribed Texts
Price & Wix,BSBITA401A Design Databases - Access 2003, Software Publications |
1-74123-926-5 |
References
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 competency | Assessment 1 | Assessment 2 | Assessment 3 |
| Design database | Yes | Yes | Yes |
| Develop database | Yes | Yes | Yes |
| Develop queries, forms & reports | Yes | Yes | Yes |
| Test and finalise database | Yes | Yes | Yes |
Other Information
This course/competency includes the employability skills listed below:
Communication
Problem solving
Initiative and enterprise
Planning and organising
Self-management
Learning
Technology
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 http://employabilityskills.training.com.au . 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