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