Đang Thực Hiện

Database Theory Assignment


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.

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
AD -> C
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
a) {D}
b) {E}
c) {AD}
Show your workings.

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)

Kĩ năng: Thuật toán, Quản trị cơ sở dữ liệu, Kĩ thuật, SQL

Xem nhiều hơn: assignment, sql pdf file, theory, normalization, engineering systems, axioms, ARMSTRONG, pdf file database, database systems assignment, database university, systems theory, assignment engineering, university level, normalization sql, database pdf file, database sql assignment, theory assignment, need engineering assignment done, assignment pdf, assignment database, database assignment theory, sql normalization, database assignment done, database assignment sql, systems engineering assignment

Về Bên Thuê:
( 1 Nhận xét ) Galway, Ireland

ID dự án: #1667180

Được trao cho:


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

€10 EUR / giờ
(13 Đánh Giá)

9 freelancer đang chào giá trung bình €14/giờ cho công việc này


Please check your inbox. Thanks

€10 EUR / giờ
(21 Nhận xét)

I am ready to help you. Please contact me asap.

€15 EUR / giờ
(13 Nhận xét)

Please check PM. Thanks

€10 EUR / giờ
(5 Nhận xét)

Willing to help you in this project. Regards, Tri

€15 EUR / giờ
(5 Nhận xét)

hi bro do check you PM

€10 EUR / giờ
(1 Nhận xét)

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

€10 EUR / giờ
(1 Nhận xét)

<i>The Administrator removed this message for containing contact details which breaches our Terms of Service</i>

€33 EUR / giờ
(0 Nhận xét)

i would like to work in this project.

€10 EUR / giờ
(0 Nhận xét)