Question: Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown inFigure? PROJ

Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown inFigure?

PROJ NUM PROJ NAME EMP NUMP NAME JBCODEOB CHO HOUR [PROJ HOURS EMP PHONE 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite 3 Satellite 101 John D. Newson EE 105 David F. Schwann CT 110 Anne R. Ramoras CT 101 John D. Newson EE 108 June H. Sattlemeir EE 110 Anne R. Ramoras CT 105 David F. Schwann CT 123 Mary D. Chn EE 112 Allecia R. Smith BE 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 11.6 615-233-5568 23.4 653-234-1123 19.1 615-233-5432 20.7 615-678-6879 62.00

Step by Step Solution

★★★★★

3.45 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The data sources are probably the PROJECT EMPLOYEE JOB and CHA... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

358-CS-DB (491).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Given your answer to Problem 17, what effect would you expect an announcement of a share repurchase to have on the stock price? Why?

Given your answer to Question 32, fit a different Poisson log- linear model to the CTR data that you believe may more accurately reflect the relationship between cancer incidence rates and age. The...

Ethel is a retired 75-year-old who has K5, 000, 000 after selling her small business and paying taxes on the sale. She wants to invest this money. Ethel would like the capital to rise faster than...

Partial-year depreciation Equipment acquired at a cost of $109,000 has an estimated residual value of $7,000 and an estimated useful life of 10 years. It was placed in service on April 1 of the...

for my itec class Chapter 1 Database Syste FIGURE P1.5 THE FILE STRUCTURE FOR PROBLEMS 5-8 HEM 101 110 41016233.59 14 75 18 25 151 115-1335 2017 2000 2 6. Looking at the EMP_NAME and EMP_PHONE...

Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5. Looking at the EMP_NAME and EMP_PHONE contents in Figure P1.5, what change(s) would you...

Looking at the EMP _ NAME and EMP _ PHONE contents in Figure P 1 . 5 , what change ( s ) would you recommend? Identify the various data sources in the file you examined in Problem 5 . Given your...

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 P 1 . 5 ?

Assume you are the human resource manager of a small seafood company. The general manager has told you that customers have begun complaining about the quality of your company's fresh fish. Currently,...

FIGURE 2 The File Structure for Problems 4-6 PROJ_NUM PROJ_NAME EMP_NUM EMP NAME JOB_CODE JOB_CHG_HOUR PROJ_HOURS EMP_PHONE 1 Hurricane 101 John D. Newson EE 85.00 13.3 653-234-3245 1 Hurricane 105...

The following annual account balances are from Armour Sports at December 31. Year 2 Year 1 $ 35,505 $ 38,608 479,318 Accounts receivable Net sales 498,758 Complete the below table to calculate the...

The analysis of shafts for a compressor is summarized by conformance to specifications:

7 - 2 5 ( Objectives 7 - 8 , 7 - 9 ) The following questions concern audit documentation. Choose the best response. 1 . Which of the following is not a primary purpose of audit documentation? 1 . To...

A scientific journal, in an attempt to maintain experimental standards, insists that all reported statistical results have (classical) error probability of ao (or better). To consider a very simple...

What indexes would you recommend for the query you wrote in Problem 30, and what SQL commands would you use?

What is the objective of the query optimization functions?

What issues should be considered when resolving data requests in a distributed environment?

At expiry of a 7-year 2% Payer swaption on $100mln, with 6-mo LIBOR as the floating rate leg, the actual (prevailing) 7-yr swap rate is 2.80% and the yield curve is flat. What is the intrinsic value...

Discuss and explain the difference between procedural and object oriented programming languages.

1 V 2 v 3 4 5 6 8 9 10 11 12 13 14 Motor Vehicle Accidents During a recent year, there were 12.2 million automobile accidents, 6.8 million truck accidents, and 172,000 motorcycle accidents. Find the...