Functional Dependencies

Project needs to be done within 2 hours. Using the functional dependencies provided, normalize each of the following relations, R1, R2, and R3 to the third normal form

You should assume that there are no duplicate rows present and that all values are atomic. Each solution must clearly identify the steps required to normalize the relation to 3NF and demonstrate that it is lossless and preserves all functional dependencies.


FDs: AB  D, B  C, B E, AH, H  G


FDs: ABCDE, BC G, G  HF


FDs: BC DE, C F, FGH

Færdigheder: SQL

Se mere: functional , atomic, relation client design project, duplicate values, detail steps project, conversion steps project cnet

Om arbejdsgiveren:
( 9 bedømmelser ) chicago, United States

Projekt-ID: #6035167

2 freelancere byder i gennemsnit $38 for dette job


Hi, I have gone through your requirements.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL Server,Oracle database, I can do your job confidently. For your reference you can see my feedback. Mere

$45 USD på 1 dag
(8 bedømmelser)

A proposal has not yet been provided

$30 USD in 2 dage
(0 bedømmelser)