In this project you will develop a Human Resources (HR) Portal web application with the following components: · Landing Page – provides information about the portal and links to different web

In this project you will develop a Human Resources (HR) Portal web application with the following components: · Landing Page – provides information about the portal and links to different web
CTI-110 WEB, PROGRAMMING AND DATABASE FOUNDATIONS CTI.110 – Group Project Pulling the Web, Database and Backend Programming Together Objectives: Work with a group to complete a project. Create a Web Application integrating: PHP programs Web Technologies SQL and Database Create consistent style within the web application Project Description – Human Resources (HR) Portal In this Group Project, each group will develop a Human Resources (HR) Portal web application with the following components: Landing Page – provides information about the portal and links to different web applications, integrates different Database Reports and some common generic calculators and applications. Form Page – allows user to input data in accordance with the requirements below. Php Program – processes the input data and generate the output/results. HR Database – contains 7 tables used by the HR Portal. Lab Task Checklist It is expected you have read the required reading in this course. Review the Group Project Overview. Review Database Installation and Preparation and install the HR Database. Review the Minimum Requirements for the Portal. Ensure your html and css meets W3C validation. Ensure all web pages have the same CSS style. Test your HR web applications using XAMPP and localhost. All files must be in your xampp / htdocs folder for localhost to work. Upload all needed files for your PORTAL WEB APPLICATION to Blackboard. You do not need to upload the database. The instructor will already have a copy. Portal Landing Page Instructions Semantic Tags will be used The web page should meet accessibility requirements There should be at least one image At least one table At least 2 sections Navigation sections with required portal links See below for minimum CSS Selectors required Form Page Instructions Semantic Tags will be used The web page should meet accessibility requirements Add the required CSS styling. Styling will be common to all web forms, portal landing page and php html output See below for minimum CSS Selectors required PHP Program Instructions Semantic Tags will be used for HTML output Add the required CSS styling. Styling will be common to all web forms, portal landing page and php html output See below for minimum CSS Selectors required Minimum HR portal Requirements Create the Portal Landing Page (LP) for your project. Name Convention — group#-hr-portal.html. Create a php program using SQL to create a report where the HR employee can search the HR database by last name or employee ID. The results should include all fields in table employee and the Job Title in jobs table. Naming Convention: group#-hr-emp-search.html and group#-hr-emp-search.php. See below for example of minimum render: Example: Form Input for Last Name: King Example: Form Input for Employee ID 100 Create a php program using SQL to create a report where the HR employee can search the HR database for specific job titles and provide a list of employees with that job title as well as the average salary for that job title. Naming Convention: group#-hr-job-title.html and group#-hr-job-title.php. See below for example of minimum render: Example: Form Input for Job Title Group Choice. Naming Convention: group#-hr-??.html and group#-hr-/??.php. ?? to be determined by group. Create a php program using SQL to create a report using at least two of the following tables: Countries Departments Locations Regions Employees Generic Employee Calculators. Naming Convention: group#-hr-fuel.html and group#-hr-fuel.php. Write web- based application that will calculate and display the fuel costs for a trip. The user will provide the cars average miles per gallon, expected cost of gas per gallon, and the length of the trip to be traveled. The program needs to calculate and display the cost of the trip based on the input. Travel cost = miles traveled/mpg * cost Make sure the styling used is consistent for all web pages of the HR Portal. Naming Convention: group#-hr-style.css. Minimum CSS Selector Instructions Selector Property Notes body background-color font-family primary with 2 backup header background-color color text-align padding margin nav ul list-type padding font-size ul List-type Padding Border li border padding Nav Width float a text-decoration color img Border width h1, h2, h3 color each with different color table, th ,td border thead background-color color tbody color tfoot font-size color background-color caption font-family font-weight font-size color border primary with 2 backup Button background-color Color font-size legend background-color Color padding Define a minimum of 2 classes Adjust a minimum of 3 properties Submit Files to Blackboard to Blackboard Complete the following program documents, compress all files in a .zip file and submit at BB – Portal Landing Page (LP) Portal Form Pages (form) — you will need multiple form pages, most likely one for each minimum requirement. PHP programs — that will complete the processing required. Test plan/cases — Microsoft word document. The Project Manager will submit the project .zip file to Blackboard (do not forget to upload your image used in your code as well) by the due date. Do not need to upload the database. The instructor will already have a copy.