Reference no: EM131052414
Question 1. Given R= {C, S, J, D, P, Q, V} and set of functional dependencies {FD1: JP->C, FD2:SD->P, FD3: J->S}
a. Find key (s) of R. (number each candidate key for full credit and show your work for credit)
b. Decompose R to get R' in 2NF, 3NF and BCNF. (use the FD labels given above to identify FDs. RX (W, X, Y, Z). each relation should show the FDs.
2NF relations are:
3NF tables are:
c. Normalize the relation to 2NF and then 3NF. (hint recall the generalized definition of 2NF and 3NF), (use the FD labels given above to identify FDs. Each relation should be shown in the form RX (W, X, Y, Z). each relation should show the FDs that hold for that relation describe your reasoning clearly.
2NF relations are:
3NF tables are:
Question 2. given R (A, B, C, D, E), with functional dependencies AB-> D, AC->E, BC-> D, D->A, and E->B. we want to project those FDs on to relation S (A, B, C). give the FDs that hold in S. (label and number each FD that holds in S. each relation should be shown in the form RX (W, X, Y, Z). describe your reasoning clearly.
Question 3. given R (A, B, C) with key AB-> C. (parts A and B are unrelated)
a. show one added additional dependency that causes a 2NF violation.
b. Show two added dependencies that cause a BCNF violation.
Question 4. given R (A, B, C, D, E, F) with functional dependencies:
{FD1: ABD -> C, FD2: CD-> B, FD3: CDF -> BE, FD4: BDF->C}
a. Find and number the candidate keys using the given functional dependencies. Show your work and reasoning for credit.
b. What are the prime attributes of F?
Question 5. given the relation R (J, K, L, M, N) with the functional dependencies.
JK-> L, KL->M, LM -> N, MN-> J and NJ-> k
Is this relation in BCNF?
(you must show all the work and reasoning that led you to a conclusion. This question cannot involve transformation to 2NF, 3NF etc. answer should be based solely on the dependencies of BCNF)
(hint: you can use the fact that AB-> C is equivalent to ABD-> CD)
Question 6. let R (A, B, C, D, E) be decomposed in to relations with the following three sets of attributes R1: {A, B, C}, R2: {B, C, D} and R3: {A, C, E}.
Given the following FDs:
FD1: A-> D, FD2: D->E, FD3: B->D
Using the chase algorithm, determine whether decomposition is lossless join.
(if necessary, apply FDs in order shown, clearly show the result of each application of an FD. And clearly show that final answer each tableau where a change has occurred should be shown.)
Discuss the vulnerabilities associated with four
: Discuss the vulnerabilities associated with four of the ten networks described in your readings. Make sure you identify the network, potential vulnerabilities, and what the result could be from an attack against it.
|
Compute the gross-margin percentage for each of pharmaguards
: BUACC2613 Management Accounting Group Assignment. Compute the 2015 gross-margin percentage for each of Pharmaguard's three market segments. Compute the cost driver rates for each of the five activity areas
|
Determined with the most precision
: When working with the CAPM, which of the following factors can be determined with the most precision? The market risk premium (RPM). The expected rate of return on the market, rM. The beta coefficient of "the market," which is the same as the beta of..
|
Change to one of the cloud computing service
: In your current business environment, or one you were in at one time, which of the four cloud computing service models do you think might be good for that company to consider? How would a change to one of the cloud computing service models change ..
|
Normalize the relation to 2NF and then 3NF
: Normalize the relation to 2NF and then 3NF - Find and number the candidate keys using the given functional dependencies. Show your work and reasoning for credit.
|
Find the dividend yield on the index and the interest rate
: You can find spot and futures prices for a variety of equity indexes on www.wsj.com (or in the Datastream database available in the library). Pick one and check whether it is fairly priced. You will need to do some detective work to find the dividend..
|
Complete a cta on the culture of the cold war
: Complete a CTA on the secondary source, "The Culture of the Cold War" by Stephen J. Whitfield. You can access CTA guidelines and sample by clicking: How to do a Critical Thinking Analysis.
|
Multi-layered security plan
: You are a network security specialist at Richman Investments, a mid-level financial investment and consulting firm. The Richman corporate headquarters is located in Phoenix, Arizona. Currently, there are eight branch offices in: Atlanta, Georgia ..
|
A coupon bond that pays interest quarterly
: A coupon bond that pays interest quarterly has a par value of $1000, matures in 5 years, and has a yield to maturity of 7.5%. If the coupon rate is 10%, the value of the bond today will be __________.
|