Course Title: Create basic databases

Part B: Course Detail

Teaching Period: Term2 2019

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

Trevor Stone

Ph: 99254545

e: trevor.stone@rmit.edu.au

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: Online quizzes

Assessment 2: Practical tasks

Assessment 3: Assignments




Assessment Matrix

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

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