SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 5 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 09 Dec 2017 My Price 7.00

Evaluate each of the following as a candidate key for R,

Consider the relation schema R = (N, Y, P, M, C) and assume that the following set of functional dependencies hold on R:

 

       F = { N → M, NY → P, M → C}

       The letters can be interpreted as follows: R = (Model_Number, Year, Price, Manufacturing_Plant, Color).

1.Evaluate each of the following as a candidate key for R, giving reasons why it can or cannot be a key: N, NY, NC.

2.Find all the candidate keys of R.

3.Give a lossless-join decomposition of R into Boyce-Codd normal form. Make sure to use the algorithm studied in class (slide 8.46) and to show all details.

4.Does your decomposition preserve functional dependencies? Justify your answer.

5.Is R in 3NF?

6.Show that the functional dependency NY → P does not contain extraneous attributes.

7.Show that F is already in canonical cover form.

8.Use the algorithm we studied in class (slide 8.56) to find a lossless-join and dependency preserving decomposition of R into 3NF. Make sure to show all details.

9.Consider the decomposition d = (R1, R2) where R1 = (N, Y, P) and R2 = (N, M, C). Is this decomposition lossless-join? Make sure to justify your answer and to show all details.

10.Consider the decomposition d = (R1, R2, R3) where R1 = (N, M), R2 = (M, C) and R3 = (P, Y). Is this decomposition dependency preserving? Make sure to justify your answer and to show all details.

 

Answers

SophiaPretty
(5)
Status NEW Posted 09 Dec 2017 07:12 AM My Price 7.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)