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

  1. Online quizzes
  2. Practical tasks
  3. 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