a) Given a table below, answer the following questions: EmployeeNo Project # Hours 123456789 32.5 123456789...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
a) Given a table below, answer the following questions: EmployeeNo Project # Hours 123456789 32.5 123456789 7.5 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 1 2 2312 2 2 3 10 20 30 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 EMPLOYEE-PROJECT EmployeeName John Smith John Smith Ramesh Narayan Joyce English Joyce English Franklin Wong Franklin Wong Franklin Wong Franklin Wong Alicia Zelaya ProjectName Major Training Automation Installation Major Training Automation Automation Installation ProjectLocation Hobart Adelaide Melbourne Hobart Adelaide Adelaide Melbourne. Computerization Melbourne Reorganization Newbenefits (i) What is the highest level of normal form for the table? (ii) Describe the insertion, update and delete anomalies that can happen on the table. Albury Perth a) Given a table below, answer the following questions: EmployeeNo Project # Hours 123456789 32.5 123456789 7.5 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 1 2 2312 2 2 3 10 20 30 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 EMPLOYEE-PROJECT EmployeeName John Smith John Smith Ramesh Narayan Joyce English Joyce English Franklin Wong Franklin Wong Franklin Wong Franklin Wong Alicia Zelaya ProjectName Major Training Automation Installation Major Training Automation Automation Installation ProjectLocation Hobart Adelaide Melbourne Hobart Adelaide Adelaide Melbourne. Computerization Melbourne Reorganization Newbenefits (i) What is the highest level of normal form for the table? (ii) Describe the insertion, update and delete anomalies that can happen on the table. Albury Perth
Expert Answer:
Answer rating: 100% (QA)
i The highest level of normal form for the table is the third normal form 3NF ii Insertion anomaly An insertion anomaly can occur if we try to insert a new row into the table but one or more attributes cannot be inserted because they are not dependent on the primary key alone For example if we want to insert a new project but we cannot do so without assigning it to an employee and the table does not allow for projects without employees we have an insertion anomaly Update anomaly An update anomaly can occur when updating a row in the table causes inconsistencies For example if we update the hours worked by an employee on a project we need to ensure that all instances of that employees participation in that project are updated correctly If we miss one the data becomes inconsistent Delete anomaly A ... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
determine how many Configurable logic block (CLB) you would need for 4-bit multiplier to be implemented in the FPGA if you know that the CLB structure are: Look-Up Table (LUT) D SET Q MUX 59 CLR Q...
-
Draw a topology on paper that will show the connection between home network and College (LAN) using conventional symbols used in networking? (10) Home Network: 1 connecting device 1 Wireless devices...
-
How many years will it take for $850 per year to accumulate to $20,000 if the interest rate is 8%?
-
A flying bug hits the helmet of a coasting bicyclist. (What kind of collision do you expect this to be?) Draw the momentum vectors for the bug and the bicyclist before and after the collision \((a)\)...
-
Write short notes on counter boring, counter sinking, spot facing, and trepanning.
-
1. Which of Schwartzs ten values are driving the behavior of managers at Bain & Co., Home Depot, and Best Buy? Provide examples to support your conclusions. 2. How would you describe Steve Elliss...
-
What is the difference between a stack and a queue data structure?
-
Journalize the transactions. January 31: Sales for the month totalled $ 96 comma 000 (not including HST) of which 90 percent were on credit. The company collects 13 percent HST on all sales and...
-
Which of the following is a key attribute of corruption schemes? 1. Corruption schemes usually involve an elected official. 2. Corruption schemes usually involve an official operating in an official...
-
Which of the following is not a common reason why senior management might overstate or understate business performance? 1. Pressures to boost revenues or expenses 2. Improperly designed incentive...
-
Which of the following most accurately indicates why conflicts of interest create concern? 1. In a conflict of interest, a person accepts illegal payments as a direct result of their actions. 2. A...
-
Explain what is meant by the human factor? 1. The human factor means that all persons suffer from fits of bad judgment, which leads to fraud. 2. Greed is the defining human factor. 3. Human failings...
-
Which of the following is not a methodology by which financial statement fraud is committed? 1. Manipulation of revenue 2. Manipulation of asset valuations 3. Manipulation of disclosures 4....
-
A new product development project has elapsed four weeks. It means that the status period is end of Week 4. The monitoring team has reported the project updates as given in the following table....
-
1. Which of the four major types of information systems do you think is the most valuable to an organization? 2. How do you critically associate the ideas of business agility and business efficiency...
-
Find a parametrization of the tangent line at the point indicated. r(s) = (ln s)i + s 1 j + 9sk, s = 1
-
Find the minimum and maximum values of the function on the given interval by comparing values at the critical points and endpoints. y = x- 4x x+1' [0, 3]
-
Find the intervals on which is concave up or down, the points of inflection, the critical points, and the local minima and maxima. (x) = cos 2 x, [0, ]
-
An investment bank offers a derivative whose payoff at maturity T is given by S 2 T , where ST is the price of the underlying asset, a non-dividendpaying stock share with a price following a GBM....
-
Let us consider an activity, whose level is measured by a continuous decision variable . A concrete example would be the amount of an asset that we purchase. The cost of the activity may include both...
-
Consider the following one-dimensional problem: This is a concave problem, since the leading term in the quadratic objective is negative, so that the second-order derivative is negative everywhere....
Study smarter with the SolutionInn App