Course Title: Create basic databases
Part B: Course Detail
Teaching Period: Term2 2017
Course Code: ISYS5693C
Course Title: Create basic databases
School: 174T School of VE Engineering, Health & Science
Campus: City Campus
Program: C4378 - Certificate IV in Information Technology Networking
Course Contact: Trevor Stone
Course Contact Phone: +61 3 9925 4545
Course Contact Email: trevor.stone@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
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.
Pre-requisites and Co-requisites
There are no pre-requisites for this course.
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.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
ICTDBS403 Create basic databases |
Element: |
1. Analyse the requirements for the database |
Performance Criteria: |
1.1 Determine the information that the database is required to hold 1.2 Develop a written requirement report for the functionality of the database 1.3 Complete documentation and submit to appropriate person for approval |
Element: |
2. Use data modelling to design the database to suit requirements |
Performance Criteria: |
2.1 Design an entity-relationship (ER) diagram to model the relationships between the entities and attributes the database will hold 2.2 Develop the primary and foreign keys to link the entities 2.3 Develop a data dictionary 2.4 Complete documentation and submit to appropriate person for approval |
Element: |
3. Create a database on a web or database server |
Performance Criteria: |
3.1 Use the appropriate language on a web or database server to create one or more databases 3.2 Use the appropriate language on a web or database server to create tables 3.3 Populate the database fields |
Element: |
4. Test the database and debug |
Performance Criteria: |
4.1 Test the database on the web or database server 4.2 Ensure that the information represented matches the requirements |
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.
Details of Learning Activities
Activities in this course are aimed at enhancing your understanding and knowledge of data modelling, analysing database requirements, creating, testing and debugging a database on a web or database server.
Teaching Schedule
Week |
Topic |
Elements |
1 |
Analyse the requirements for the database (1) Determine the information that the database is required to hold Introduction to databases Principles of open platforms Xampp, HeidiSQl, W3Schools |
1.1,1.2, 1.3 |
2 |
Analyse the requirements for the database (2) Develop a written requirement report for the functionality of the database Entities, Attributes, Relationships Microsoft Visio Online Quiz 1: (Due Week 2) Practical task 1: (Due Week 2) |
1.1, 1.2, 1.3 |
3 |
Analyse the requirements for the database (3) 1.3 Complete the documentation, and submit it to the appropriate person for approval. Business rules, Cardinality, Participation Online Quiz 2: (Due Week 3) Practical task 2: (Due Week 3) |
1.1, 1.2, 1.3 |
4 |
Use data modelling for design (1) 2.1 Design an entity-relationship (ER) diagram to model the relationships between the entities and the attributes that the database will hold Normalization Database redundancies Online Quiz 3: (Due Week 4) Practical task 3: (Due Week 4) |
2.1, 2.2, 2.3, 2.4 |
5 |
Use data modelling for design (2) 2.2 Develop primary and foreign keys to link the entities Keys, Constraints Online Quiz 4: (Due Week 5) Practical task 4: (Due Week 5) |
2.1, 2,2. 2.3, 2.4 |
6 |
Use data modelling for design (3) 2.3 Develop a data dictionary Database schemas Naming conventions Online Quiz 5: (Due Week 6) Practical task 5: (Due Week 6) |
2.1, 2,2. 2.3, 2.4 |
7 |
Create a database on a web or database server (1) 3.1 Use the appropriate language on a web or database server to create one or more databases SQL syntax Practical task 6: (Due Week 7) |
2.1, 2,2. 2.3, 2.4 |
8 |
Create a database on a web or database server (2) Naming conventions 3.2 Use the appropriate language on a web or database server to create tables SQL syntax (cont). Practical task 7: (Due Week 8) |
3.1, 3.2, 3.3 |
9 |
Create a database on a web or database server (3) Populate the database fields HeidiSQL, Xampp Scripting Practical task 8: (Due Week 9) |
3.1, 3.2, 3.3 |
10 |
Test the database and debug Test the database on the web or database server Xampp, Internet Browsers Internet operation Practical task 9: (Due Week 10) |
4.1 |
11 |
Test the database and debug Ensure that the information represented matches the requirements Practical task 10: (Due Week 11) |
4.2 |
12 |
Integrated Assignment: Stage 7 released (Due Week 15) |
|
13 |
Security restrictions |
|
14 |
Communication, accessibility (including audiences with special needs), |
|
15 |
Integrated Assignment: Stage 7 |
|
16 |
Completing Program materials
|
|
17 |
Review of Integrated Project
|
|
18 |
Course Review and Feedback
|
Learning Resources
Prescribed Texts
References
Other Resources
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:
Tasks
Assessment 1: Online quizzes
Assessment 2: Practical tasks
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 |
Assessment Tasks
- Online quizzes
- Practical tasks
- Integrated Assignment: Sports Precinct
This assessment will involve a co-assessment of five (5) courses, viz.:
ICTICT401 - Determine and confirm client business requirements
ICTICT418 - Contribute to copyright, ethics and privacy in an ICT environment
ICTTEN416 - Install, configure and test an internet protocol network
ICTTEN417 - Install, configure and test a router
ICTDBS403 - Create Basic Databases
You are permitted to have a maximum of 2 resubmissions for this course, however each individual assessment may only be resubmitted once.
All resubmissions must be completed and submitted no more than 7 days after your work has been graded.
Assessment Matrix
Students must pass each of the following assessment tasks to demonstrate competency.
Assessment | |
Task 1 |
Online quizzes |
Task 2 |
Practical tasks |
Task 3 |
Integrated Assignment |
These tasks assesses the following Course Learning Outcomes (CLOs):
Element |
Task 1 |
Task 2 |
Task 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 |
Other Information
Credit Transfer and/or Recognition of Prior Learning (RPL):
You may be eligible for credit towards courses in your program if you have already met the learning/competency outcomes through previous learning and/or industry experience. To be eligible for credit towards a course, you must demonstrate that you have already completed learning and/or gained industry experience that is:
- Relevant
- Current
- Satisfies the learning/competency outcomes of the course
Please refer to http://www.rmit.edu.au/students/enrolment/credit to find more information about credit transfer and RPL
Study and learning Support:
Study and Learning Centre (SLC) provides free learning and academic development advice to you.
Services offered by SLC to support your numeracy and literacy skills are:
- assignment writing, thesis writing and study skills advice
- maths and science developmental support and advice
- English language development
Please Refer http://www.rmit.edu.au/studyandlearningcentre to find more information about Study and learning Support
Equitable Learning Services (ELS):
If you are suffering from long-term medical condition or disability, you should contact Equitable Learning Services (ELS) to seek advice and support to complete your studies.
Please refer to https://www.rmit.edu.au/students/support-and-facilities/student-support/equitable-learning-services to find more information about services offered by Equitable Learning Services (ELS).
Late submission:
If you require an Extension of Submittable Work (assignments, reports or project work etc.) for 7 calendar days or less (from the original due date) and have valid reasons, you must complete and lodge an Application for Extension of Submittable Work (7 Calendar Days or less) form and lodge it with the Senior Educator/ Program Manager.
The application must be lodged no later than one working day before the official due date. You will be notified within no more than 2 working days of the date of lodgment as to whether the extension has been granted.
If you seek an Extension of Submittable Work for more than 7 calendar days (from the original due date) must lodge an Application for Special Consideration form under the provisions of the Special Consideration Policy, preferably prior to, but no later than 2 working days after the official due date.
Submittable Work (assignments, reports or project work etc.) submitted late without approval of an extension will not be accepted or marked.
Special consideration:
Please Refer http://www.rmit.edu.au/students/specialconsideration to find more information about special consideration
Plagiarism:
Plagiarism is a form of cheating and it is very serious academic offence that may lead to expulsion from the University.
Please Refer: www.rmit.edu.au/academicintegrity to find more information about plagiarism.
Other Information:
All email communications will be sent to your RMIT email address and you must regularly check your RMIT emails.
Course Overview: Access Course Overview