Consider the following set F of functional dependencies on the relation schema r (A, B, C, D, E, F)
A --> BCD
BC --> DE
B --> D
D --> A

Part (1)
Compute B+
Part (2)
Compute a canonical cover for the above set of functional dependencies F
Part (3)
Give a 3NF decomposition of r based on the canonical cover
Part (4)
Give a BCNF decomposition of r using original set of functional dependencies.
Part (5)
Can you get the same BCNF decomposition of r as above, using the canonical cover?

You turn your computer on and the computer will not boot up where is something you should do to diagnose the problem?

1. technician a says horsepower information can be used by consumers to compare the power of different automobile engines. technician b says that manufacturers will often list the horsepower output of their engines in the online service information. who is right?

The “rule of 72” is used to approximate the time required for prices to double due to inflation. if the inflation rate is r%, then the rule of 72 estimates that prices will double in 72/r years. for instance, at an inflation rate of 6%, prices double in about 72/6 or 12 years. write a program to test the accuracy of this rule. for each interest rate from 1% to 20%, the program should display the rounded value of 72/r and the actual number of years required for prices to double at an r% inflation rate. (assume prices increase at the end of each year.)