Course Title: Create basic databases
Part A: Course Overview
Program: C4401 Certificate IV in Information Technology Networking
Course Title: Create basic databases
Portfolio: Vocational Education
Nominal Hours: 40
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.Important Information:
Please note that this course may have compulsory in-person attendance requirements for some teaching activities.
To participate in any RMIT course in-person activities or assessment, you will need to comply with RMIT vaccination requirements which are applicable during the duration of the course. This RMIT requirement includes being vaccinated against COVID-19 or holding a valid medical exemption.
Please read this RMIT Enrolment Procedure as it has important information regarding COVID vaccination and your study at RMIT: https://policies.rmit.edu.au/document/view.php?id=209.
Please read the Student website for additional requirements of in-person attendance: https://www.rmit.edu.au/covid/coming-to-campus
Please check your Canvas course shell closer to when the course starts to see if this course requires mandatory in-person attendance. The delivery method of the course might have to change quickly in response to changes in the local state/national directive regarding in-person course attendance.
Terms
Course Code |
Campus |
Career |
School |
Learning Mode |
Teaching Period(s) |
ISYS5693C |
City Campus |
TAFE |
174T School of VE Engineering, Health & Science |
Face-to-Face or Internet |
Term1 2020, Term2 2020 |
Course Contact: Program Manager
Course Contact Phone: +61 3 9925 4468
Course Contact Email: vehs@rmit.edu.au
Course Description
This unit defines the competency required to create basic databases as prescribed in the ICT Information and Communications Technology Training Package Version 1.0.
When you undertake this unit you will develop the ability to design, develop and test a database in order to meet a specification.
It applies to individuals who may be either database or web designers, required to create a simple database to store information for an online application, using a simple entry relational database.
Pre-requisite Courses and Assumed Knowledge and Capabilities
There are no pre-requisites for this course.
National Competency Codes and Titles
National Element Code & Title: |
ICTDBS403 Create basic databases |
Elements: |
1. Analyse the requirements for the database 2. Use data modelling to design the database to suit requirements 3. Create a database on a web or database server 4. Test the database and debug |
Learning Outcomes
On completion of this competency, you will be able to do the following:
- outline the principles of open platforms, including browsers and databases
- list the processes associated with the creation of entities, attributes, and in populating fields, using both software solutions and script based input
- describe data modelling techniques to design a database
- outline the steps in database design. modelling and implementation
- describe the internet operation related to web servers and clients
- identify the naming conventions appropriate to database design
- identify security restrictions on severs, incorporating some theoretical concepts
- describe best practice communication, and accessibility, for audiences with special needs.
Also refer to the elements of this course.
Overview of Assessment
Assessment in this course is competency based. You must be deemed competent in all elements to successfully complete the course.
Assessment in this course will involve the following:
Assessment 1: Online quizzes
Assessment 2: Practical Assessment
Assessment 3: Assignments
These tasks assesses the following Course Learning Outcomes (CLOs):
Assessment Mapping Matrix
Elements/ Performance Criteria Covered |
Assessment 1 | Assessment 2 | Assessment 3 |
1.1 | X | X | |
1.2 | X | X | |
1.3 | X | X | |
2.1 | X | X | X |
2.2 | X | X | X |
2.3 | X | X | X |
2.4 | X | X | X |
3.1 | X | X | X |
3.2 | X | X | X |
3.3 | X | X | X |
4.1 | X | X | |
4.2 | X | X |