Course Title: Integrate database with a website

Part B: Course Detail

Teaching Period: Term2 2020

Course Code: COSC7372C

Course Title: Integrate database with a website

School: 650T Vocational Business Education

Campus: City Campus

Program: C5395 - Diploma of Information Technology

Course Contact: Val Christou

Course Contact Phone: +61 3 9925 5076

Course Contact Email: val.christou@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

course leader: Sarah Mackinnon

emailsarah.mackinnon@rmit.edu.au

phone:+61 03 99255518 

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

This unit describes the skills and knowledge required to ensure the database is integrated with a website.

It applies to individuals employed as web developers who are responsible for creating data-driven web applications.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICTDBS504 Integrate database with a website

Element:

1. Connect to the database

Performance Criteria:

1.1 Identify site data needs from technical requirements 1.2 Connect to database from web application using a web development language

Element:

2. Retrieve data from database and display on web pages

Performance Criteria:

2.1 Retrieve data using structured query language (SQL) 2.2 Display data in the most appropriate control 2.3 Format data so that it is displayed in the most effective way

Element:

3. Update the database data from user input

Performance Criteria:

3.1 Update existing data stored in the database with user-supplied input 3.2 Insert data in the database with user-supplied input 3.3 Delete data stored in the database  3.4 Include error checking and validation


Learning Outcomes



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

Week

Week Beginning

Topic

Learning Materials and Activities

Assessment Remarks

1

July 6

Introduction to PHP and dynamic websites.

Servers and Clients

Setting up RMIT server accounts

Installing a virtual server

Assessment 1 overview

Website technical requirements

2

July 13

PHP syntax - variables, strings, arrays

Forms and HTTP requests

Creating basic PHP scripts using strings and variables and arrays

 

 

3

July 20

HTTP request methods POST and GET.

Storing and retrieving data from arrays

Creating HTML forms and using HTTP request methods (POST & GET)

Arrays and loops

 

4

July 27

Database structure

OOP classes

Connecting to database

Database structure

OOP classes

Connecting to a database

 

 

5

Aug 3

SQL insert queries

HTML forms

PHP scripts

Creating HTML forms and writing PHP scripts to insert data into a database

 

6

Aug 10

SQL insert queries

HTML forms

SQL injection; cleansing form data and error control

Creating HTML forms and writing PHP scripts to insert data into a database

 

Writing PHP functions to cleanse form data and capture SQL errors

 

 

7

Aug 17

Demonstrations

User testing

Testing workshop and demonstrations

 

Assessment 1 submission

Mandatory class attendance

Testing workshop and demonstrations

 

8

Aug 24

SQL select queries

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

Loops, HTML & CSS

Writing PHP scripts to select and display database records

Applying HTML and CSS to data display

Assessment 2 overview

Website technical requirements

Mid-Semester break (29th August to 6th September)

9

Sept 7

SQL, PHP functions and scripts to search, select and display data from a database.

SQL select queries

Writing PHP scripts to select and display data from a database

 

10

Sept 14

SQL, PHP functions and scripts to search, select and display data from a database.

SQL select queries

Writing PHP scripts to select and display data from a database

 

 

11

Sept 21

User requirements testing - class activity

 

User requirements testing - class activity

 

Assessment 2 submission

Mandatory class attendance

Website user testing workshop

 

12

Sept 28

SQL, PHP functions

and scripts to delete data from a database.

Writing PHP scripts to delete database records

Assessment 3 overview

Website technical requirements

13

Oct 5

SQL, PHP functions

and scripts to update data in a database.

Writing PHP scripts to update database records

 

14

Oct 12

Web Design concepts

User testing

Project work

Web design concepts

User testing activity

Project work

 

15

Oct 19

In class - Project Demonstrations

Testing workshop and demonstrations

Assessment 3 submission

Mandatory class attendance

Testing workshop and project demonstrations

 

16

Oct 26

 Re-submit if required

 Re-submit if required

 


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

  • USB or external hard drive for backup
  • Text editor such as Programmer's Notepad / Sublime


Overview of Assessment

In order to achieve competency in this unit, you must provide:

Performance Evidence

 Evidence of the ability to:

  • access database using a web development language
  • retrieve and display web-based data
  • update web-based data.

Knowledge Evidence

To complete the unit requirements safely and effectively, you must:

  • describe a database structure
  • outline internet technology as it relates to the use of databases
  • identify and apply programming control structures, including object-oriented programming and structured query language (SQL)
  • explain web programming concepts, including:
  • authentication and web security
  • hypertext transfer protocol (HTTP)
  • session management
  • defining the principles of stateless programming.

 Assessment Conditions

Assessment must be conducted in a safe environment where evidence gathered demonstrates consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the database field of work, and include access to:

  • equipment
  • industry software packages
  • the requirements documentation
  • a web server
  • a database
  • the web development environment
  • browsers.

You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.

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 Tasks

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

 

COSC7369C (ICTWEB501) - Build a dynamic website

COSC7372C (ICTDBS504) - Integrate database with a website

 

Overview

 

You are required to read and analyse the technical requirements for a business website; produce the design specifications and build the dynamic website to meet the requirements. The website project will be built using a MySQL database and PHP (object-oriented) scripting language. There are 3 parts to this project.

Assessment Task 1 – Dynamic Website Project (part 1)

 

  • Produce design specifications
  • Explain web design concepts
  • Write PHP scripts to connect to a database and insert new records via a web page
  • Test the website functionality
  • Demonstrate your website to the teacher and obtain feedback (in class week 7)
  • After your demonstration, submit a ZIP file containing all project files and documentation to Canvas by the end of week 7

  

Assessment Task 2 – Dynamic Website Project (part 2)

 

  • Produce design specifications
  • Explain web design concepts
  • Write PHP scripts to connect to a database and retrieve records via a web page
  • Style the web pages using HTML structure and CSS design
  • Test the website functionality 
  • Submit a ZIP file containing all project files and documentation to Canvas by the end of week 11

 

Assessment Task 3 – Dynamic Website Project (part 3)

  • Produce design specifications
  • Explain web design concepts
  • Write PHP scripts to connect to a database and update and delete records via a web page
  • Test the website functionality
  • Demonstrate your completed website to the teacher and obtain feedback (in class week 15) 
  • After your demonstration, submit a ZIP file containing all project files and documentation to Canvas by the end of week 15


Assessment Matrix

Elements/Performance Criteria

Assessment Details

1. Connect to the database

1.1 Identify site data needs from technical requirements

1.2 Connect to database from web application using a web development language

 

Assessment 1 - dynamic website project 

Assessment 1 - dynamic website project 

Assessment 3 - dynamic website project 

2. Retrieve data from database and display on web pages

2.1 Retrieve data using structured query language (SQL)

2.2 Display data in the most appropriate control

2.3 Format data so that it is displayed in the most effective way

Assessment 2 - dynamic website project

 

3. Update database data from user input

3.1 Update existing data stored in the database with user-supplied input

3.2 Insert data in the database with user-supplied input

3.3 Delete data stored in the database

3.4 Include error checking and validation

Assessment 1 - dynamic website project

Assessment 3 - dynamic website project

Performance Evidence

 

access database using a web development language

retrieve and display web-based data

update web-based data.

Assessment 1 - dynamic website project

Assessment 2 - dynamic website project

Assessment 3 - dynamic website project

Knowledge Evidence

 

describe a database structure

outline internet technology as it relates to the use of databases

identify and apply programming control structures, including structured query language (SQL)

explain web programming concepts, including:

authentication and web security

hypertext transfer protocol (HTTP)

session management

defining the principles of stateless programming

 

Assessment 1 - dynamic website project

Assessment 2 - dynamic website project

Assessment 3 - dynamic website project

Other Information

GENERAL SUBMISSION INFORMATION

Ensure that you submit assessments on or before the due date. 
Always retain a copy of your assessment tasks. (hard copy and soft copy)
When you submit work for assessment at RMIT University you need to use a cover sheet that includes a declaration and statement of authorship. You must complete, sign and submit a cover sheet with all work you submit for assessment, whether individual or group work.  On the cover sheet you declare that the work you are presenting for assessment is your own work. 

Late Submission Procedures

You are required to submit assessment items and/or ensure performance based assessment is completed by the due dates.
Late submissions of assessments will be eligible for grading at CAG (Competency Achieved) level only
If you are prevented from submitting an assessment item on time, by circumstances outside your control, you may apply in advance to your teacher for an extension to the due date of up to seven calendar days.

More Information:  http://www.rmit.edu.au/students/assessment/extension
Form to use:  http://mams.rmit.edu.au/seca86tti4g4z.pdf

Where an extension of greater than seven days is needed, you must apply for special consideration.  Applications for special consideration must be submitted no later than two working days after the assessment task deadline or scheduled examination.


More Information: http://www.rmit.edu.au/browse;ID=g43abm17hc9w (unresolved)
Form to use: http://mams.rmit.edu.au/8a5dgcaqvaes1.pdf

Resubmissions (VET Programs):

If you are found to be unsuccessful in a Course Assessment Task you will be allowed one resubmission only.  Your teacher will provide feedback regarding what you need to do to improve and will set a new deadline for the resubmission.  The highest grade you will receive if your resubmission is successful is “CAG”.
If you are still not meeting the assessment requirements you must apply to your Program Manager in writing outlining the steps you will take to demonstrate competence in your course. Your submission will be considered by the Program Team and you will be advised of the outcome as soon as possible.

Adjustments to Assessment

In certain circumstances students may be eligible for an assessment adjustment. For more information about the circumstances under which the assessment arrangements might be granted please access the following website:
More Information: http://rmit.edu.au/browse;ID=7usdbki1fjf31

Marking Guide (Competency):

You must demonstrate that you have all the required skills/knowledge/elements in the unit of competency you are studying.
You will receive feedback on each assessment task that will inform you about your progress and how well you are performing.

CA - Competency Achieved 
NYC - Not Yet Competent
DNS - Did Not Submit Assessment

 

Course Overview: Access Course Overview