Part B: Course Detail

Teaching Period: Term1 2025

Course Code: ISYS7589C

Course Title: Integrate databases with websites

Important Information:

Please note that this course may include compulsory in-person attendance requirements for some or all teaching activities.

It is recommended that you check your Canvas course shell closer to the course start date for details about any mandatory in-person attendance requirements.

Please be aware that the course delivery method may need to change quickly in response to evolving course requirements. Students must maintain regular communication with their teachers to stay informed about any updates.

School: 520T Future Technologies

Campus: City Campus

Program: C5402 - Diploma of Information Technology

Course Contact: Meray Abba

Course Contact Phone: +61 3 9925 4612

Course Contact Email: meray.abba@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Nominal Hours: 25

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

None

Course Description

In this course you will gain the skills and knowledge required to integrate a database with a website.

This course is clustered for delivery and assessment with the following unit: 

  • ICTWEB513  Build dynamic websites 
  • ICTWEB431 Create and style simple markup language documents


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICTDBS507 Integrate databases with websites

Element:

1.Prepare to connect database

Performance Criteria:

1.1 Determine organisational and user input database data requirements 1.2 Identify technical upgrades and requirements 1.3 Determine and document database integration plan according to organisational requirements 1.4 Submit documentation to required personnel and seek and respond to feedback

Element:

2. Connect to the database

Performance Criteria:

2.1 Setup database credentials and establish database connection 2.2 Connect to database from web application using web development language 2.3 Transfer data according to database integration plan2.4 Test database connection according to organisation and technical requirements

Element:

3. Retrieve and display data

Performance Criteria:

3.1 Retrieve data and use structured query language (SQL) 3.2 Display data using required control 3.3 Format data according to organisational requirements

Element:

4. Update database data

Performance Criteria:

4.1 Update existing user input data 4.2 Insert data in the database with user-supplied input 4.3 Identify and delete data stored in database 4.4 Validate data and check for errors

Learning Outcomes


On successful completion of this course the candidate will demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit.


Details of Learning Activities

This may include self-paced and collaborative classroom activities such as:  

  • Class exercises
  • Challenges
  • Problem solving
  • Project work
  • Quizzes  

We expect you to participate and contribute in all scheduled learning activities as each week builds on the next.


Teaching Schedule

The proposed teaching schedule for ICTDBS507 is detailed below: 

Week

  

Date

  

Topics/Discussions

  

Assessments

  

1

  

10th Feb - 16th Feb

  

Introduction to web development

  

Assessment 1 overview

Project brief

  

2

  

17th Feb - 23rd Feb

  

Creating HTML documents

HTML structure

HTML elements and structure

W3C standards

 

  

 

 

  

3

  

24th Feb - 2nd Mar

  

Introduction to CSS

Principles of web page design and storyboards

  

 

  

4

  

3rd Mar - 9th Mar

  

CSS properties and web page layout and design

  		  

5

  

10th Mar - 16th Mar

  

HTML forms

Forms styling with CSS

  

 

  

6

  

17th Mar - 23rdt Mar

  

Testing and demonstrations

  

Assessment 1 submission

Mandatory class attendance

Testing workshop and demonstrations

Assessment 1 submitted to Canvas end of week 6  

7

  

24th Mar - 28th Mar

  

ntroduction to PHP and dynamic websites.

Servers and Clients

PHP syntax - variables, strings, arrays

  

Assessment 2 overview

Website technical requirements

  

8

  

31st Mar - 6th Apr

  

HTTP request methods POST and GET

Storing and retrieving data from arrays

  

 

  

9

  

7th Apr- 13rd Apr

  

Database structure

OOP classes

Connecting to database

  

 

  

10

  

14th Apr - 17th Apr

  

SQL insert queries

HTML forms

SQL injection; cleansing form data and error control

  

 

  

Mid Semester Break - 18th Apr - 25th Apr

  

11

  

28th Apr - 4th May

  

Demonstrations

User testing

  

Assessment 2 submission

Mandatory class attendance

Testing workshop and demonstrations

Assessment 2 submitted to Canvas end of week 11

12

  

5th May - 11th May

  

SQL select queries

Methods and scripts to select and display data from a database.

Loops, HTML & CSS

  

Assessment 3 overview

Website technical requirements

  

13

  

12th May - 18th May

  

SQL, PHP functions

and scripts to delete data from a database.

  

 

  

14

  

19th May - 23rd May

  

SQL, PHP functions and scripts to update data in a database.

  

 

  

15

  

26th May - 1st June

  

In class - Project Demonstrations

  

Assessment 3 submission

Mandatory class attendance

Testing workshop and project demonstrations

Assessment 2 submitted to Canvas end of week 15

16

  

2nd June - 8th June

  

Feedback & Re-submission of Assessments (If applicable)

 

 

  

17

  

9th June - 15th June

  

Feedback & Re-submission of Assessments (If applicable)

  

 

  

18

  

16th June - 22nd June

  

Feedback & Re-submission of Assessments (If applicable)

  

 

  

*Please note that this timeline is subject to change based on semester requirements. We recommend checking your Canvas course shell regularly to stay updated with the latest schedule. 

Student directed hours involve completing activities such as reading online resources, assignments, individual student/teacher course-related consultation. Students are required to self-study the learning materials and complete the assigned out of class activities for the scheduled non-teaching hours. 

    


Learning Resources

Prescribed Texts


References


Other Resources

You will need laptop with charger for each class

  • Windows laptops we do recommend an i5 or better machine with a minimum 4 GB of RAM.
  • Macs you will need 8 GB of RAM to run a virtual machine

You may also refer to various media, websites, textbooks and e-books as indicated in Canvas such as

  • USB or external hard drive for backup
  • Text editor such as Visual Studio Code


Overview of Assessment

Assessment for this course is ongoing throughout the semester. Your knowledge and understanding of course content is assessed through participation in class exercises and various types of assessments.

Full assessment briefs will be provided and can be found on CANVAS.


Assessment Tasks

Please note the following three units are clustered and therefore co-delivered and co-assessed holistically

  • (COSC6227C) ICTWEB431 Create and style simple markup documents
  • (INTE5050C) ICTWEB501 Build a dynamic website
  • (ISYS7589C) ICTDBS504 Integrate database with a website

Summary and Purpose of Assessment 1

This assessment task is Task 1 of a website project which has 3 tasks.

You are required to read and analyse client requirements for a website and then design and create the specified web pages using a text editor. The website will be created using HTML and styled using advanced CSS (cascading style sheets). 

All website files will need to be validated against the standards set by the World Wide Web Consortium (W3C) and tested in a variety of browsers.

 

Completing this assessment task allows you to demonstrate you can:

  • Analyse the specifications and requirements
  • Create an HTML document structure and incorporate the web page components
  • Develop CSS to match user requirements
  • Style and position HTML elements, using advanced CSS techniques
  • Validate HTML and CSS against industry standards
  • Test the website in various browsers

 

Summary and Purpose of Assessment 2

This is the second of three (3) assessment tasks you must complete for this course. You must be satisfactory in all assessments to be competent in both courses.

You are required to read and analyse the technical requirements for a business website; produce the design specifications; and then build the required website functionality. The website will be built using object-oriented PHP and an SQL database

Completing this assessment task allows you to demonstrate you can:

  • create a website using efficient and effective code to meet technical requirements
  • access a database using a web-development language
  • insert web-based data
  • test a web application

Summary and Purpose of Assessment 3

This is the third of three (3) assessment tasks you must complete for this course. You must be satisfactory in all assessments to be competent in both of these courses.

This assessment task is part 3 of a website project.

You are required to read and analyse the technical requirements for a business website; produce the design specifications; and then build the required website functionality. The website will be built using object-oriented PHP and an SQL database

Completing this assessment task allows you to demonstrate you can:

  • create a website using efficient and effective code to meet technical requirements
  • access a database using a web-development language
  • retrieve and display web-based data
  • update web-based data

Feedback

Feedback will be provided throughout the semester in class and/or online discussions.  You are encouraged to ask and answer questions during class time and online sessions so that you can obtain feedback on your understanding of the concepts and issues being discussed. Finally, you can email or arrange an appointment with your teacher to gain more feedback on your progress.

You should take note of all feedback received and use this information to improve your learning outcomes and final performance in the course.  


Assessment Matrix

Element

Performance criteria

Assessment

Task 1: Website Project 1

Assessment

Task 2: Website Project 2

Assessment

Task 3: Website Project 3

1.Prepare to connect database

1.1 Determine organisational and user input database data requirements

 

Part A

 

1.2 Identify technical upgrades and requirements

 

Part A, Part B

 

1.3 Determine and document database integration plan according to organisational requirements

 

Part A, Part C, Part G

 

1.4 Submit documentation to required personnel and seek and respond to feedback

 

Part A, Part C, Part G

 

2. Connect to the database

2.1 Setup database credentials and establish database connection

 

Part C

Part C

2.2 Connect to database from web application using web development language

 

Part C

Part D

 

Part C, D

2.3 Transfer data according to database integration plan

 

Part D

Part C, Part D

2.4 Test database connection according to organisation and technical requirements

 

Part F

Part G

Part F

3. Retrieve and display data

3.1 Retrieve data and use structured query language (SQL)

 

 

 

Part C

Part D

3.2 Display data using required control

 

 

Part E (HTML, CSS, navigation)

Part C

Part D

3.3 Format data according to organisational requirements

 

Part E (head and footer with CCS styles)

Part D (HTML tabular format)

4. Update database data

4.1 Update existing user input data

 

 

 

Part C (function)

Part D (form and script), F (fix and update following user feedback)

4.2 Insert data in the database with user-supplied input

 

 

Part B, C, D, G

 

4.3 Identify and delete data stored in database

 

 

Part C (delete conf. and script), D (delete record)

4.4 Validate data and check for errors

 

Part B, C, D, F, G (test, check, and fix errors to validate)

Part C, D, F (test, check, and fix errors to validate)

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   

To find more information about credit transfer and RPL, please refer to the following link: https://www.rmit.edu.au/students/my-course/enrolment/apply-for-credit 

 Study and Learning Support:   

RMIT University Library provides free study support services and resources to help you build your academic skills. 
 
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 
• Math and science developmental support and advice 
• English language development 

To find more information about Study and Learning Support, please refer to the following link: https://www.rmit.edu.au/students/support-services/study-support   

Equitable Learning Services (ELS):   

The Equitable Learning Services team (ELS team) supports and creates equal opportunities for students with a disability, long-term illness and/or mental health condition. We also support primary carers.    

ELS works in partnership with students to create an Equitable Learning Plan. Your plan is tailored to you, supports your needs and establishes how RMIT can provide ongoing assistance so you can access and participate in your studies. The ELS team can assist you to manage your Equitable Learning Plan.   

To find more information about services offered by Equitable Learning Services (ELS), please refer to the following link: https://www.rmit.edu.au/students/support-services/equitable-learning 

  

Extensions and Special Consideration    

Extensions:   

• Extensions are available for unforeseen circumstances of a short-term nature.   

• Applications must be submitted to the school at least one working day before the due date of the assessment.   

• Extensions can be approved for up to 7 days past the due date for an assessment. (Where students need an extension exceeding 7 days, they must instead apply for special consideration.)   

 

Special Consideration:   

• An application for special consideration is made in advance of an assessment wherever possible, but will normally be accepted within five working days after the assessment date. For more information, see the Special Consideration page of the RMIT website. 

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