Course Title: Build a database

Part B: Course Detail

Teaching Period: Term1 2012

Course Code: COSC6079C

Course Title: Build a database

School: 650T TAFE Business

Campus: City Campus

Program: C5194 - Diploma of Information Technology (General)

Course Contact : Chandra Nannegari

Course Contact Phone: +61 3 9925 1657

Course Contact

Name and Contact Details of All Other Relevant Staff

Nominal Hours: 30

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


Course Description

This unit defines the competency required to build and implement a database using an established design.

If you are undertaking this course in Melbourne from semester 2, 2012 onward your class will be held in a specialist computing lab. Students are not required to have their own mobile computing device during class time. It is however recommended that you have access to a mobile computing device to allow greater flexibility in terms of where you can work on campus outside class times.

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAB4170B Build a database


1. Confirm database design

Performance Criteria:

1.1 Review database design documentation, including data structures, queries, reports and user interface
1.2 Compare database access and security feature design with organizational security plan
1.3 Document inconsistencies in database and security design


2. Create prototype

Performance Criteria:

2.1 Develop prototype according to database design
2.2 Populate database tables with suitable data, including current business data
2.3 Write conversion programs to import data from existing systems
2.4 Develop test data to assess database features
2.5 Assess functionality of prototype with client, including identifying errors in program code and modifying screens and reports
2.6 Incorporate feedback from client into prototype
2.7 Obtain client sign off for the prototype


3. Test database

Performance Criteria:

3.1 Develop implementation plan for the database
3.2 Install database management system software on network
3.3 Populate database tables with business data
3.4 Implement security and access controls
3.5 Test database output and security controls and record results


4. Evaluate database

Performance Criteria:

4.1 Review database with client for final approval
4.2 Complete database documentation
4.3 Identify and document user training requirements
4.4 Seek and secure client acceptance of database

Learning Outcomes

Details of Learning Activities

Learning activities will include laboratory-based sessions on a variety of topics as shown in the Teaching Schedule below. Learning activities will generally consist of practical computer exercises based on teacher handouts.

Students should attend all sessions. Students will also be expected to undertake work on project and other activities for homework.

Teaching Schedule

The nominal hours associated with this are a guide only and represent the total teaching time and student effort required to successfully complete the course. This may include not only scheduled classes but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.
WeekWeek CommencingTopicsAssessment
16th Feb 2012

Pre-training review:

Familiarisation with:
• Program
• Services/facilities
• Other students
• Teacher(s)
• Where to get support
• Student responsibilities
• Course requirements
• Course support documents
• Pre-reading
• Blackboard

Overview of assessment requirements:

• Grading
• Plagiarism
• Appeals
• Extensions
• Feedback
• Privacy
• Submission requirements
• Resubmission policy

Course Topic:

• Data Structures

213th Feb 2012 VBA basics: Variables, Types, Assignments, Subs, Functions. 
320th Feb 2012 VBA basics: Loops 
427th Feb 2012 VBA continued.

 Class Exercise (Task 1)

Project Posting (Task 2)

55th Mar 2012  Logical database design 
12th Mar 2012
(Monday, Labour Day)
 GUI Components: Forms 
719th Mar 2012  GUI components – continued. 
826th Mar 2012  Form Subform Class Exercise (Task 1)
92nd Apr 2012 Confirm DB Design Class Exercise (Task 1)
 Mid semester break (5 April to 11 April)
99th Apr 2012 Confirm DB Design Class Exercise (Task 1)
1016th Apr 2012 Prototype created. Prototype assessed. Class Exercise (Task 1)
1123rd Apr 2012 Test data developed. Stage 1: Project submission - prototype (Task 2)
1230th Apr 2012 Implementation plan. Post implementation review Class Exercise (Task 1)
137th May 2012 Evaluate DatabaseClass Exercise (Task 1)
1414th May 2012 Project Work 
1521st May 2012 • Project submission and demonstration.
• Revision
Stage 2: Project submission - (Task 2)
1628th May 2012 Practical TEST (Task 3 ) Practical TEST (Task 3 )
174th Jun 2012 Re-submissions if required 

Learning Resources

Prescribed Texts

MS Access Help (Accompanying MS Access) & relevant websites.


Other Resources

Other materials will include worksheets distributed by the teacher in class.

Overview of Assessment

Students must demonstrate an understanding of all elements of competency to be deemed competent.

A range of assessment methods are used to assess practical skills and knowledge, for example:

• direct questioning combined with review of portfolios of evidence and third party workplace reports of on-the-job performance by the candidate
• review of authenticated documents from the workplace or training environment
• demonstration of techniques

Assessment Tasks

You are required to complete 3 tasks. You must successfully complete all 3 tasks to be deemed competent in this unit.

TASK 1 – Class Exercises (Due Date: Refer to Teaching Schedule)

For this assessment task you are required to complete in-class worksheets on build and implement aspects of database, as per the Teaching Schedule.

TASK 2 Project (Due Date: Week 12 & 15)

• The project provides an opportunity, to students, to demonstrate the skills they learn in this unit.

o A case study or real life project is made available to students in Week 4.
o The students will be required to submit the project in two stages (Refer weekly breakdown). Stage 1 is an individual submission while Stage 2 is a group submission.

o Stage 1:

 Confirm database design.
 Build a prototype based on design submitted for “Design a Database”.
 Populate one of the tables with 50000 records.

o Stage 2:

 2 or 3 students join to form a team.
 Design is optimised from stage 1 within the team and so also the prototype.
 SQL Queries are executed to validate the model.
 Forms and reports are implemented.
 Security features are designed and applied.
 Complete database documentation.

TASK 3 Practical TEST (Due Date: Week 16)

For this assessment task you need to build a prototype model which includes tables, form, and report and populate sample data programmatically under TEST conditions.

For building the model, design specifications are provided. 

Assessment Matrix

Other Information

Submission Requirements:

Assessment tasks need to be submitted via Blackboard.

You should:
• Ensure that you submit assessments on or before the due date. If your performance in the assessment is affected by unexpected circumstances, you should consider applying for Special Consideration. Information on the process and application forms is available at;ID=ls0ydfokry9rz website.
• Always retain a copy of your assessment tasks. (hard copy and soft copy)
• When you submit work for assessment at RMIT University you need to use a cover sheet that includes a declaration and statement of authorship. You must complete, sign and submit a cover sheet with all work you submit for assessment, whether individual or group work. On the cover sheet you declare that the work you are presenting for assessment is your own work. An assignment cover sheet for submission of work for assessment is available on blackboard.
• Each page of your assessment should include footer with your name, student number, the title of the assessment, unit code and title and page numbers. For example, Julie Macpherson, 324567, Task 2, OHS2345C Ensure safe workplace, Page 1 of 10.

Marking Guide (Competency):

Vocational Education and Training (VET) is based on current industry needs and the focus on preparing you for the workplace. Because VET courses are informed by practical application of knowledge and skills, they are based on a system known as ‘competency based training’ (CBT).

So when you are assessed in VET it is about whether you are competent to do the job, as well as having a firm grasp on the knowledge and skills required to do that job, as opposed to traditional curriculum based education settings that are often based on knowledge retention.

You need to demonstrate you are competent in each element of the unit of competency you are studying.

You will receive feedback on each assessment task that will inform you whether you are competent or not and how well you are performing. Once competent in all elements of the unit you receive a competency grading.

Please refer to the Final Grades table below.

Marking Guide (Grading):

After achieving competency we then grade your performance in the unit; this gives you the opportunity to have the level of your performance formally recognized against industry standards and employability skills.

The grading is according to the following criteria:

We are looking for a high level of ability to complete all tasks independently as per the specifications as well as demonstrating a high level of initiative in your approach to building and implementing a database using an established design.

We are looking for depth of understanding of the key concepts and knowledge for building and implementing a database. You should be able to demonstrate a thorough understanding of all aspects of building a database in all the assessment tasks.

We are looking for appropriate use of technology and tools to assist in presenting all tasks clearly and suitable for the intended client. You also need to show an understanding of the kinds of problems that can arise in building and implementing a database and how these might be addressed.


We expect to see ongoing progress both in document portfolio and project relevant to the unit, full utilisation of Blackboard as per course requirements and timely submission of all required assessment tasks.


We expect to see contributions to relevant discussions and scheduled group sessions. In addition your tasks should demonstrate a very good understanding of strategies for a collaborative approach towards teamwork and building a well-structured database that meets client requirements.

Final Grades Table:

CHD   Competent with High Distinction
CDI     Competent with Distinction
CC      Competent with Credit
CAG    Competency Achieved – Graded
NYC    Not Yet Competent
DNS    Did Not Submit for assessment

Further information regarding the application of the grading criteria will be provided by your teacher.

Course Overview: Access Course Overview