Course Title: Integrate databases with websites

Part B: Course Detail

Teaching Period: Term2 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

14-20 July

Introduction to web development

Assessment 1 overview

Project brief

2

21-27 July

Creating HTML documents

HTML structure

HTML elements and structure

W3C standards

3

28 July - 3 August

Introduction to CSS

Principles of web page design and storyboards

4

4-10 August

CSS properties and web page layout and design

5

11-17 August

HTML forms

Forms styling with CSS

6

18-24 August

Testing and demonstrations

Assessment 1 submission

Mandatory class attendance

Testing workshop and demonstrations

Assessment 1 submitted to Canvas end of week 6

7

25-31 August

ntroduction to PHP and dynamic websites.

Servers and Clients

PHP syntax - variables, strings, arrays

Assessment 2 overview

Website technical requirements

Mid Semester Break - 1-7 September

8

8-14 September

HTTP request methods POST and GET

Storing and retrieving data from arrays

9

15-21 September

Database structure

OOP classes

Connecting to database

10

22-28 September

SQL insert queries

HTML forms

SQL injection; cleansing form data and error control

11

29 September - 5 October

Demonstrations

User testing

Assessment 2 submission

Mandatory class attendance

Testing workshop and demonstrations

Assessment 2 submitted to Canvas end of week 11

12

6-12 October

SQL select queries

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

Loops, HTML & CSS

Assessment 3 overview

Website technical requirements

13

13-19 October

SQL, PHP functions

and scripts to delete data from a database.

14

20-26 October

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

15

27 October- 2 November

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

3-9 November

Feedback & Re-submission of Assessments (If applicable)

17

10-16 November

Feedback & Re-submission of Assessments (If applicable)

18

17-23 November

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.

Email Communication:

All email communications will be sent to your RMIT email address and you must regularly check your RMIT emails

Course Overview: Access Course Overview