Question: FIGURE P1.5 The File Structure for Problems 4-5 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

FIGURE P1.5 The File Structure for Problems 4-5 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 David F. Schwann CT 60.00 16.2 653-234-1123 1 Hurricane 110 Anne R. Ramoras CT 60.00 14.3 615-233-5568 2 Coast 101 John D. Newson EE 85.00 19.8 653-234-3254 2 Coast 108 June H. Sattlemeir EE 85.00 17.5 905-554-7812 3 Satellite 110 Anne R. Ramoras CT 62.00 11.6 615-233-5568 3 Satelite 105 David F. Schwann CT 26.00 23.4 653-234-1123 3 Satelite 123 Mary D. Chen EE 85.00 19.1 615-233-5432 3 Satelite 112 Allecia R. Smith BE 85.00 20.7 615-678-6879 4. (15 pts) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.5. 5. (15 pts) How would you reorganize the data - i.e., what new files should you create to help eliminate the data redundancies found in the file shown in Figure P1.5? 6. (15 pts) Give an example of each of the three types of relationships (1:1, 1:N, M:N)

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 General Management Questions!

FIGURE P1.5 The File Structure for Problems 4-5 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...

How would you reorganize the data i.e., what new files should you create to help eliminate the data redundancies found in the file? PROJ_NUM PROJ_NAME EMP_NUM EMP_NAME JOB_CODE JOB_CHG_HOUR...

Consider the following table. 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 David F. Schwann...

The following spreadsheet is a sample that is currently being used to track company data. However, employees have been complaining about the amount of maintenance needed to sustain the data. PROJ_NUM...

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...

FIGURE P1.5 The File Structure 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 David F....

Using the database table above: Based on the table above, identify pairs of columns that for the same value in one column, the 2nd column also has the same value. These dependencies lead to what...

I want the answers as three tables (one each for employee, job, and project) and the relationships. please enforce referential integrity. PROJ_NUM PROJNAME JOB_CODE Satelite EE JOB PROJ_HOURS...

PROJ_NUM Y PROJ NAME 1 Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast 3 Satellite 3 Satellite 3 Satelite 3 Satellite EMP_NUM, EMP_NAME JOB_CODE - 101 John D. Newson EE 105 David F. Schwann 110...

Topic 1 Database Systems Tutorial Questions for Week 2-3 1. Discuss each of the following terms: a data b. field C. record d. file 2. What is data redundancy, and which characteristics of the file...

If you were given a sample of a cotton ball and a glass stirring rod with identical mass (ex: 5.0 g), which sample would contain more oxygen atoms?

A stock has a beta of 1.25 and an expected return of 14 percent. A risk-free asset currently earns 2.1 percent. a. What is the expected return on a portfolio that is equally invested in the two...

Current Artiempt in Frogress Marn Corporation incurred the following costs during 2 0 2 2 . \ table [ [ Direct material uned in product,$ 1 2 7 , 2 0 0 , Advertiving expense,$ 4 7 , 7 0 0 ] , [...

dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd Question 17. [1 mark] You are a director of a company which is in liquidation. The liquidator advises...