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.
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
16 freelancers are bidding on average £86 for this job
[url removed, login to view] and M.Sc. Engg both in computer engineering. Analyst programmer over than 9 years.I can do it perfectly within your time duration. pls check me out