(It does not let me send the database used in this project I will email it to you once you accept the assignment) In this assignment you will need to understand php, html. and sql languages, below is

CTI-110 WEB, PROGRAMMING AND DATABASE FOUNDATIONS

CTI.110 - Group Project

Pulling the Web, Database and Backend Programming Together

• 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

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.

• 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.

1. Semantic Tags will be used

2. The web page should meet accessibility requirements

3. There should be at least one image

4. At least one table

5. At least 2 sections

6. Navigation sections with required portal links

7. See below for minimum CSS Selectors required

1. Semantic Tags will be used

2. The web page should meet accessibility requirements

3. Add the required CSS styling. Styling will be common to all web forms, portal landing page and php html output

4. See below for minimum CSS Selectors required

1. Semantic Tags will be used for HTML output

2. Add the required CSS styling. Styling will be common to all web forms, portal landing page and php html output

3. See below for minimum CSS Selectors required

1. Create the Portal Landing Page (LP) for your project. Name Convention -- group#-hr-portal.html.

2. 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

1. 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

1. 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:

   1. Countries

   2. Departments

   3. Locations

   4. Regions

   5. Employees

1. 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

1. Make sure the styling used is consistent for all web pages of the HR Portal. Naming Convention: group#-hr-style.css.

• 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.