In the example shown in figures the 2NF customer table was converted to two 3NF tables. Verify
Question:
Transcribed Image Text:
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
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 70% (10 reviews)
In the record shown in figures the four problems have been eliminated as follows the creation of a n...View the full answer
Answered By
Loise Ndungu
I have five years of experience as a writer. As I embark on writing your papers from the prologue to the epilogue, my enthusiasm is driven by the importance of producing a quality product. I put premium product delivery as my top priority, as this is what my clients are seeking and what makes me different from other writers. My goal is to craft a masterpiece each time I embark on a freelance work task! I'm a freelance writer who provides his customers with outstanding and remarkable custom writings on various subjects. Let's work together for perfect grades.
4.90+
78+ Reviews
224+ Question Solved
Related Book For
Systems Analysis and Design
ISBN: 978-1133274636
9th Edition
Authors: Shelly Cashman, Gary B. Shelly and Harry J. Rosenblatt
Question Posted:
Students also viewed these Managerial Accounting questions
-
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),...
-
The accompanying data were read from graphs that appeared in the article Bush Timber Proposal Runs Counter to the Record (San Luis Obispo Tribune, September 22, 2002). The variables shown are the...
-
Two items are omitted from each of the following three lists of cost of goods sold data from a manufacturing company income statement. Determine the amounts of the missing items, identifying them by...
-
What type of exploratory research design (observation, projective technique, in-depth interview, focus group, case study, ethnography, netnography, ZMET) would you suggest for each of the following...
-
A publisher finds that the mean number of grammatical errors per page of a book is six. Find the probability that the number of grammatical errors found on any given page is (a) exactly four, (b) at...
-
Secondary data have been called the first line of attack for business researchers. Discuss this description.
-
Do you think that it would be more difficult to lead a non-profit group of employees versus a traditional organization? Why and why not? What type of leadership styles, skills, and qualities are...
-
An company has sales of $50 million growing at 25% YoY with EBITDA margins at 20%. It secures a JV in Year 3 with additional business of $20 million at EBITDA of 12.5% which linearly scales up to $50...
-
Consider an automobile dealership with three locations. Data fields exist for stock number, vehicle identification number, make, model, year, color, and invoice cost. Identify the possible candidate...
-
Search the Internet to find information about data storage formats. Also do research on international date formats. Determine whether the date format used in the United States is the most common...
-
As the new controller, reply to the following comment made by your plant manager: When I install a proper accounting software, which can process all my daily accounting records and provide me with...
-
Note: You may make necessary assumptions to solve the problem, but they must be clearly stated. Question 2 Jamie and Alex, a married couple, have been operating their food truck, Silver Spoon...
-
1. Is it customary for a company like HCP to hold quarterly review meetings without having representation from its contractor, SoftSmart? 2. Can project status be determined without the use of...
-
Much Meat Processing Corporation is a major processor of pork, and must determine whether to sell pork chops with the bone in or to process them further into pork tenderloin and porkloin. Management...
-
The HIT Innovation Steering Committee of a large, integrated healthcare system is in the process of examining the potential impact for new emerging technologies. The Committee is aware that HIT is...
-
Assume that everyone in America has finally agreed that we must have universal health care in the United States within the next 3 years. You have been appointed by the U.S Department of Health and...
-
What are the essential requirements of a lease?
-
Vectors are drawn from the center of a regular n-sided polygon in the plane to the vertices of the polygon. Show that the sum of the vectors is zero.
-
Consider a stack that is implemented as a linked list, as in Section 16.3.1. Describe two different scenarios in which race conditions can corrupt the data structure.
-
List two ways display screens can be kept consistent.
-
Give three ways to facilitate movement between display pages.
-
Give three ways to facilitate movement between display pages.
-
You are planning to retire in 30 years. You want to be able to spend $40,000 per year in retirement, adjusted for inflation (so you will spend the equivalent in each year of $40,000 in today's...
-
From a lawsuit, you have been awarded a 31-payment, constant growth annuity. The first payment is at Year O and is equal to $380, and each subsequent payment will be paid in 16 month intervals, with...
-
You will receive 13 payments of $535, where the first payment will be received today (Month 0) and all other payments will be received in 10-month intervals (Months 10, 20, 30 ... 120). Assume that...
Study smarter with the SolutionInn App