Answered: ("View all employees" function) If…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

("View all employees" function) If users click "View all employees" ( call program:
view_employee.php), your program should
(i) Retrieve all employees from TECH3740. EMPLOYEE table and list all employees in HTML
TABLE format
(ii) If the salary is NULL, print it in red color.
(iii) If Gender='M', print it in blue color. If Gender='F', print it in red color.
(iv) Display the average salary of listed employees at the bottom of the employee table.
(v) A statement "There are # employee(s) in the database." should be displayed above the
employee table, where # is the number of employees.

Transcribed Image Text:| Fname +- | Jared Jon Justin Brad John Evan Josh Andy Tom Jenny Chris Kim Jeff | Alex | Bonnie Alec Sam Joyce John Nandita Bob Jill Kate Lyle Billie Jon Ray | Gerald Arnold Helga Naveen Carl Sammy Red Ramesh James Jennifer Ahmad | Minit | Lname James Jones Mark Knight | Smith | | Wallis Zell Vile | Brand | F | A | C | н Franklin | T | D | S | C | Alicia D | C NULL | C | В E | U с G S | A | C | к B | J W G | A | H D | A | с | B | E G A | K | E | S | V | J | Ssn | 111111100 | 111111101 111111102 | 111111103 123456789 | 222222200 222222201 222222202 222222203 | 222222204 222222205 333333300 333333301 | 333445555 444444400 444444401 | 444444402 | Snedden | 444444403 | English | 453453453 James Ball 555555500 555555501 666666600 | 666666601 666666602 666666603 666666604 666666605 666666606 | 666666607 666666608 666666609 666666610 666666611 666666612 666666613 | Narayan | 666884444 Borg Bacher | 888665555 | Wallace | 987654321 987987987 | Jabbar | Zelaya | 999887777 Vos Carter Grace | Chase Wong Freed Bays | Best | Bender Jarvis King | Leslie | King | Kramer King Small | Head | Pataki Drew Reedy Hall | Bdate | Sex | M IM | Address 1966-10-10 | 123 Peachtree, Atlanta, GA 1967-11-14 | 111 Allgood, Atlanta, GA 1966-01-12 | 2342 May, Atlanta, GA 1968-02-13 | 176 Main St., Atlanta, GA 1955-01-09 | 731 Fondren, Houston, TX 1958-01-16 | 134 Pelham, Milwaukee, WI 1954-05-22 | 266 McGrady, Milwaukee, WI 1944-06-21 | 1967 Jordan, Milwaukee, WI 1966-12-16 112 Third St, Milwaukee, WI 1967-11-11 | 263 Mayberry, Milwaukee, WI 1960-03-21 | 565 Jordan, Milwaukee, WI 1970-10-23 | 6677 Mills Ave, Sacramento, CA 1970-01-07 145 Bradbury, Sacramento, CA 1945-12-08 | 638 Voss, Houston, TX 1950-10-09 | 4333 Pillsbury, Milwaukee, WI 1956-06-19 | 111 Hollow, Milwaukee, WI 1966-06-18 | 233 Solid, Milwaukee, WI 1977-07-31 | 987 Windy St, Milwaukee, WI 1962-07-31 | 5631 Rice Oak, Houston, TX 1975-06-30 | 7676 Bloomington, Sacramento, CA | M 1969-04-16 | 222 Howard, Sacramento, CA M 1968-04-17 8794 Garfield, Chicago, IL M F F | M F M M M IM 1966-01-14 | 6234 Lincoln, Chicago, IL 1966-04-16 | 1976 Boone Trace, Chicago, IL 1963-06-09 | 417 Hancock Ave, Chicago, IL 1960-01-01 556 Washington, Chicago, IL 1964-08-22 | 1988 Windy Creek, Seattle, WA 1949-08-16 | 213 Delk Road, Seattle, WA 1962-05-15 | 122 Ball Street, Dallas, TX 1967-05-19 | 233 Spring St, Dallas, TX 1969-03-11 101 Holyoke St, Dallas, TX 1970-05-23 | 198 Elm St, Philadelphia, PA 1977-06-21 | 213 Ball St, Philadelphia, PA 1970-01-11 | 433 Main Street, Miami, FL 1980-05-21 | 196 Elm Street, Miami, FL 1952-09-15 | 971 Fire Oak, Humble, TX 1927-11-10 | 450 Stone, Houston, TX 1931-06-20 | 291 Berry, Bellaire, TX 1959-03-29 | 980 Dallas, Houston, TX 1958-07-19 | 3321 Castle, Spring, TX F M | M M | M M M M | M | M M M M F F | F M M | M F M | M F M | F M | F | Salary | 85000.00 | NULL | 45000.00 | 111111100 40000.00 | 111111100 | Super_ssn | Dno | 44000.00 | 111111100 | 30000.00 | 333445555 | | 92000.00 | NULL | 56000.00 | 222222200 | 53000.00 | 222222200 | 62500.00 | 222222200 | 61000.00 | 222222201 43000.00 | 222222201 |79000.00 | NULL | 44000.00 333333300 | 40000.00 | 888665555 | |89000.00 | NULL 70000.00 | 444444400 | 60000.00 | 444444400 | 48000.00 | 444444400 | 25000.00 | 333445555 | 81000.00 | NULL | 62000.00 | 555555500 | 96000.00 | NULL | 36000.00 | 666666600 | 44000.00 | 666666600 | 41000.00 | 666666601 | 38000.00 | 666666603 | 41500.00 | 666666603 44500.00 666666604 | 29000.00 | 666666602 | 33000.00 | 666666602 | 32000.00 | 666666602 | 34000.00 | 666666607 | 32000.00 | 666666610 | 37000.00 | 666666611 | 33500.00 | 666666612 | 38000.00 | 333445555 | 55000.00 | NULL | 43000.00 | 888665555 | 25000.00 | 987654321 | 25000.00 987654321 | 666NNAN LONN ∞ ∞ ∞ ∞ ∞0 00 00 00 00 00 00 00 00 00 L 6 | 6 | 6 5 7 | 7 7 7 7 7 6 6 | 5 7 | 7 7 7 5 6 | 6 | 8 8 8 8 | 8 | 8 8 8 8 8 8 8 8 8 5 1 4 | 4 | 4

There are 6 employee(s) in the database.
ID Login Password
Name
Role Gender Salary Address
1 tiger xyz123
Victor Smith S M 2500 1000 Morris Ave., Union, NJ 07083
John Lee
5000 133 Main St., Austin, TX
E M
|Austin test
S
F
New test
M
6000 71 Central Ave., Newark, NJ 07188
NULL 460 4th Ave., New York, N 101
1000 100 Texas Rd, Edison, NJ 07711
1000 100 Main Rd, Edison, NJ 07711
Tester 2019 E
F
my Test
M
2 panda xyz333
5 Austin 613d3b9c91
6 fish ||111
7 bear
8 lion 1234
abc123
Average salary: 3,100.0
EES
E

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.