Question: ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////Use the database provided to answer the following questions... PROJ NUM PROJ NAME EMP NUM EMP_NA ME JOB_CODE JOB_ CHG_ HOUR PROJ HOURS EMP_PHONE 1

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////Use the database provided to answer the following questions...

PROJ NUM PROJ NAME EMP NUM EMP_NA ME JOB_CODE JOB_ CHG_ HOUR PROJ HOURS EMP_PHONE 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 101 John D Newson 105 David F $85.00 $60.00 $60.00 $85.00 $85.00 $62.00 $26.00 $85.00 $85.00 13 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 CT Schwann 110 Anne PR. CT Ramoras 101 John D. Newson 108 June H. EE Sattlemeir 2Coast 3 Satellite 110 Anne R. CT Ramoras 3 Satellite 105 David F CT Schwann 3 Satellite 123 Mary D. Chen 3 Satellite 112 Allecia R. BE Smith 15. Why is the above database a poor design? Give specific reasons and examples 16. Would you recommend any changes to the EMP_NAME and EMP PHONE attributes? Why or why not? 17. Redesign the database with additional tables to fix the design problems

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

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

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

1. 2. 3. What is the difference between a database and a DBMS? What is the motivation for modern database systems? What is a DBMS, and what are its functions? Given the file structure shown in Figure...

1. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5. FIGURE P1.5 The File Structure for Problems 5-8 PROJ NUM PROJ NAME EMP NUM 1...

Given the file structure shown in Figure P1.1, answer Problems 1-4. Figure P1.1 The File Structure for Problems 1-4 PROJECT_CODE 21-5Z Holly B. Parker 25-2D Jane D. Grant 25-5A George F. Dorts 25-9T...

The assignments are Problems 1 . 6 on page 3 3 and 2 . 9 on page 6 4 , Review Questions 3 . 1 0 on pages 1 0 3 - 1 0 4 , and 4 . 2 on page 1 5 1 of the textbook ( Chapters 1 - 4 ) . For your...

1 . 6 ( Data redundancy ) Looking at the Emp _ Name and Emp _ Phone contents in the following figure, what change ( s ) would you recommend? The File Structure Proj _ Num Proj _ Name Emp _ Num Emp _...

DATABASE Given the structure and contents of the StartAPPCo database above, answer the following questions. 1. Given the information above, create the StartAPPCo database. (5 marks) 2. Write SQL code...

Please Answer the following questions Customer_ID Name Salesperson Region 8023 Anderson Smith South 9167 Bancroft Hicks West 7924 Hobbs Smith South 6837 Tucker Hernandez East 8596 Eckersley Hicks...

please answer the following questions Order_ID Order_Date Product_ID Product_Desc Unit-Price. Quantity OD100 09/08/2000 E34T098 Coffee Table $175.00 2 OD100 09/08/2000 N78S571 Nightstand $150.00 3...

This is as clear as the pictures can be. I HAVE COPY & PASTED THE QUESTIONS. Please help with as many as you can and correct answers please! The Ch08_ConstructCo database stores data for a consulting...

Task 18 (100 points. Given the structure of the ConstructCo database shown above, use SQL commands to answer the problems in the following steps. 1. Write the SQL code required to list the employee...

Mr. Sharp, the Finance Manager of Bright Limited tabled the following statements for the consideration of the Director Finance Mr. F for the first quarter of the year. INCOME STATEMENT Sales revenue...

(a) The Horner Pie Company pays a quarterly dividend of $1. Suppose that the stock price is expected to fall on the ex-dividend date by $.90. Would you prefer to buy on the with-dividend date or the...

1. The word that is central to the defi nition of economics is . ( LO1 ) a) resource c) scarcity b) wants d) capital

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

KEY QUESTION What is the basic determinant of ( a ) the transactions demand and ( b ) the asset demand for money? Explain how these two demands can be combined graphically to determine total money...

KEY QUESTION Assume that the following data characterize a hypothetical economy: money supply $200 billion; quantity of money demanded for transactions $150 billion; quantity of money demanded as...

Suppose that the Federal funds rate is 4 percent and real GDP falls 2 percent below potential GDP. Acording to the Taylor rule, in what direction and by how much should the Fed change the Federal...