1) Use Armstrong's axioms to prove the soundness of the pseudotransitivity rule.
Consider the...
![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 05.05.2020 09:04 raularriaga
1) Use Armstrong's axioms to prove the soundness of the pseudotransitivity rule.
Consider the relation schema R = (N, Y, P, M, C) and assume that the following set of functional dependencies holds on:
R: F = { N β M, NY β P, M β C}
The letters can be interpreted as follows: R = (Model_Number, Year, Price, Manufacturing_Plant, Color).
2) Evaluate each of the following as a candidate key for R, giving reasons why it can or cannot be a key: N, NY, NC.
3) Find all the candidate keys of R.
4) Show that the functional dependency NY β P does not contain extraneous attributes.
5) Show that F is already in canonical cover form.
6) Consider the decomposition d = (R1, R2) where R1 = (N, Y, P) and R2 = (N, M, C).
Is this decomposition lossless-join? Make sure to justify your answer and to show all details.
![ansver](/tpl/images/cats/User.png)
Answers: 2
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 07:50
Apython programming question: assume s is a string of lower case characters. write a program that prints the number of times the string 'bob' occurs in s. for example, if s = 'azcbobobegghakl', then your program should print number of times bob occurs is: 2
Answers: 3
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 11:00
What is the name of the sound effect that danny hears
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 23:30
The keyboard usually has six rows of keys. which of the following is not one of the key group categories? letter keys number keys control keys graphic keys
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 25.06.2019 05:00
The ratio of men to women in a certain factory is 3 to 4 .there are 210 men.how many workers are there?
Answers: 2
You know the right answer?
Questions
![question](/tpl/images/cats/mat.png)
Mathematics, 25.02.2021 18:30
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/pravo.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/istoriya.png)
History, 25.02.2021 18:30
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 25.02.2021 18:30
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/istoriya.png)
History, 25.02.2021 18:30
![question](/tpl/images/cats/en.png)
English, 25.02.2021 18:30
![question](/tpl/images/cats/mat.png)
Mathematics, 25.02.2021 18:30