Answer and explain if possible. FIGURE P1.5 The File StructurePROJ_NUM PROJ_NAME EMP NUM1 Hurricane1 Hurrlcane1 Hurricane2 Coast2 Coast3 Satellite3 Satellite3 Satelite3 SatelliteEMP NAMEJOB CODE JOB_CHG HOUR PROJ HOURS EMP PHONE13,3 653-234-324516.2 653-234-112314.3 615-233-556819.8 653-234-325417.5 905-554-781211.6 615-233-556823.4 653-234-1123101 John D. NewsonEE105 David F. Schwann CT110 Anne R. Ramoras85.0060.00CT101 John D. Newson60.00EE108 June H. Sattlemelr85.00EE110 Anne R. Ramoras105 David F. Schwann CT85.0062.0026.0085.0085.00CT123 Mary D. Chen112 Allecia R. SmithEE19.1 615-233-5432BE20.7 615-678-68795. Identify and discuss the serious data redundancy problems exhibited by the file structureshown in Figure P1.5.6. Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) wouldyou recommend?7. Identify the various data sources in the file you examined in Problem 5.8. Given your answer to Problem 7, what new files should you create to help eliminate thedata redundancies found in the file shown in Figure P1.5?

Given table contains 8 columns that are Proj_num, Proj_name, Emp_num, Emp_name, Job_code,…

FIGURE P1.5 The File Structure PROJ_NUM PROJ_NAME EMP NUM 1 Hurricane 1 Hurricane JOB CODE JOB_CHG HOUR PROJ HOURS EMP PHONE 13.3 653-234-3245 16.2 653-234-1123 14.3 615-233-5568 19.8 653-234-3254 17.5 905-554-7812 EMP_NAME 101 John D. Newson EE 105 David F. Schwann CT 110 Anne R. Ramoras 101 John D. Newson 85.00 60.00 60.00 1 Hurricane CT 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite EE 85.00 108 June H. Sattlemelr EE 85.00 110 Anne Ramoras 105 David F. Schwann CT 123 Mary D. Chen 112 Allecia R. Smith 11.6 615-233-5568 23.4 653-234-1123 19.1 615-233-5432 20.7 615-678-6879 CT 62.00 26.00 EE 85.00 85.00 3 Satellite BE 5. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5. 6. Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you recommend? 7. Identify the various data sources in the file you examined in Problem 5. 8. Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?

FIGURE P1.5 The File Structure PROJ_NUM PROJ_NAME EMP NUM 1 Hurricane 1 Hurricane JOB CODE JOB_CHG HOUR PROJ HOURS EMP PHONE 13.3 653-234-3245 16.2 653-234-1123 14.3 615-233-5568 19.8 653-234-3254 17.5 905-554-7812 EMP_NAME 101 John D. Newson EE 105 David F. Schwann CT 110 Anne R. Ramoras 101 John D. Newson 85.00 60.00 60.00 1 Hurricane CT 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite EE 85.00 108 June H. Sattlemelr EE 85.00 110 Anne Ramoras 105 David F. Schwann CT 123 Mary D. Chen 112 Allecia R. Smith 11.6 615-233-5568 23.4 653-234-1123 19.1 615-233-5432 20.7 615-678-6879 CT 62.00 26.00 EE 85.00 85.00 3 Satellite BE 5. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5. 6. Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you recommend? 7. Identify the various data sources in the file you examined in Problem 5. 8. Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5?

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

Similar questions

Define the terms "DBMS" (Database Management System) and "RDBMS" (Relational Database Management System). Explain why relational databases are widely used.
Computer Science Case Study You are the programmer at a recreation center. This recreation center has a database that tracks classes, enrollment, cancellation, revenues, and expenses for each program or class. The database also tracks customer demographics. What type of evaluation would you conduct on an annual basis using the available data?
What is information. Explain types of information.
Why is calling and asking questions helpful?
What are a few justifications for dialling up the phone and making inquiries?
What advantages do phone calls provide for getting information?
Explain the implications of plagiarism in technical writing and how to prevent it.
Explain how a repository affects computer system development.
Differentiate between an analytical report and a report with recommendations.
Briefly explain whether you can create your system database or any database and put it in the System Databases folder.