Question: 1. What data redundancies do you detect? How could those redundancies lead to anomalies? Give an example? 2. Identify and discuss the serious data

FIGURE P1.1 The File Structure for Problems 1-4 FIGURE P1.1 THE FILE STRUCTURE FOR PROBLEMS 1-4 PROJECT BD

FIGURE P1.9 THE FILE STRUCTURE FOR PROBLEMS 9-10 BUILDING CODE ROOM CODE TEACHER UNAME TEACHER FNAME TEACHER

1. What data redundancies do you detect? How could those redundancies lead to anomalies? Give an example? 2. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.1. FIGURE P1.1 The File Structure for Problems 1-4 FIGURE P1.1 THE FILE STRUCTURE FOR PROBLEMS 1-4 PROJECT BD PRICE 16833460.00 12500000.00 32512420.00 PROJECT CODE PROJECT MANAGER Holly B Parker Jane D. Grant MANAGER PHONE MANAGER ADDRESS George F. Dorts Holly B. Parker George F. Dorts Holly B Parker William K. Moor 904-338-3416 615-098-9909 615-227-1245 904-338-3416 615-227-1245 904-338-3416 904-445-2719 3334 Lee Rd, Gainesville, FL 37123 218 Clark Blvd, Nashville, TN 36362 124 River Dr. Franklin, IN 29105 3334 Lee Rd, Gainesville, FL 37123 124 River Dr., Frankdin, TN 29185 3334 Lee Rd, Gainesville, FL 37123 216 Morton Rd, Stetson, FL 30156 Given the file structure shown in Figure P1.1, answer Problems 1-4. 21-52 25-20 25-5A 25-91 27-40 29-20 31-7P 21563234 00 10314545.00 25559999.00 56850000.00 FIGURE P1.9 THE FILE STRUCTURE FOR PROBLEMS 9-10 BUILDING CODE ROOM CODE TEACHER UNAME TEACHER FNAME TEACHER INITIAL 204E Horace 123 Maria 504 Donald 34 Anne Janes Jeanette Maria Horace Maria Donald KOM KOM LDB KOM JKP LDB LDB KOM LDB 2258 301 204E 504 34 504 Williston Cordoza Patroski Hawkins Risell Robertson Cordoza Williston Cordoza Patrosk G - L 3 W P 1 0 L J DAYS TIME MAF 8:00-8:50 MMF 8,00-8:50 7Th 1:00-215 MAF 10.00-10:50 TTh 9:00-10-15 TTh 9:00-10:15 MAF 9:00-9.50 1Th 1:00-215 MMF 11:00-11:50 MAF 200-250 1. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure P1.9. (The file is meant to be used as a teacher class assignment schedule. One of the many problems with data redundancy is the likely occurrence of data inconsistencies that two different initials have been entered for the teacher named Maria Cordoza.) 2. Given the file structure shown in Figure P1.9, what problem(s) might you encounter if building KOM were deleted?

Step by Step Solution

★★★★★

3.52 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

part 1 The file structure shown in Figure P11 exhibits the following data redundancies Project manager The project manager name and contact information is stored for each project even though the same ... 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

Students Have Also Explored These Related Computer Network Questions!

Ben and Joel are raising money for their class trip by selling wrapping paper. Ben raised $43.50 by selling 12 rolls of solid paper and 9 rolls of printed paper. Joel raised $51.50 by selling 8 rolls...

how would you alter the table structure? What data redundancies do you detect? Give example of how could those redundancies lead to data anomalies? How many records does the table contain? How many...

Identify and discuss the serious data redundancy problems exhibited by the file structure shown inFigure. PROJ NUM PROJ NAME EMP NUMEMP NAME JOB CODE JOB_ CHG HOUR PROJ HOURS EMP PHONE 1 Hurricane 1...

According to Kurt Lewin, why is it so difficult to motivate employees to alter their patterns of behavior?

A - particle moving with 220 MeV of kinetic energy decays according to - - + n. Calculate the total kinetic energy of the decay products.

Adamson Company manufactures four lines of garden tools. As a result of an activity analysis, the accounting department has identified eight activity cost pools. Each of the product lines is produced...

2.65 Polluted Seawater? Petroleum pollution in seas and oceans stimulates the growth of some types of bacteria. A count of petroleumlytic micro-organisms (bacteria per 100 millilitres) in ten...

Jones Petro Company reports the following consolidated statement of income: Operating revenues ....................$2,989 Costs and expenses: Cost of rentals and royalties ................ 543 Cost...

Montgomery Corporation In January, the board of directors of the Montgomery Corporation, one of Canada's largest retail store chains, was having its regularly scheduled meeting to establish and...

Paper purchased 12,000 of Sands 30,000 shares on 10/1/20X0 for $36,000. At 1/1/20X0, Sand had Common Stock of $30,000 and Retained Earnings of $50,000. During the 12 months ended 12/31/20X0, Sand...

Please solve the following problem by completing the blanks using the provided images. Problem 15-4A (Part Level Submission) Agassi Company uses a job order cost system in each of its three...

Do you feel that your organization utilizes your uniqueness to its full capability?

You have been appointed to manage a project that requires the construction of a three bedroom house (in an area of your choice). the information that you have received includes: Budget - R2.5 Million...

Answer the following: a. What is the role of safety inventory? What are the risks of not having safety inventory? Explain thoroughly. b. If the quality of goods provided by suppliers is identical,...

All problems must be formatted correctly in the report to obtain full points. Code must be well commented on and sectioned. Any information missing from the report or the simple act of typing out...

Give a specific example of how corporate aviation has helped a company or organization. (See the Learn section for links concerning corporate flight departments). Consider businesses or even how...

What will drones without built - in broadcast capabilities need to do to comply with Remote ID provisions?

Give the structural formulas of the alkenes that, on ozonolysis, give: a. (CH3)2C=O and CH2=O b. Only (CH3CH2)2C=O c. CH3CH=O and CH3CH2CH=O d. O=CHCH2CH2CH2CH=O

What are the three types of database critical events that can trigger the database recovery process? Give some examples for each one.

What are homonyms and synonyms, and why should they be avoided in database design?

Create the relational diagram for this database.

Design specification for a motor housing states that it should weigh between 24 and 25 kgs. The process that produces the housing yields a mean of 24.5 kg and a standard deviation of .2 kg. The...

Refer to Solved Problem 2. Suppose that the design specification is between 9.65 and 10.35 minutes. Based on the data given in the Solved Problem 2, does it appear that the design specification is...

A technician in a quick oil change shop had the following service rimes (in minutes) for 20 randomly selected cars: a. Determine the mean of each sample. b. Estimate the mean and standard deviation...