You have chosen to sponsor your bid up to a maximum amount of .
I have a coursework submission. There are 3 questions over there. If you know the contents its easy as pie. Problem is, I need it done in 10hrs time. The work should not take more than 1hr if you are familiar with it.
1. Dependency diagrams - BCNF
2. Multi-valued dependecies
Detailed specs will come later once you connect me.
Additional Project Description:
08/22/2013 at 19:56 BST
My budget is £50.
I plan to get it done asap. My deadline is in 10hrs. Besides, just to let you know, the question involves writing up an oracle query and some small theory
. Use the following relation for this question:
Supplier number Product Producer
01234 Coffee CoffeeWorld
01234 Battenberg Greens
00022 Coffee CoffeeWorld
00022 Battenberg Keppels
02468 Battenberg Greens
Draw a dependency diagram which identifies the functional dependencies, and
subsequently identify the set of candidate keys for this relation. Explain why this
relation is not in Boyce-Codd Normal Form (BCNF), but is in 3NF, and
subsequently create a set of relations (using Oracle SQL) which are in BCNF.
Ensure that you define all primary and foreign keys as necessary