7. What new files should you create to help eliminate the data redundancies found in the file shown below? UNC CODE JOB_CHO HOUR PROJ HOURS EM PHONE 133 653-234-3245 16.2 653-224-1123 14.3 615-233-6568 19.0.653-234-3254 175 905-554-7012 116615-223 5680 23.4 553-234-1123 19.1615-233-5432 207 615-878-6679 PROJUNUM PROJ NAME EMP NUM, 1 Huricane 1 Hunicane 1 Humicane BMP NAME 101 JOh D Newson 105 David F. Schwann CT EE 85 DO E0.00 60.00 110 Ave R. Romeras EE CT 101 John D. Newwoon 05.00 2 Cuast 2 Coast 3 Satelite 3 Sotelite 108 June H Sottieme EE 65.00 62.00 26.00 110 Anne R. Renoras cr 105 David F Schwern CT 55.00 123 Mary D Chen 112 Alecia R. Smith EE 3 Satelte DE 05.00 3 Satelite
7. What new files should you create to help eliminate the data redundancies found in the file shown below? UNC CODE JOB_CHO HOUR PROJ HOURS EM PHONE 133 653-234-3245 16.2 653-224-1123 14.3 615-233-6568 19.0.653-234-3254 175 905-554-7012 116615-223 5680 23.4 553-234-1123 19.1615-233-5432 207 615-878-6679 PROJUNUM PROJ NAME EMP NUM, 1 Huricane 1 Hunicane 1 Humicane BMP NAME 101 JOh D Newson 105 David F. Schwann CT EE 85 DO E0.00 60.00 110 Ave R. Romeras EE CT 101 John D. Newwoon 05.00 2 Cuast 2 Coast 3 Satelite 3 Sotelite 108 June H Sottieme EE 65.00 62.00 26.00 110 Anne R. Renoras cr 105 David F Schwern CT 55.00 123 Mary D Chen 112 Alecia R. Smith EE 3 Satelte DE 05.00 3 Satelite
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
![7. What new files should you create to help eliminate the data redundancies found
in the file shown below?
UNC CODE JOB_CHO HOUR PROJ HOURS EM PHONE
133 653-234-3245
16.2 653-224-1123
14.3 615-233-6568
19.0.653-234-3254
175 905-554-7012
116615-223 5680
23.4 553-234-1123
19.1615-233-5432
207 615-878-6679
PROJUNUM PROJ NAME EMP NUM,
1 Huricane
1 Hunicane
1 Humicane
BMP NAME
101 JOh D Newson
105 David F. Schwann CT
EE
85 DO
E0.00
60.00
110 Ave R. Romeras
EE
CT
101 John D. Newwoon
05.00
2 Cuast
2 Coast
3 Satelite
3 Sotelite
108 June H Sottieme
EE
65.00
62.00
26.00
110 Anne R. Renoras
cr
105 David F Schwern CT
55.00
123 Mary D Chen
112 Alecia R. Smith
EE
3 Satelte
DE
05.00
3 Satelite](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F85f60b40-dc9a-44bc-a826-469757a69b39%2F790d0c84-4b51-4b73-b11b-aa9299391f28%2Ft1y56y8_processed.png&w=3840&q=75)
Transcribed Image Text:7. What new files should you create to help eliminate the data redundancies found
in the file shown below?
UNC CODE JOB_CHO HOUR PROJ HOURS EM PHONE
133 653-234-3245
16.2 653-224-1123
14.3 615-233-6568
19.0.653-234-3254
175 905-554-7012
116615-223 5680
23.4 553-234-1123
19.1615-233-5432
207 615-878-6679
PROJUNUM PROJ NAME EMP NUM,
1 Huricane
1 Hunicane
1 Humicane
BMP NAME
101 JOh D Newson
105 David F. Schwann CT
EE
85 DO
E0.00
60.00
110 Ave R. Romeras
EE
CT
101 John D. Newwoon
05.00
2 Cuast
2 Coast
3 Satelite
3 Sotelite
108 June H Sottieme
EE
65.00
62.00
26.00
110 Anne R. Renoras
cr
105 David F Schwern CT
55.00
123 Mary D Chen
112 Alecia R. Smith
EE
3 Satelte
DE
05.00
3 Satelite
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education