Alce kon William Smithfield David H. Senior Ditatase LAgw 33.7 $ 450.45 $ 35.75 $ 96.75 106 126 102 Systems Analyst 23.8 $2,302.65 Subtotal $10,573.50 Anneloe Jones James L Frommer Anne K. Ramoras Darlene M. Smithon $ 48.10 $ 18.36 5 75 $ 45.95 $1,183.26 $831.71 $ 3,134.70 $2.067.75 18 Amber Wave 114 Applications Designer General Support Systems Analyst DSS Analyt Subtotal Datahase Designer Systems Analyst Applications Designer Clerical Support Programmer 25.6 118 45.3 104 32.4 112 45.0 $7,265.52 Roling Tide 105 Alice K kohnon $6,998.50 $44.682.70 22 $105.00 $ 6.75 $ 48.10 65.7 104 Anne K. Ramora 48.4 113 Debert K. koenbrood 23.6 $1,135.16 111 Geoff . Wabanh $2687 22.0 591.14 106 William Smithlield 5 35.75 128 457.60 %3B

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Exercise 1. Normalize following unnormalized relation
PROJECT PRCHCY
NUMBER NAME
Evergreen
EMPLOYEE
NUMBER
CHARGE
HOUR
HOURS
ILLED
EMPLOE
TOTAL
NAME
June E. Arbough
John G. News
Alice K. kohnson
William Smithfield
David H. Senior
CLASS
Elec. Engineer
Database Designer
Database Designer
$ 2,034.90
$ 2,037.00
$1,748.50
$ 450.45
15
103
$85.50
230
101
$105.00
19.4
105
$105.00
35.7
$ 35.75
$ 6.75
106
126
102
Systems Analyst
Subtotal
Applications Designer
General Support
Systems Analyst
DSS Analyst
218
$2.302.65
S10,573.50
14
$ 48.10
$ 18.36
$ 9675
$ 45.95
$ 1,183.26
$ 831.71
53,134.70
$2.067.75
$ 7.265.52
$ 6,998.50
$4,682.70
$ 1,135.16
S S91.14
$ 457.60
$1,765.10
$915.20
$4,431.15
$ 5,911.50
$ 1,592.11
$ 2,203.30
$ 559.98
$1902.33
$17,595.57
18
Amber Wave
Annelne Jones
James Frommer
Anne K. Ramoras
Darlene M. Smithon
25.6
118
45.3
104
324
112
45.0
Subtotal
$105.00
$6.75
$ 48.10
Roling Tide
Database Designer
Systems Analyst
Applications Deigner
Clerical Support
Programmer
Subtotal
22
105
Alice K. Johnson
Anne K. Ramoras
Debert K. oenbrood
Geolf . Wahash
William Smithlield
65.7
104
113
48.4
236
111
$.26.87
220
106
$ 35.75
128
Sturflight
Maria D. Alono
Travis 8. Bawang
John G. News
Annelise ones
Ralph B. Washingon
Lames Frommer
Darlene M. Smithon
$ 35.75
$96.75
$105.00
25
107
Programmer
Systems Analyst
Database Designer
Applications Designer
Systems Analyst
General Support
25.6
115
458
101
56.3
33.1
236
114
$4 48.10
100
$675
S18.36
$445.95
118
30.5
112
DSS Analyst
Subtotal
41.4
Total
$49,199.69
Answer.
Transcribed Image Text:Exercise 1. Normalize following unnormalized relation PROJECT PRCHCY NUMBER NAME Evergreen EMPLOYEE NUMBER CHARGE HOUR HOURS ILLED EMPLOE TOTAL NAME June E. Arbough John G. News Alice K. kohnson William Smithfield David H. Senior CLASS Elec. Engineer Database Designer Database Designer $ 2,034.90 $ 2,037.00 $1,748.50 $ 450.45 15 103 $85.50 230 101 $105.00 19.4 105 $105.00 35.7 $ 35.75 $ 6.75 106 126 102 Systems Analyst Subtotal Applications Designer General Support Systems Analyst DSS Analyst 218 $2.302.65 S10,573.50 14 $ 48.10 $ 18.36 $ 9675 $ 45.95 $ 1,183.26 $ 831.71 53,134.70 $2.067.75 $ 7.265.52 $ 6,998.50 $4,682.70 $ 1,135.16 S S91.14 $ 457.60 $1,765.10 $915.20 $4,431.15 $ 5,911.50 $ 1,592.11 $ 2,203.30 $ 559.98 $1902.33 $17,595.57 18 Amber Wave Annelne Jones James Frommer Anne K. Ramoras Darlene M. Smithon 25.6 118 45.3 104 324 112 45.0 Subtotal $105.00 $6.75 $ 48.10 Roling Tide Database Designer Systems Analyst Applications Deigner Clerical Support Programmer Subtotal 22 105 Alice K. Johnson Anne K. Ramoras Debert K. oenbrood Geolf . Wahash William Smithlield 65.7 104 113 48.4 236 111 $.26.87 220 106 $ 35.75 128 Sturflight Maria D. Alono Travis 8. Bawang John G. News Annelise ones Ralph B. Washingon Lames Frommer Darlene M. Smithon $ 35.75 $96.75 $105.00 25 107 Programmer Systems Analyst Database Designer Applications Designer Systems Analyst General Support 25.6 115 458 101 56.3 33.1 236 114 $4 48.10 100 $675 S18.36 $445.95 118 30.5 112 DSS Analyst Subtotal 41.4 Total $49,199.69 Answer.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY