Database Oracle SQL

Avg Bid (GBP)
Project Budget (GBP)
£20 - £250

Project Description:
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.

Questions involves
1. Dependency diagrams - BCNF
2. Multi-valued dependecies
3. 5NF

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

Skills required:
Database Administration, Oracle, SQL
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

£ 55
in 1 days
£ 50
in 0 days
£ 50
in 1 days
£ 49
in 1 days
£ 55
in 1 days
£ 150
in 3 days
£ 111
in 1 days
£ 77
in 0 days
£ 100
in 1 days
£ 150
in 3 days