Reference no: EM1364363
Q1 Consider a relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}
1) Compute a canonical cover for the above set of functional dependencies (show each step of your derivation with an explanation).
2)Compute the closure of AF and then determine whether or not AF is a candidate key.
3) Suppose that (A,B, F) is decomposed into (A, F) and (B, F). Given the above functional dependencies, is this decomposition always lossless? If so, prove this. Otherwise, explain it using an example.
4) Determine whether or not (A,E, F) is in BCNF and justify your answer. If (A,E, F) is not in BCNF,find a BCNF decomposition of it
Q2 functional dependencies α->β and γ-> β do not imply α->γ prove this using an example relation.
|
Explain security strategy for a corporate wan
: Prescribe a security strategy for a corporate WAN. Be sure to include methods to combat both technical and nontechnical attacks. C
|
|
Computing current price of the stock
: A Corporation will pay a $2 per share dividend in one year. The dividend in 2 years will be $4 per share, and it is expected that dividends will grow at 5% per year thereafter.
|
|
Explain soda can company is opening up a new store location
: Explain Soda Can Company is opening up a new store location in sixty days and As Executive Director of Stores you have to put together a strong team quickly
|
|
Find the level of retained earnings
: My company showed retained earnings of $400,000 on its balance sheet past year. This year, the company's earnings per share were $3 and its dividends paid each share were $1.00.
|
|
Find bcnf decomposition of relation schema
: Consider a relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Determine whether or not (A,E, F) is in BCNF and justify your answer. If (A,E, F) is not in BCNF,find a BCNF decomposition of it.
|
|
How fast will the electron be moving
: How fast will the electron be moving. What was his average speed (in m/s) for the race.
|
|
Healthcare professionals within organization
: The research will assist the director in assessing that all healthcare professionals within organization have the appropriate license or certification.
|
|
Ruben corporation-breakeven point
: Corresponds to CLO 2(c) Ruben Corporation manufactures and sells T-shirts imprinted with college names and slogans. Last year, the shirts sold for $7.50 each, and the variable cost to manufacture them was $2.25 per unit.
|
|
Increase the effectiveness of workplace communication
: Show what steps can you take as a vested worker to increase the effectiveness of workplace communication
|