Identify all the fields on the View Identify the unique key to find each instance of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Identify all the fields on the View Identify the unique key to find each instance of the view Order # Date | Shipping | Date | Shipped Prod ID | Desc | Cost | Price | Quantity | Sales ID | Salesperson | Order Inv # Inv VIA 102 11/01/99 10345 11/14/99 Fedex 101 100 11/02/99 10313 11/7/99 UPS 11/06/99 b54 a104 c43 d67 Chair 54.95 104.95 6 Table 145.99 306.95 1 Lamp 13.99 45.95 2 1 Bed 499.00 898.95 FIRST NORMAL FORM Remove repeating groups from the view for each instance of the key- ie for each Order # (the unique key), what fields repeat more than once/twice SECOND NORMAL FORM Remove the partial dependencies you probably just created - ie what non-unique-key fields can you determine uniquely with only part of the key? JS13423 Jill Smith JS13423 Jill Smith LK5432 Lane Kill JS13423 Jill Smith THIRD NORMAL FORM Remove the transitive dependencies that are left- ie what non-unique-key fields can you uniquely determine without knowing any of the key? Identify all the fields on the View Identify the unique key to find each instance of the view Order # Date | Shipping | Date | Shipped Prod ID | Desc | Cost | Price | Quantity | Sales ID | Salesperson | Order Inv # Inv VIA 102 11/01/99 10345 11/14/99 Fedex 101 100 11/02/99 10313 11/7/99 UPS 11/06/99 b54 a104 c43 d67 Chair 54.95 104.95 6 Table 145.99 306.95 1 Lamp 13.99 45.95 2 1 Bed 499.00 898.95 FIRST NORMAL FORM Remove repeating groups from the view for each instance of the key- ie for each Order # (the unique key), what fields repeat more than once/twice SECOND NORMAL FORM Remove the partial dependencies you probably just created - ie what non-unique-key fields can you determine uniquely with only part of the key? JS13423 Jill Smith JS13423 Jill Smith LK5432 Lane Kill JS13423 Jill Smith THIRD NORMAL FORM Remove the transitive dependencies that are left- ie what non-unique-key fields can you uniquely determine without knowing any of the key?
Expert Answer:
Answer rating: 100% (QA)
Identifying the fields on the View Order Date Shipping Da... View the full answer
Related Book For
Auditing A Practical Approach with Data Analytics
ISBN: 978-1119401742
1st edition
Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these programming questions
-
Write the name of process for converting waveform-1 to waveform-2? Explain it [2] briefly in your own words. Waveform-1 Bygg Waveform-2 QNo.11 Perform Phase shift on the below given signal by 225....
-
what does a social psychologist do under stressful situations?
-
Identify all the fields on the View Identify the unique key to find each instance of the view BID NAME ADDR DEPT Status TERM CallIDI ISBNI TITLE1 Publl Pricel Datel DueDatel HoldY/NI CallID2 ISBN2...
-
At the beginning of the year, Anna began a calendar-year business and placed in service the following assets during the year: Asset Date Acquired Cost Basis Computers 1/30 $28,000 Office desks 2/15...
-
What is the baud rate of the standard 10-Mbps Ethernet?
-
Let Ai be the set of all nonempty bit strings (that is, bit strings of length at least one) of length not exceeding i. Find (a) (b) UA
-
The in-plane shear modulus, \(G_{12}\), of a carbon/epoxy lamina is to be measured by using the rail shear test shown in Figure 10.36. The test is conducted on a 10 in. \(\times 10 \mathrm{in} ....
-
The financial statements of Lioi Steel Fabricators are shown below both the actual results for 2010 and the projections for 2011. Free cash flow is expected to grow at a 6% rate after 2011. The...
-
Calculate the heat flow per unit area through the wall of a steel furnace with a thickness of 1 inch when the temperature gradient across the wall is 1 0 degrees F . The thermal conductivity of the...
-
The A-36 steel wires AB and AD each have a diameter of 2 mm and the unloaded lengths of each wire are LAC = 1.60 m and LAB = LAD = 2.00 m. Determine the required diameter of wire AC so that each wire...
-
Compare and contrast a particular sport from the classical Olympics and the modern Olympics. Eg, wrestling. The sport could be the same sport used for the timeline assignment. Alternatively, one can...
-
How is the research of Trompenaars similar to or different from that of Hofstede? How does knowledge of this research help an IHR professional
-
Day-to-day business operations include daily activities carried out by a company's personnel that contribute to the company's overall success and are in line with its objectives. As a warm-up, write...
-
Evaluating the impact of globalization on HR planning. Explain briefly :- NOTE :- 700 -800 Words -:
-
Compare and contrast the punitive approach and restorative approach to justice. What are the benefits and limitations of each approach? What is known about the effectiveness and weaknesses of both...
-
Evaluate and explain briefly how project management interacts with risk management.
-
A 120V, 60Hz, 1/4hp universal motor runs at 2000 rpm and takes 0.6A when connected to a 120V d.c. source. Determine the speed, torque and power factor of the motor when it is connected to a 120V, 60...
-
1. Firms may hold financial assets to earn returns. How the firm would classify financial assets? What treatment will such financial assets get in the financial statements in accordance with US GAAP...
-
What is a time-series analysis? How could it be useful to an auditor?
-
Explain a typical control preventing, or detecting and correcting, payments to a fictitious employee.
-
Assume that a company has numerous hourly employees that it pays every Friday. Explain the transactions expected in this payroll process.
-
A company with a price-earnings ratio of 14 has an earnings yield closest to: A. 7.14% B. 14.00% C. 92.86%
-
Which of the following is not produced by a company to communicate its financial results? A. Schedule 13D. B. Annual report. C. 10-K statement.
-
The role of the 8-K filing with the Securities and Exchange Commission is best described as to disclose: A. the annual report. B. executive compensation. C. holdings of beneficial owners.
Study smarter with the SolutionInn App