Assignment Task :

Introduction
You are required to develop a web application to process data from Oracle database tables and JSON files.
The application will use PHP and AJAX.
 

Preparation
The website will use data from a database tables, and a JSON file, as explained below.
1. You will need a database table which contains data used to validate users before they are able to log into the website. Create a login table in Deakin Oracle SSID database with the appropriate fields.
The minimum requirement will be fields for username and password.

2. Create an employees table in the SSID database.

The fields should be:

  • employee_id
  • firstname
  • lastname

3. Populate employees table and the login table with some data.
4. Download the JSON file used in Assignment 1 employees.json
 

Requirements
1. Login page 

  • Create a Login page which accepts a username and password.
  • Create the following username/password for logging in : deakin/SIT780
  • Ensure that passwords are not stored as plain text in the database.
  • Captcha needs to be used in the login page to ensure that a human-being is attempting to login.

 

2. Welcome page  

  • After successful validation, a welcome page should be displayed.
  • The welcome page should display a menu to navigate to the options in #3, #4, and #5 below.
  • Logout option should be provided on each page

3. Display employees data  

  • Merge the data sources below and display in a HTML table.
  • employees.json
  • employees table in the database

 

4. Search employee data  
Provide a Single Page Application, using JavaScript or jQuery, to search employees data in the employees table and employees.json by firstname and lastname. Results should be formatted appropriately and displayed

 

This Engineering Assignment has been solved by our Engineering Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Grace
  • Posted on : May 12th, 2019

Whatsapp Tap to ChatGet instant assistance