Question: DATABASE MANAGEMENT SYSTEMS 2. Given the relation R(A, B, C, D, E, F, G) and the function dependencies FD1: E ? {C,G} FD2: {F,G} ?

DATABASE MANAGEMENT SYSTEMS

2. Given the relation R(A, B, C, D, E, F, G) and the function dependencies

FD1: E ? {C,G}

FD2: {F,G} ? {A,B,E}

FD3: {B,C} ? D

Note: You will have to infer two additional FDs that are in F+ before transforming from 2NF to 3NF

2b. Identify all candidate keys using either the synthesis OR decomposition method. Show each step. Candidate key(s):

2c. Is the relation in 2NF?

2d. Why or why not?

2e. Write the relation(s) in 2NF here, the FDs, and candidate keys for each relation. If already in 2NF, just write the relation:

2f. Are the relation(s) you provided in question 2e in 3NF? ______

2g. Why or why not?

2h. Write the relation(s) in 3NF here, the FDs, and candidate keys for each relation. If already in 3NF, just write the relation(s):

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Insert anomaly means the inability to create a new record due to the absence of other data (2 points) True False 2 Specialization S: S = {V1, V2, ..., vn) is a set of subclasses with the same...

Q:

10 Given a relation R (A, B, C, D, E, F, G, H, I) which is in 3NF. The primary key is a composite key of two attributes A and B. Which of the following inal dependencies must be FALSE? --- * *** --...

Q:

answer 10 Given a relation R (A, B, C, D, E, F, G, H, 1) which is in 3NF. The primary key is a composite key of two attributes A and B. Which of the following functional dependencies must be FALSE?...

Q:

3. Consider the relation R (A, B, C, D, E, F, G) and the set of FD as follows. FD1: E C FD2: G AD FD3: B E FD4: C BF a) Give one example of non-trivial functional dependency implied by the ones...

Q:

CSE 4 5 0 3 / 6 5 0 3 Total 5 2 points 1 . Write the definitions of 1 NF , 2 NF , 3 NF and BCNF . ( 4 * 2 . 5 = 1 0 points ) 2 . Consider the universal relation R = { A , B , C , D , E , F , G , H ,...

Q:

(a) Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J and the set of functional dependencies F = { {A, B} {C}, {A} {D,E}, {B}{F}, {F}{G,H}, {D} -> {I, J}}. 1. Derive the key for R....

Q:

Subject: Databases Question: Consider the universal relation R = {A, B, C, D, E, F, G, H, I, J} and the set of functional dependencies G = { {A, B} -> {C}, {B, D} -> {E, F}, {A, D} -> {G, H}, {A} ->...

Q:

Part (e) Problem 8 Consider a relation R (A, B, c, D, E, F, G, H) together with the functional dependencies AB E CD onsider RI (A, B, C, D) with the above functional dependencies. What would be a...

Q:

Normalization Assignment Consider the universal relation R = {A, B, C, D, E, F G, H I, J} and the set of functional dependencies R = {{A, B} -> { C}, {A} ->{D, E}, {B} -> { F}, F->{G, H}, {D}->{I,...

Q:

Q4-A (6 marks) Consider the relation R (A, B, C, D, E, F, G) and the set of functional dependencies Fd = {A->B, BC->F, BD->EG, AD->C, D- >F, BEG->FA}. Determine if we can infer the following...

Q:

A loan of $3,300 at 8 3/4% simple interest was made on March 23. On what date was it repaid if the interest cost was $137.96?

Q:

In a major speech, Arthur Levitt, former chairman of the SEC, chided auditors for failures in four areas: Allowing companies to use "cookie jar reserves" used by firms to manage earnings. Allowing...

Q:

CAPM and Valuation You are considering acquiring a firm that you believe can generate expected free cash flows of 1 0 0 0 0 a year forever However you recognize that those cash flows are uncertain LO...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

In addition to patterns of interaction, in what ways are organizational structure and strategy responsible for the managerial climate?

Q:

What would be an example of line responsibilities that have been inappropriately assumed by a staff function? What would it take for the line operations to reclaim their appropriate role?

Q:

Employee participation in organizational decision making was, as McGregor reports, viewed with skepticism at the time he was writing. Is it now more widely valued and utilized? If so, why? If not,...