Question: In the example shown in figures the 2NF customer table was converted to two 3NF tables. Verify that the four potential problems identified for 2NF

In the example shown in figures the 2NF customer table was converted to two 3NF tables. Verify that the four potential problems identified for 2NF tables were eliminated in the 3NF design.

in 2NF, the nonkev field SALES-REP-NAME is functionally dependent on another nonkey field SALES-REP-NUM CUSTOMER IN 2NF CUSTOMER- CUSTOMER- SALES-REP- SALES-REP- RECORD# NAME ADDRESS NUM NAME 108 233 254 431 779 800 Benedict, Louise Coreli, Helen Gomez, J.P. Lee, M. Paulski, DianeLead, SD Zuider, Z. San Diego, CA Nashua, NH Butte, MT Snow Camp, NC Kaplan, James McBride, Jon Stein, Ellen Roman, Harold Stein, Ellen Roman, Harold 41 2 38 74 38 74 Greer, SC CUSTOMER IN 3NF SALES-REP- NUM CUSTOMER- CUSTOMER- RECORD# NUM NAME ADDRESS 41 108 233 254 431 779 800 Benedict, Louise San Diego, CA Corelli, HelenNashua, NH Gomez, JP. Lee, M. Paulski, Diane Lead, SD Zuider, Z. Butte, MT Snow Camp, NC 4 74 Greer, SC 74 in 3NF, no nonkey field is dependent on another nonkey field SALES-REP IN 3NF SALES-REP SALES-REP- RECORD# NUM NAME McBride, Jon Stein, Elen Kaplan, James Roman, Harold 2 41 74

Step by Step Solution

★★★★★

3.41 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

In the record shown in figures the four problems have been eliminated as follows the creation of a n... 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)

200-B-M-A-C-S-D (486).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!

Figure 3.33 shows a manometer being used to indicate the difference in pressure between two points in a pipe. Calculate (p A - p B ). Oil (sg = 0.90) 3 ft 2'ft 6 ft Water

Four types of adjusting entries were identified in this chapter: Type I............Converting Assets to Expenses Type II..........Converting Liabilities to Revenue Type III...........Accruing Unpaid...

Two feedback systems are shown in Figures P4.12(a) and (b). (a) Evaluate the closed-loop transfer functions T1 and T2 for each system. (b) Compare the sensitivities of the two systems with respect to...

In Example 9.2.15 it was shown that a confidence interval for a Poisson parameter can be expressed in terms of chi squared cutoff points. Use a similar technique to show that if X ~ binomial(n, p),...

In the example shown in Figures 9-25 and 9-26 on pages 411 and 412, the 2NF customer table was converted to two 3NF tables. Verify that the four potential problems identified for 2NF tables were...

THIS IS A COMPANY I AM WORKING ON FOR BUSINESS POLICIES AND NEED HELP GETTING STARTED ESPECIALLY WITH THE EXCEL SPREADSHEET PART!!! THANK YOU!!! TAKE YOUR TIME IF YOU MUST I WANT TO BE ABLE TO...

Standard Cost and Variance Analysis ACC/400 Version 2 University of Phoenix Material Standard Cost and Variance Analysis Complete this matrix by providing at least 2 reasons why you agree and 2...

As in most areas of life and work, advances in information technology have focused attention on the importance of good information systems to support logistics and distribution activities. The...

Standard Cost and Variance Analysis Complete this matrix by providing reasons why you agree and disagree with each of the following author?s statements (shown on page 17 of the ?Standard Cost and...

Provide at least 2 reasons why you agree and 2 reasons why you disagree with the following author?s statements (shown on page 17 of the article). Support your arguments with at least 125 words for...

Fun Stay Express operates a 100-room hotel near a busy amusement park. During June, a 30-day month, Fun Stay Express experienced a 65% occupancy rate from Monday evening through Thursday evening...

The company "Chicks say", orders chicks from the central hatchery of the company "Pio, Pio, Pio". Every day of the 360 days of the year, 22 and a half dozen chicks are requested. It costs 40 CU to...

True or False 1 point Cycle counting can remove the need for full wall - to - wall counts and should be included in labor planning: True False

Essay 1. Explain capital budgeting? 2. Explain the cost of capital? 3. What is the method of calculation of the time value of money? 4. Explain why studying working capital management is so important...

What is the main idea of this document? I want a short response that is a couple of sentences Document C: Works Progress Administration (WPA) FDR believed that the U.S. Government should take an...

What is the main idea of this document? I want a short response that is a couple of sentences Document D: Agricultural Adjustment Administration (AAA) The crisis of overproduction was perhaps nowhere...

Discuss your research findings. Be sure to explain how the trend that you view as an opportunity might enable the organization to generate revenue by means of human capital management and HRs role in...

This is based on a book called "Song Of Solomon" by Toni Morrison. Milkman and Guitar are two characters in the novel.

Local news. The mayor of a small city has suggested that the state locate a new prison there, arguing that the construction project and resulting jobs will be good for the local economy. A total of...

Design a Web-based screen that will allow Maverick Transport customers to track the progress of a shipment. Brainstorm with team members for a list of elements, or perform an interview with a local...

What are the design objectives for paper input forms, input screens, or Web-based fill-in forms?

B. Fine the chi - square test statistic round to two decimal places as needed. C. Determine the P value round to three decimal places as needed.D. The P value is _____ x=5 so _____ Ho.E. There is...

Help me please. Am stuck. The events that lead to potential claims on a policy arise as a Poisson process at a rate of 0.8 per year. However the policy is limited such that only the fust luce claims...

In a certain lottery, you must choose three numbers: any number between 1 and 10; any number between 1 and 20; and any number between 1 and 30. Numbers may repeat and order matters (e.g., 5-5-5 is...