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 Email:sylvia.baroutis@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Janet McDonald Course Coordinator

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

Create password and access system according to 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 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

 Content Requirements
Week 10 - 13 Sept Course guide; Database theory & Section 2: Planning & Creating Database Text
Week 11 - 20 Sept Section 3 - Forms Text & Printing Credits
Week 12 - 27 Sept Section 4 - Queries Text & Printing Credits
Week 13 - 4 Oct Section 5 - Reports & Section 6 - Importing and Exporting Data Text & Printing Credits
Week 14 - 11 Oct Assessment 1 Text & Printing Credits
Week 15 - 18 Oct Case Study Text & Printing Credits
Week 16 - 25 Oct Assessment 2 Text & Printing Credits
Week 17 - 1 Nov Public Holiday  
Week 18 - 8 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

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 

Grade Mark Description
HD >=80 High distinction (competency achieved)
DI 70-79 Distinction (competency achieved)
CR 60-69 Credit (competency achieved)
PA 50-59 Pass (competency achieved)
NN <50 Fail (not yet competent)
CA Not applicable Competency Achieved
NYC Not available Not yet competent

Elements of Competency Assessement 1 & 2
Design database Yes
Develop a logical data model to identify and classify data into types Yes
Develop database Yes
Develop queries, forms and reports Yes
Test and finalise database Yes

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 rmit.edu.au/students/forms 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 special.consideration@rmit.edu.au.

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 rmit.edu.au/students/specialconsideration.

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 rmit.edu.au/students/forms.

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