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
email: sarah.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