Course Title: Create basic databases
Part B: Course Detail
Teaching Period: Term1 2018
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 the documentation, and submit it to the 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 the attributes that the database will hold 2.2 Develop primary and foreign keys to link the entities 2.3 Develop a data dictionary 2.4 Complete the documentation, and submit it to the 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 |
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 Practical task 2 Assignment 1: (Due Week 5) |
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 2: (Due Week 4) Practical task 3 |
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 Practical task 4 |
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 3: (Due Week 6) Practical task 5 Assignment 2: (Due Week 10) |
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 |
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 Online Quiz 4: (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 |
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 |
4.1 |
11 |
Test the database and debug Ensure that the information represented matches the requirements Practical task 10 Online Quiz 5: (Due Week 12) |
4.2 |
12 |
Integrated Assignment: Database Stage released (Due Week 16) |
|
13 |
Security restrictions Integrated Assignment: Database Stage |
|
14 |
Communication, accessibility (including audiences with special needs), Integrated Assignment: Database Stage |
|
15 |
Integrated Assignment: Database Stage |
|
16 |
Integrated Assignment: Database Stage |
|
17 |
Resubmissions |
|
18 |
Completing Program materials |
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
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: Assignment 1
Assessment 2: Assignment 2
Assessment 3: Online quizzes
Assessment 4: Integrated Assignment: Sporting 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
Assessment Matrix
Assessment Mapping Matrix
Elements/ Performance Criteria Covered |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 |
1.1 | X | X | X | X |
1.2 | X | X | X | X |
1.3 | X | X | X | X |
2.1 | X | X | X | X |
2.2 | X | X | X | X |
2.3 | X | X | X | X |
2.4 | X | 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 |
Course Overview: Access Course Overview