PROJ_NUM PROJ_NAME EMP_NUM EMP NAME JOB_CODE JOB_CHO_HOUR PROJ_HOURS EMP_PHONE 1 Hurricane 101 John D. Newson EE 85.00 13.3 653-234-3245 1 Hurricane 105 David F. Schwann CT 60.00 16.2 653-234-1123 1 Hurricane 110 Anne R. Ramoras CT 60.00 14.3 615-233-5568 2 Coast 101 John D. Newson EE 85.00 19.8 653-234-3254 2 Coast 108 June H. Sattlemeir EE 85.00 17.5 905-554-7812 3 Satellite 110 Anne R. Ramoras CT 62.00 11.6 615-233-5568 3 Satellite 105 David F. Schwann CT 26.00 23.4 653-234-1123 3 Satelite 3 Satellte 123 Mary D. Chen EE 85.00 19.1 615-233-5432 112 Allecia R. Smith BE 85.00 20.7 615-678-6879
PROJ_NUM PROJ_NAME EMP_NUM EMP NAME JOB_CODE JOB_CHO_HOUR PROJ_HOURS EMP_PHONE 1 Hurricane 101 John D. Newson EE 85.00 13.3 653-234-3245 1 Hurricane 105 David F. Schwann CT 60.00 16.2 653-234-1123 1 Hurricane 110 Anne R. Ramoras CT 60.00 14.3 615-233-5568 2 Coast 101 John D. Newson EE 85.00 19.8 653-234-3254 2 Coast 108 June H. Sattlemeir EE 85.00 17.5 905-554-7812 3 Satellite 110 Anne R. Ramoras CT 62.00 11.6 615-233-5568 3 Satellite 105 David F. Schwann CT 26.00 23.4 653-234-1123 3 Satelite 3 Satellte 123 Mary D. Chen EE 85.00 19.1 615-233-5432 112 Allecia R. Smith BE 85.00 20.7 615-678-6879
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
Related questions
Question
FIGURE P1.5 The File Structure for Problems 5-8
REFER IMAGE
Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5.
Transcribed Image Text:PROJ_NUM PROJ_NAME EMP_NUM
EMP NAME
JOB_CODE JOB_CHO_HOUR PROJ_HOURS EMP_PHONE
1 Hurricane
101 John D. Newson
EE
85.00
13.3 653-234-3245
1 Hurricane
105 David F. Schwann CT
60.00
16.2 653-234-1123
1 Hurricane
110 Anne R. Ramoras
CT
60.00
14.3 615-233-5568
2 Coast
101 John D. Newson
EE
85.00
19.8 653-234-3254
2 Coast
108 June H. Sattlemeir EE
85.00
17.5 905-554-7812
3 Satellite
110 Anne R. Ramoras
CT
62.00
11.6 615-233-5568
3 Satellite
105 David F. Schwann CT
26.00
23.4 653-234-1123
3 Satelite
3 Satellte
123 Mary D. Chen
EE
85.00
19.1 615-233-5432
112 Allecia R. Smith
BE
85.00
20.7 615-678-6879
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
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.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education