Questions & AnswersSoftware engineering

Final project Creation of the database and tables: Using the...

Question
Answered step-by-step
Asked by Aixa41863 on coursehero.com

Final project Creation of the database and tables: Using the...

Final project

Creation of the database and tables:

Using the phpMyAdmin development environment, generate the SQL script 

Required to create the database and the two tables specified at 

continuation:

to. Create the INTEdb database

b. Create "Employee" table:

Id_empleado (PK)

name

surname

paga_hora

ded_ss

ded_tax

c. Create "Payroll" table.

Id_empleado (FK)

fecha_nomina

horas_trabajadas

Employee table population:

Using the phpMyAdmin development environment, generate the SQL script 

Required to insert 10 records into the employee database:

 Insert 10 records into the employee table.

Creating the relationship between the "employee" and "payroll" tables:

Using the phpMyAdmin development environment, create the relationship between the 

Primary key of the "Employee" table and the foreign key of the table "Payroll"

Payroll table population with payroll data for that date:

Using the phpMyAdmin development environment, generate the SQL script 

necessary to insert the payroll of each of the employees for a Specific date.

Required reports:

Using the phpMyAdmin development environment, generate the SQL script 

Required to create the following reports:

Employee report

(EmployeeID,first name,last name,paga_hora,ded_ss,ded_tax)

Employee report and information filtered by (Name, date 

payroll and hours worked)

Payroll report with computations of gross salary, net, 

Deductions 

(employee.name,nomina.fecha_nomina,nomina.horas_trabajadas)

Export the report to cvs format.

Answer & Explanation

Solved by verified expert
Answered by gonzalesmardie on coursehero.com

sectetur adipiscing elit. Nam lacini

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetu
CliffsNotes Logo

Unlock access to this and over
10,000 step-by-step explanations

Unlock Explanation

Have an account? Log In

<p>sectetur adipiscing elit. Nam lacini</p>sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetu

Step-by-step explanation

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facili

  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie co
  • sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrice

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus eff

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis.

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce du

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque da

  • sect
  • sectetu
  • sectetur a
  • sectetur adipiscing elit.
  • sectetur adipi

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus effi

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur lao

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. P

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue ve

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor ne

sectetur adipisc

sec

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus e

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur la

  • sectetur ad
  • sect
  • sectetu
  • sectetur a
  • sectetur adipiscing elit.
  • sectetur adipi

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet a

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices a

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisi

sec

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem i

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Na

  • sectetur adip
  • sectetur adipis
  • sectetur adipiscing el
  • sectetur adi
  • sectetur a

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laore

sectetur adipiscing elit. Nam la

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lec

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet

 

sectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, c

Get unstuck with a CliffsNotes subscription

Example CliffsNotes Question and Answer
Unlock every step-by-step explanation, download literature note PDFs, plus more.Get Access

Related Q&A