# Database Theory Assignment

Hi,

I need to get this assignment done quickly, (by this saturday). It is a University level Database Systems assignment, based on Normalization, functional dependencies, Armstrong's Axioms, and minimal cover sets. I have attached the assignment in a file.

The assignment must be forwarded to me either in DOC or PDF format, and it needs to be clear, legible, thoroughly correct, and precise.

Assignment 1

1. Given the following relationship R and set of functional dependencies F:

R = {A,B,C,D,E,F,G,H,I}

F = { {C,D} -> {A},
{G} -> {E},
{C,D,E} -> {G,B,H},
{B} -> {F},
{H} -> {I}
}

a) Identify a suitable key.
b) Decompose the relation to second normal form.
c) Decompose the resulting relations to third normal form, if possible.
d) Decompose the resulting relations to Boyce Codd normal form, if possible.
di)

2. Prove that every two attribute relation must satisfy second normal form.

3. Given a relation schema R = {A,B,C,D,E} and a set of functional dependencies F consisting of the following dependencies:

F = { {A->C}, {AC->E}, {AD} -> {B}, {B} -> {ADE} and {D} -> {E} }

show that the closure of F+ contains the following functional dependencies:
A-> E
B-> C
ABC -> A
Use Armstrong's Axioms and show the steps involved.

4. Using the same set F as in question 3, calculate the closure for each of the following attribute
sets:
a) {D}
b) {E}

5. Given R = (A,B,C,D,E) and F as { {AB}->{C}, {C}->{D}, {D}->{AE}, {E}->{B}}. F is a
minimal cover set.
Check if the following decomposition has the lossless-join property (non-additive).

R1 = (ABCE) and R2 = (CD)

Compétences : Algorithme, Administration de Bases de données, Ingénierie, SQL

Concernant l'employeur :
( 1 commentaire ) Galway, Ireland

N° du projet : #1667180

## Décerné à :

liuxinran

Hi, I can do this for you, please check the PM.

10 € EUR / heure
(13 Commentaires)
4.0

## 9 freelances ont fait une offre moyenne de 14 € /heure pour ce travail

samitXI

10 € EUR / heure
(21 Commentaires)
6.3
manhpham

15 € EUR / heure
(13 Commentaires)
4.3
bouslimi1979

10 € EUR / heure
(5 Commentaires)
3.7
minhtridn2001

15 € EUR / heure
(5 Commentaires)
2.9
LogicalError

hi bro do check you PM

10 € EUR / heure
(1 Commentaire)
2.3
aleexaibi

hi i am expert in database and can do your assignment :)

10 € EUR / heure
(1 Commentaire)
1.5
E0mZD5L8e