Given the relation COMPENSATION as shown in Table 1, let P: SALARY < 80,000 and P2:...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Given the relation COMPENSATION as shown in Table 1, let P: SALARY < 80,000 and P2: SALARY > 80, 000 be two simple predicates. (a) Perform a horizontal fragmentation of relation COMPENSATION with respect to predicates 3 (P1, P2). Show the resultant fragments. (b) Explain why the resulting fragmentation (COMPENSATION, COMPENSATION} does not fulfill the 2 correctness rules of fragmentation. (c) Modify the predicates p and p2 so that they partition the COMPENSATION relation obeying 3 the correctness rules of fragmentation. Show the resultant fragments. Homework 1 - CS 472/572 COMPENSATION TITLE DEPT Programmer Maps Supervisor Maps Sr. Analyst Web 80,000 Analyst Web 65,000 Manager Maps 92,000 Admin Enterprise 102,000 Engineer Enterprise 88,000 Table 1: COMPENSATION relation SALARY 75,000 68,000 Page 2 of 4 Given the relation COMPENSATION as shown in Table 1, let P: SALARY < 80,000 and P2: SALARY > 80, 000 be two simple predicates. (a) Perform a horizontal fragmentation of relation COMPENSATION with respect to predicates 3 (P1, P2). Show the resultant fragments. (b) Explain why the resulting fragmentation (COMPENSATION, COMPENSATION} does not fulfill the 2 correctness rules of fragmentation. (c) Modify the predicates p and p2 so that they partition the COMPENSATION relation obeying 3 the correctness rules of fragmentation. Show the resultant fragments. Homework 1 - CS 472/572 COMPENSATION TITLE DEPT Programmer Maps Supervisor Maps Sr. Analyst Web 80,000 Analyst Web 65,000 Manager Maps 92,000 Admin Enterprise 102,000 Engineer Enterprise 88,000 Table 1: COMPENSATION relation SALARY 75,000 68,000 Page 2 of 4
Expert Answer:
Answer rating: 100% (QA)
Given the image it looks like part of a homework assignment dealing with database fragmentation Unfortunately the image doesnt fully display all the necessary content for question c and neither result... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
As in almost every field, the job market for the best jobs in web development are competitive. One way to give yourself a big edge in a job search is to create an appropriate personal portfolio...
-
QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...
-
2) Assume that your widget manufacturing company has a total annual demand of N widgets per year evenly distributed across the year. Each widget cost $b dollars in material and manufacturing costs to...
-
A Global Positioning System satellite orbits 12,500 miles above Earth's surface (see figure). Find the angle of depression from the satellite to the horizon. Assume the radius of Earth is 4000 miles....
-
The accounting records of Clay Ceramics included the following at January 1, 2012: In the past, Clays warranty expense has been 8% of sales. During 2012, Clay made sales of $136,000 and paid $7,000...
-
Two identical particles of inertia \(m\) collide elastically on a low-friction table. Calculate the kinetic energy of the system before and after the collision in the zero-momentum frames.
-
The following two events occurred for Trey Co. on October 31, 2013, the end of its fiscal year. a. Trey rents a building from its owner for $2,800 per month. By prearrangement, the company delayed...
-
The _ _ _ _ function enables you to retrieve separate characters in a string. A . at ( ) B . char _ at ( ) C . indexof ( ) D . value _ of ( )
-
Barolo Company manufactures laptop stickers for Italian sports teams. Barolo's risk management team has identified the company's top five inherent risks and plans to manage them using a typical ERM...
-
Ron was vacationing in France, when his camera was stolen. As he walked into a camera store, Ron noticed that camera prices were in euros. If Ron was willing to pay $250 for a new digital camera and...
-
How do Freudian and Jungian approaches to symbolism illuminate the psychoanalytic dimensions of literary texts, uncovering unconscious desires, fears, and complexes encoded within symbolic imagery...
-
How do contemporary authors employ postmodern techniques such as bricolage, pastiche, and intertextuality to subvert conventional symbolic frameworks, destabilize fixed meanings, and challenge...
-
Write a Java class in which you include the following: 1. A main method that: a. Declares a-one dimensional array of 10 integer elements. b. Asks the user to fill the array. c. Ask the user to enter...
-
How do post-structuralist literary theories, such as Derridean deconstruction and Barthesian semiotics, challenge traditional notions of textual stability, authorial intentionality, and the fixed...
-
Problem: Concert Security Total Points: 50 Imagine you're a software developer for a stadium where your favorite K-pop group, TWICE, is having a concert. Before a person gets into the concert, there...
-
The following receivables ledger control account prepared by a trainee accountant contains a number of errors: RECEIVABLES LEDGER CONTROL ACCOUNT $ 614,000 311,000 20X4 1 Jan Balance 31 Jan Cash from...
-
Smiths Family Fashions implemented a balanced scorecard performance measurement system several years ago. Smiths is a locally owned clothing retailer with fashions for men, women, teens, and...
-
Problem 15, part f. in Chapter 3 asks you to construct a five year financial projection for Aquatic Supplies beginning in 2015. The five year projection appears below. a. Calculate Aquatic Supplies's...
-
a. What were HCA's liabilities-to-assets ratios and times-interest-earned ratios in the years 2005 through 2009? b. What percentage decline in EBIT could HCA have suffered each year between 2005 and...
-
a. What does it mean when a companys free cash flow is negative in one or more years? b. Do negative values of free cash flow in any way alter or invalidate the notion that a companys fair market...
-
Discuss how a new brand manufacturer would go about defining their market segments and then begin to target them.
-
Go to www.kellogs.com, and examine the brands offered by Kelloggs. Using the BCG growth-share matrix, classify 10 brands as stars, question marks, cash cows, or dogs. Find at least one product you...
-
Diff Eyewear is a successful business built around a socially conscious mission. The company makes and sells stylish eyewear with comparable quality but a significantly lower price than luxury...
Study smarter with the SolutionInn App