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?

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter7: Developing An Excel Application

Section: Chapter Questions

Problem 3RA

See similar textbooks

Similar questions

Sample input file: (Assume all names and IDs in the list are unique and must stay unique.) Introduction to Computer Programming Fundamentals CSCI 1 MBA 315 John Adams 111223333 100 87 93 90 90 89 91 Willy Smith Jr. 222114444 90 73 67 77 70 80 90 Phil Jordan 777886666 100 80 70 50 -60 90 100 Sample output file format: (Final report) Course Name: Introduction to Computer Programming Fundamentals Course ID: CSCI 1 Class Location: MBA 315 Name ID Average Grade Adams, John 111-22-3333 91.5 A Smith Jr., Willy 222-11-4444 87.0 B Jordan, Phil 777-88-6666 -1 I Student list print format to the monitor: Name Average Grade Adams, John 91.5 A Smith Jr., Will 87.0 B Jordan, Phil -1 I Student's detail format to the monitor: Name: Adams, John ID: 111223333 Quiz Score: 100.00 Test Scores: 87.00 93.00 90.00 90.00 89.00 91.00 Average: 91.54 Letter Grade: A Error messagesBad file name: Failed to open file.File with no data: Empty file.Adding student Error Adams is on the list, duplicated names are not…
File read write and string manipulation data1.txt(down below) 4,5-t 2,4-d 20-p7int 2D 2nd 2 1080 &c 10-p7int 10th 11-p7int 12-p7int 16-p7int 18-p7int 1st 2,4,5-t 2,4-d 20-p7int 2D 2nd 30-30 3D 3-D 3M 3rd 48-p7int 4-D 4GL 4H 4th 5-p7int 5-T 5th 6-p7int 6th 7-p7int 7th 8-p7int 8th 9-p7int 9th @ @' @- @&M @&P @. @.@.@. @.B. @.B.@. @.C. @.D. @.D.C. @.F. @.F.@.M. @.G. @.H. @.I. @.I.@. @.I.D. @.L. @.L.P. @.M. @.M.@. @.M.D.G. @.N. @.p. @.r. @.R.C.S. @.U. @.U.C. @.V. @.w. @.W.O.L. @/C @/F j54rs54y54d J54rs54yit54 j54rs54yit54s J54rs54ym@n j54rs54ys j54rs54y's J54rs54yvill54 j54rt J54rubb@@l J54rubb@l J54rus@l54m J54rus@l54mit54 j54rvi@ j54rvin j54rvin@ j54rvin54 J54rvis J54rk J54S J54sh J54sh54r J54smin54 j54sp54r J54sp54rs54n J54ss J54ss@ J54ss@b54ll j54ss@k5454d J54ss@lin J54ss@lyn j54ss@my j54ss@mi54s J54ss@myn J54ss@min54 j54ss@nt J54ss54 J54ss54@n j54ss54d J54ss5454 J54ss54y J54ss54lyn J54ss54lt7n J54ss54n j54ss54s J54ssi J54ssy J54ssic@ J54ssi54 kikkl54 kikkl54d kikkl54s…
BASE SAS PROGRAMMING Question 12:- When a SAS data set is created from a spreadsheet, the spreadsheet column headings are always stored as which of the following? a) variable names b) labels c) formats d) descriptor Question 13:- In SAS, one can test single or joint hypothesis after successful completion of a) Data portion b) First observation c) Descriptor portion d) PDV Question 14:- The following SAS program is submitted: data work.products; Product_Number = 5461; Item = `1001`; Item_Reference = Item`/`Product_Number; run; Which one of the following is the value of the variable ITEM_REFERENCE in the output data set? a) 1111/1502 b) 1001/ 5461 c) (missing numeric value) d) The value can not be…
The chr21_genes.txt file lists genes from human chromosome 21, in their order along the chromosome, as described in Hattori et al. (Nature 405, 311-319) (Links to an external site.). For each gene, the file gives the gene symbol, description and category. The fields are separated by tabs. You will need to get the the meaning of each category. You can find these meanings in the original paper (Links to an external site.), under the "Gene categories" section. Create a file named chr21_genes_categories.txt that store this information in tab separated fields:
Python Programming Problem: Simple Soccer Point TableThe programmer will design a simple point table lookup and update application. The table contains some basic information: team_name, match_played, win, draw, loss, point and rank. Design Solution:1. English Premier League is a prestigious soccer league. Here is the result of its one session. Man. City|38|32|2|4|98|1Liverpool|38|30|7|1|97|2Chelsea|38|21|9|8|72|3Tottenham|38|23|2|13|71|4Arsenal|38|21|7|10|70|5 2. Hypothetically, you have been assigned to design a simple lookup software for prestigious ‘English Premier League’ from a given point table. The point table contains team_name, match_played,win, draw, loss, points and rank. 3. The input file, ‘previous_result.txt’ has been provided to you above the top 5 teams in 2018-19 session. Your software needs to be able to search and update the point table based on user input. For example: The first time Chelsea played 38, the second time it changed (based on user input) to 40 and so…
Code for the following: Web application is written using the MVC (Model, View, Controller) architecture Web application is written using object-oriented PHP programming, including classes for: Database Connection & Information Products table model Products table DB Products table controller Categories table model Categories table DB Categories table controller Web application includes 3 user interface pages: Index/landing/navigation page Title: "Your Name Wk 3 GP" Page Header: Your Name Product Information Includes navigation links to all other pages Filename index.php Database Connection Status page Title: "Your Name Wk 3 GP" Page Header: Your Name Database Status Includes: Text display of the database name Text display of the database user ID Text display of the database password Text display of the status of the connection (successful or unsuccessful) Navigation link to the home page Filename db_conn_status.php Products page (and Product Add/Update page) Title: "Your Name Wk 3…
I need help debugging this. // Cooper College maintains a master file of students and credits // earned. Each semester the master is updated with a transaction // file that contains credits earned during the semester. // Each file is sorted in Student ID number order. start Declarations num masterID string masterName num masterCredits num transID num transCredits string bothDone = "N" num HIGH_VALUE = 999999 InputFile master InputFile trans OutputFile newMaster getReady() while bothDone = "N" detailLoop() endwhile allDone() stop getReady() open master "studentFile.dat" open trans "semesterCredits.dat" open newMaster "updatedStudentFile.dat" readMaster() readTrans() checkBoth() return readMaster() input masterID, masterName, masterCredits from master if eof then masterID = HIGH_VALUE endif return readTrans() input transID, transCredits from trans if eof then…
Computer Science Write an XML DTD which will define the following structure for documents of type exam. An test has a course code, a title and a date, which comprises only the month and year. These are followed by a list of questions. tests consist of either 5 or 6 questions. Each question has one or more part s. Parts of questions can themselves comprise parts along with text. Give an instance of an test document which is valid with respect to your DTD and two instances which are invalid, explaining why they are invalid. Check your answers using an on-line XML validator
; initialized data heresection .data msg db "Print String!", 0xamsglen equ $-msg ; string length in bytesSTDOUT equ 1 ; standard output deviceSYS_write equ 1 ; write messageSYS_exit equ 60 ; exit programEXIT_OK equ 0 ; return value ; code goes heresection .text ; The '_start' label identifies the program's entry point for the; linker for the 'nasm' assembler. If you use 'gcc', the entry point; is labeled 'main'global _start_start: ; send message string to standard output mov rsi, msg ; text address mov rdx, msgln ; string length (error here) mov rdi, STDOUT ; output device mov rax, SYS_write ; rax holds the function syscall ; system…
what's wrong with the following SAS code: proc format; value fcsex 1 = 'Female'; 2 = 'Male'; value fdliv 1 = '1st Born'; 2 = '2nd Born'; 3 = '3rd Born'; 4 = '4th Born'; 5 = '5th+ Born'; run; data HW.two; set HW.main; label csex = "Gender"; dlivord = "Child Birth Order"; format csex fcsex dlivord fdliv; run;
BASE SAS PROGRAMMING Question 1:- Which one of the following SAS DATA steps saves the temporary data set named HADOOPDATA as a permanent data set? a) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; copy hadoopdata; run; b) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; keep hadoopdata; run; c) libname sasdata `SAS-data-library`; data sasdata.hadoopdata; save hadoopdata; run; d) libname sasdata `SAS-data-library`;data sasdata.hadoopdata; set hadoopdata; run; Question 2:- The data set orion.sales contains nine variables. Given this DATA step, how many variables does the descriptor portion of work.comp contain? data work.comp; set orion.sales; drop Gender Salary Birth_Date; run; a) Four b) Six c) Eight d) Nine Question 3:- Which one of the following…
RosterGrades=readtable('RosterScores.txt'); RosterGrades.Grades=cell([size(RosterGrades,1),1]); for i=1:size(RosterGrades,1) if RosterGrades.Scores(i)>=90 RosterGrades.Grades{i}='A'; elseif RosterGrades.Scores(i)>=80 RosterGrades.Grades{i}='B'; elseif RosterGrades.Scores(i)>=70 RosterGrades.Grades{i}='C'; elseif RosterGrades.Scores(i)>=60 RosterGrades.Grades{i}='D'; else RosterGrades.Grades{i}='F'; end end RosterGrades writetable(RosterGrades,'RosterScores.txt')