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
icon
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education