2.Given the scheme R= (ABCDEF), and following set of functional dependencies:
F = (AB®C, C®A, BC®D, ACD®B, D®EF, BE®C, CF®BD, CE
...
, ACD®B, D®EF, BE®C, CF®BD, CE ®AF).
(a) Find (BD)+
(b) Find (AB)+
(c) Find Candidate Keys for R
Question 3
Given the scheme R= (ABC), and following set of functional dependencies:
F = (A®BC, B® AC, C ® AB).
(a) Find closure (BC, F)
(b) Find at least one candidate key for R.
(c) Find at least one super-key for R which is not the same as your answer in
(b).
(d) Find at least one minimal cover for a relational scheme (ABC). Show work.
(e) Provide a 3NF decomposition for R.
Question 4
Consider the following set of FDs:
F = (A ® B, AB ® C, D ® AC, D ® E)
G = (A ® BC, D ® AE)
H = (A ® BC, B ® C, A ® B, AB ® C, AC ® D).
(a) Is F ≡ G? Show your work.
(b) Find the minimal cover for H. Show work.
View More
3.Let’s assume that you have a company that buys goods from a local factory and you resell them online.
You buy
...
ne.
You buy product A for $16 and sell it for $19. Each unit of product B brings you $12 of profit and each unit of product C costs $31.
You lost your inventory books but you have the following information about the last month:
Your total profit was $17,334
The total number of products B and C you sold were 1,269
The only delivery of product C you received was for $15,531
You fulfilled an order for one product A and one product C and you charged the customer $56.
Find the number of sold items and the profit for each product.
View More
4.Let’s assume that you have a company that buys goods from a local factory and you resell them online.
You buy
...
ne.
You buy product A for $16 and sell it for $19. Each unit of product B brings you $12 of profit and each unit of product C costs $31.
You lost your inventory books but you have the following information about the last month:
Your total profit was $17,334
The total number of products B and C you sold were 1,269
The only delivery of product C you received was for $15,531
You fulfilled an order for one product A and one product C and you charged the customer $56.
Find the number of sold items and the profit for each product.
View More
6.Hi there, I've been struggling with the problem for quite a while and i have not been able to find
...
formula online to help.. It should be a simple straightforward problem but i just can not for the life of me figure it out. are you able to provide me with a formula or point me in the right direction?
The problem is:
Solution A has a 50% concentration
Solution B has a 100% concentration
Solution C has a 5% concentration
you have 5L of each solution to utilize as well as unlimited quantities of water to dilute solution concentrations if needed.
Part A
Make a final solution of 100ml with solution concentrations of Solution A 15%, solution C 5% and solution C 80%. how much of each solution will you need to make your final 100ml solution?
Part B
using the above solutions how many 100ml final solutions can you produce with the 5L volumes?
No matter how I work it i can't make the solution to the correct concentrations.
Thank you for your help.
John
View More
7.Hi there, I've been struggling with the problem for quite a while and i have not been able to find
...
formula online to help.. It should be a simple straightforward problem but i just can not for the life of me figure it out. are you able to provide me with a formula or point me in the right direction?
The problem is:
Solution A has a 50% concentration
Solution B has a 100% concentration
Solution C has a 5% concentration
you have 5L of each solution to utilize as well as unlimited quantities of water to dilute solution concentrations if needed.
Part A
Make a final solution of 100ml with solution concentrations of Solution A 15%, solution C 5% and solution C 80%. how much of each solution will you need to make your final 100ml solution?
Part B
using the above solutions how many 100ml final solutions can you produce with the 5L volumes?
No matter how I work it i can't make the solution to the correct concentrations.
Thank you for your help.
John
View More
11.Let U =
{3, 4, 5, 6, 7, 8, 9, 10},
A =
{4, 6, 8},
B =
...
. Find the following. (Enter your answers as a comma-separated list.)
(A ∪ B)'
View More
12.Hi, I have one question on my math homework that I can't seem to figure out. Please help me! Here
...
is Imagine that in the voting for a certain award, 7 points are awarded for first place, 4 points for second, 3 points for third, 2 points for fourth, and 1 point for fifth. Suppose there were five candidates (A, B, C, D, and E) and 47 voters. When the points were tallied, A had 155 points, B had 173 points, C had 170 points, and D had 154 points. Find how many points E had and give the ranking of the candidates. (Hint: Each of the 47 ballots hands out a fixed number of points. Figure out how many, and take it from there.)
View More