Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create MySQL database: NOMINA_DB Create a table of Employees_tbl IDEmp, Employee name, Phone, Town, Start date, Department Create Payroll_tbl Table ID, EmpID, Rate, Hours worked,

Create MySQL database:  NOMINA_DB

Create a table of Employees_tbl
IDEmp, Employee name, Phone, Town, Start date, Department
Create Payroll_tbl Table
ID, EmpID, Rate, Hours worked, Payroll date
CREATE HTML with Welcome and introduction (project) with links to other pages:

INSERT NEW RECORDS
HTML form to INSERT new Records in Employee table
VIEW REPORT
HTML page with PHP to display Payroll report by employee.
Display: Employee Name, Gross Salary (Hourly Rate)
All pages must be styled with r CSS to look presentable.

place "button" or link to go back to home page


Step by Step Solution

3.38 Rating (154 Votes )

There are 3 Steps involved in it

Step: 1

To create the MySQL database and tables Create the database CREATE DATABASE NOMINADB Use the database USE NOMINADB Create the Employeestbl table CREATE TABLE Employeestbl IDEmp INT AUTOINCREMENT PRIMA... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Pathway To Introductory Statistics

Authors: Jay Lehmann

1st Edition

0134107179, 978-0134107172

More Books

Students also viewed these Programming questions