Reference no: EM1367087
Q1 Consider a relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}
1) Compute a canonical cover for the above set of functional dependencies (show each step of your derivation with an explanation).
2)Compute the closure of AF and then determine whether or not AF is a candidate key.
3) Suppose that (A,B, F) is decomposed into (A, F) and (B, F). Given the above functional dependencies, is this decomposition always lossless? If so, prove this. Otherwise, explain it using an example.
4) Determine whether or not (A,E, F) is in BCNF and justify your answer. If (A,E, F) is not in BCNF,find a BCNF decomposition of it
Q2 functional dependencies α->β and γ-> β do not imply α->γ prove this using an example relation.
|
Find features and capacities for web server computer
: Find out the features and capacities (RAM, disk storage, processor speed) that Amy should include in the Web server computer that she will require for her site.
|
|
Analyzing the world health situation
: Describe and analyze the world health situation. What is the greatest problem facing the world population?
|
|
Write program to compute volume flow rate
: Write program to compute volume flow rate in cubic feet per second of water flowing through a pipe of diameter d in inches and a velocity of v feet per second.
|
|
Main factors which affecting current price of gasoline
: Discuss the main factors (supply and demand) affecting the current price of gasoline. Include at least two supply and two demand.
|
|
Explain relation schema and set of functional dependencies
: Consider relation schema r(A,B,C,D,E, F) and a set of functional dependencies {A BCD,BCDE,BD,DA}. Calculate canonical cover for set of functional dependencies (show each step of your derivation with an explanation).
|
|
Human development theory-current developmental stage
: Explain the human development theory which best reflects your present developmental stage. How is the selected theory linked with your status and as adult learner?
|
|
What are normal goods
: What are "normal" goods? Give an example in our current economy and what are "inferior" goods? Give an example in our current economy.
|
|
Cervical-ovarian and uterine cancer
: Recognized the main differences between the cervical, ovarian, and uterine cancer. Compared the benign and malignant tumors of the cervix, uterus, and ovaries.
|
|
Calculations of loan fees income
: An FI makes a loan commitment of $2,500,000 with an up-front fee of fifty basis points and a back-end fees of 25 basis points on the unused portion of loan. The takedown on the loan is 50 percent.
|